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 'column' cause problems. 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', `name` text NOT NULL, `user` text NOT NULL, `text` longtext NOT NULL ) TYPE=MyISAM; Anyway, I was unable to a 'DROP column;'. This returns in an error value. Then I change the above snipped into: CREATE TABLE `kolom` ( `id` int(11) NOT NULL default '0', `name` text NOT NULL, `user` text NOT NULL, `text` longtext NOT NULL ) TYPE=MyISAM; (kolom is dutch for column), there is no problem and my backup exists without errors. So, in short it comes down too: MySQL buggs when there is a table named 'column' ???? Please mail any replies to [EMAIL PROTECTED] as I am not a member of this list. Bye, Tozz --------------------------------------------------------------------- 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
