Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

table names

Status
Not open for further replies.

simanek

Programmer
Jan 19, 2001
137
US
Ok when I'm trying to create tables with the names of these tables as integers. From what I've read, the table name can be any combination of alphanumeric characters so why, when I type:
CREATE TABLE 1 (column1 varchar(20), column2 varchar(20), column3, varchar(20));
do I get an error? If I replace the '1' with 'one' it works fine. Any ideas? Thanks.
Mike
~~~~
simanek@uiuc.edu
"It's a Swingline!"
~~~~
 
the book i was reading lied to me...
from the mysql.com documentation:

"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. " dang.
Mike
~~~~
simanek@uiuc.edu
"It's a Swingline!"
~~~~
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top