Hello,
> He didn't name a column 'column', he named a table 'column'. This may
> have seemed reasonable given his application.
> In any case, bad idea or not, his point is well-taken. It worked in one
> place but not another. While column is a reserved word, the directions at
> http://www.mys
He didn't name a column 'column', he named a table 'column'. This may
have seemed reasonable given his application.
In any case, bad idea or not, his point is well-taken. It worked in one
place but not another. While column is a reserved word, the directions at
http://www.mysql.com/doc/L/e/Le
On Sun, Mar 17, 2002 at 05:31:52AM +0100, Tozz wrote:
> Hey
>
> > Column is a mysql reserved word.
> > Just like desc or asc or tons of others.
> > See here:
> > http://www.mysql.com/doc/R/e/Reserved_words.html
> > Dan
>
> Then, imho I think its stupid that MySQL lets you create tables with
> re
Hey
> Column is a mysql reserved word.
> Just like desc or asc or tons of others.
> See here:
> http://www.mysql.com/doc/R/e/Reserved_words.html
> Dan
Then, imho I think its stupid that MySQL lets you create tables with
reserved words, but it stops you from making dumps. Still seems like a bug
t
Column is a mysql reserved word.
Just like desc or asc or tons of others.
See here:
http://www.mysql.com/doc/R/e/Reserved_words.html
Dan
-Original Message-
From: Tozz [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 16, 2002 8:58 PM
To: [EMAIL PROTECTED]
Subject: MySQL tables named
Hello,
While reading my cron messages I found out that the mysqldump returns with
an error
mysqldump: Can't get CREATE TABLE for table 'column' (You have an error in
your SQL syntax near 'column' at line 1)
The table column is:
CREATE TABLE `column` (
`id` int(11) NOT NULL default '0',
`nam