Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

I'm mad :(

Jan 12, 2003, 1:47 PM
Paul
Veteran (19537 posts)
Jan 12, 2003, 1:47 PM
Post #1 of 8
Views: 9545
Shortcut
Quote Reply
I'm mad :(
I created a table in MySQL called "Log" - built a script around it but now my installer script always barfs with a syntax error when it tries to create that table. Hmm so I went to the MySQL reserved word list and "Log" isn't listed :(

When I change it to "Logs" the error goes.

That really sucks.

Last edited by:

Paul: Jan 12, 2003, 1:47 PM
Jan 12, 2003, 2:59 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Jan 12, 2003, 2:59 PM
Post #2 of 8
Views: 9106
Shortcut
Quote Reply
Re: [Paul] I'm mad :( In reply to
Could be column names in that table that is causing problems.
========================================
Buh Bye!

Cheers,
Me
Jan 12, 2003, 4:35 PM
Paul
Veteran (19537 posts)
Jan 12, 2003, 4:35 PM
Post #3 of 8
Views: 9116
Shortcut
Quote Reply
Re: [Stealth] I'm mad :( In reply to
As I said, when I rename the table from Log to Logs then it is created without a problem. All the columns are log_ prefixed so they won't be reserved, eg....

log_id
log_user_id_fk

Thanks though.
Jan 14, 2003, 10:00 AM
Alex
Administrator (9387 posts)
Jan 14, 2003, 10:00 AM
Post #4 of 8
Views: 9088
Shortcut
Quote Reply
Re: [Paul] I'm mad :( In reply to
What's the query and the error?

Quote:
mysql> create table Log (a int);
Query OK, 0 rows affected (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 3.23.54 |
+-----------+
1 row in set (0.00 sec)

mysql>

works here.

Cheers,

Alex
--
Gossamer Threads Inc.
Jan 14, 2003, 10:09 AM
Paul
Veteran (19537 posts)
Jan 14, 2003, 10:09 AM
Post #5 of 8
Views: 9109
Shortcut
Quote Reply
Re: [Alex] I'm mad :( In reply to
The query is:

Code:
CREATE TABLE Log(
log_camp_id_fk int(10) NOT NULL DEFAULT '0' ,
log_med_id_fk int(10) NOT NULL DEFAULT '0' ,
log_timestamp int(15) NOT NULL DEFAULT '0' ,
log_ip varchar(15) NOT NULL DEFAULT '' ,
log_type enum('1','2') NOT NULL DEFAULT '2'
)

...and the error is:

Reason: You have an error in your SQL syntax near 'Log( log_camp_id_fk int(10) NOT NULL DEFAULT '0' , log_med_id_fk int(10) NOT' at line 11064.

I just tried it again now incase it was a freaky error and it happened again. Using "Logs" worked fine :(

Quote:
Executed Query: CREATE TABLE Logs( log_camp_id_fk int(10) NOT NULL DEFAULT '0' , log_med_id_fk int(10) NOT NULL DEFAULT '0' , log_timestamp int(15) NOT NULL DEFAULT '0' , log_ip varchar(15) NOT NULL DEFAULT '' , log_type enum('1','2') NOT NULL DEFAULT '2' )

Last edited by:

Paul: Jan 14, 2003, 10:10 AM
Jan 14, 2003, 10:11 AM
Paul
Veteran (19537 posts)
Jan 14, 2003, 10:11 AM
Post #6 of 8
Views: 9038
Shortcut
Quote Reply
Re: [Alex] I'm mad :( In reply to
Ok thats weird. When I add a space between g and ( the query works. Why don't I have to do that with Logs?
Jan 14, 2003, 10:12 AM
Alex
Administrator (9387 posts)
Jan 14, 2003, 10:12 AM
Post #7 of 8
Views: 9066
Shortcut
Quote Reply
Re: [Paul] I'm mad :( In reply to
That's because you are meant to have a space after the table name. =)

http://www.mysql.com/...en/CREATE_TABLE.html

Quote:
mysql> CREATE TABLE Log (
-> log_camp_id_fk int(10) NOT NULL DEFAULT '0' ,
-> log_med_id_fk int(10) NOT NULL DEFAULT '0' ,
-> log_timestamp int(15) NOT NULL DEFAULT '0' ,
-> log_ip varchar(15) NOT NULL DEFAULT '' ,
-> log_type enum('1','2') NOT NULL DEFAULT '2'
-> );
Query OK, 0 rows affected (0.00 sec)

mysql>

Seems to trip up mysql otherwise. Strange.

Cheers,

Alex
--
Gossamer Threads Inc.
Jan 14, 2003, 10:17 AM
Paul
Veteran (19537 posts)
Jan 14, 2003, 10:17 AM
Post #8 of 8
Views: 9023
Shortcut
Quote Reply
Re: [Alex] I'm mad :( In reply to
Blech. They could at least have made Logs fail too, to give me some sort of hint ;) ...here's me thinking it the word "Log" ...bah.