I need to create a series of MySQL tables with numerical value name, which for some reason I can't. IE: CREATE TABLE 101 ( tagnumber varchar(8) not null default '' ) CREATE TABLE 201 ( tagnumber varchar(8) not null default '' ) CREATE TABLE 301 ( tagnumber varchar(8) not null default '' ) I've looked thru various documentation about table reservered names and couldn't find any info about numerical table names only.
Are numerical valued tables names not allowed then?? Mickalo, manual_Reference.html#Legal_names 7.1.5 Database, Table, Index, Column, and Alias Names A name may start with any character that is legal in a name. In particular, a name may start with a number (this differs from many other database systems!). However, a name cannot consist only of numbers. If they are university courses or similar, why not just put a letter in front. If you are trying to construct the table name under some program control, you can still achieve this... Regards, =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php