The reserved words are listed in the manual
<http://dev.mysql.com/doc/mysql/en/Reserved_words.html>. 'Purge' is on the
list.
Michael
ian douglas wrote:
Put Purge into backticks.
........
`Purge` char(1),
It worked great but I would like to know why, thank!
It could be that 'purge' is a reserved word in MySQL. I wanted to have a
table with a shortened name of 'description' by trying to create a table
with a 'desc' field, and MySQL had problems with it too, because 'desc'
is a reserved word to 'describe' a table definition. But, creating the
table as
`desc` varchar(20)
worked just fine...
-id
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
