What is maximum length of a table name, database name and field name in Mysql?

Question

I have started learning PHP and got a thought about mysql.

I did google and found this stack overflow link
http://stackoverflow.com/questions/625930/what-is-the-maximum-size-of-a-mysql-database-in-version-5-and-up

But there are less answers and more discussions. Can someone give me the right answer which has full description in it.

Answer 1

I have not tested by as per the following documentation it is 64 in all three cases
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

Identifier    Maximum Length (characters)
Database      64
Table         64
Column        64
Index         64
Constraint    64
Stored Procedure or Function    64
Trigger       64
View          64
Alias         256 
Compound Statement Label    16