Daniel Kasak wrote:
Russell E Glaue wrote:
<snipped>
ERROR 1064 at line 14071: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'order int(1) NOT NULL default '0',
PRIMARY KEY (moduleID),
<snipped>
Would this possibly be a bug with mysqldump ?
-RG
'order' is a reserved word.
I would rename that field, pronto!
In my opinion the bug is not in mysqldump, but in mysql allowing you to
use a fieldname that is a reserved word.
And yes I know about the backticks that mysqlcc uses, but surely this
causes more problems than it solves. See above example.
So if a word is reserved, a table with that same spelling cannot exist?
If this is so, then why did mysql allow it to be created?
-RG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
