Posted by J.O. Aho on 03/10/07 10:18

Alex wrote:

>> Dual is a reserved word and should really not be used for
>> database/table/column/function/procedure names, I strongly recommend you
>> rename it, you can also use the "single quotes" ``.
>> Notice the difference from the usual single quote ' and the one used for
>> database/table/column names which is tittle a bit `.
> Problem solved :D
> The issue was the 'Dual'. I renamed it and now it works just fine.
> Thanks a lot for your help all of you!
>
Here is a list of reserved words in MySQL, it will apply quite well into other
sql databases too: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

--

//Aho

[Back to original message]