On Sun, 28 Oct 2001 22:59:46 -0000, "DL Neil" <[EMAIL PROTECTED]> wrote:
>>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... That was the main idea, to name the tables to coincide with a shopping cart product id values for universal table selection. but we've come up with another idea... :) thanks for pointing out what I obviously missed in the manual! Time for new glasses. ;) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= --------------------------------------------------------------------- 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