[SOLVED] Naming a MySQL table with numbers

[BrianM]

I've tried naming a table with numbers in it and it wont seem to work... is my SQL installation broken or is this just how the program defaults, and is there a way to use numbers in MySQL table names?

[PFMaBiSmAd]

From the mysql manual -

Identifiers may begin with a digit but unless quoted may not consist solely of digits.

[BrianM]

So my SQL table name can consist of all digits?

[BrianM]

Well I see nowhere in the identifier qualifiers manual on the MySQL website that explains how to create a table name with all numbers... or whether or not it can even be done. Anyone have a better reference? Or maybe just show me the correct syntax for this, please.

[dptr1988]

It's a shame that you will double post but not even bother to check your other post. Here is my response in the other post: http://www.phpfreaks.com/forums/index.php/topic,193221.0.html.

 

Here is a sample table definition that shows how to use all numbers for your idents:

CREATE TABLE `34` (
`123` INT
);

 

You can quote the numbers with the backtick('`') char.