What would
SELECT 42 FROM SOME_TABLE
return? column name 42 or the numerical value 42 ?
M
-----Original Message-----
From: Sparta Cruz [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 08:23
To: MySQL
Subject: Column Names
MySQL's 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.
MyQuestion:
Why can't a column name be just a number?
For example:
CREATE TABLE Odorants(
id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
odorant VARCHAR(30) NOT NULL,
row TINYINT UNSIGNED NOT NULL,
1 DOUBLE(4,20),
2 DOUBLE(4,20),
3 DOUBLE(4,20),
4 DOUBLE(4,20),
5 DOUBLE(4,20),
6 DOUBLE(4,20),
7 DOUBLE(4,20),
8 DOUBLE(4,20),
9 DOUBLE(4,20),
10 DOUBLE(4,20),
11 DOUBLE(4,20),
12 DOUBLE(4,20),
13 DOUBLE(4,20),
14 DOUBLE(4,20),
15 DOUBLE(4,20),
16 DOUBLE(4,20),
17 DOUBLE(4,20),
18 DOUBLE(4,20),
19 DOUBLE(4,20),
20 DOUBLE(4,20),
21 DOUBLE(4,20),
22 DOUBLE(4,20),
23 DOUBLE(4,20),
24 DOUBLE(4,20),
25 DOUBLE(4,20),
26 DOUBLE(4,20),
27 DOUBLE(4,20),
28 DOUBLE(4,20),
29 DOUBLE(4,20),
30 DOUBLE(4,20),
31 DOUBLE(4,20),
32 DOUBLE(4,20),
33 DOUBLE(4,20),
34 DOUBLE(4,20),
35 DOUBLE(4,20),
36 DOUBLE(4,20),
37 DOUBLE(4,20),
38 DOUBLE(4,20),
39 DOUBLE(4,20),
40 DOUBLE(4,20),
41 DOUBLE(4,20),
42 DOUBLE(4,20),
43 DOUBLE(4,20),
44 DOUBLE(4,20),
PRIMARY KEY (id),
UNIQUE UC_id (id));
ERROR 1064: You have an error in your SQL syntax near '1 DOUBLE(4,20),
2 DOUBLE(4,20),
3 DOUBLE(4,20),
4 DOUBLE(4,20),
5 DOUBLE(4,' at line 5
Other:
Any thoughts or suggestions are welcomed.
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
