Hi, I installed an app which used
option as a field. It worked fine in version 3.23 on my play box. I then moved the app to another box (4.0.15) and when I tried to dump it in (mysql -u x -px database <dump_from_other_box) it balked at the use of option. I suspected reserved word and such was confirmed on the mysql site. So I moved the database directory from play box to live box. That worked. All was well. But I worry. Then, I went to the mysql site and read some more and saw a reason for those annoying backticks in phpmyadmin. I see that I could have done the original dump had I put option in backticks. So now I'm a bit confused why I should avoid reserved words (other than to avoid backticks which is enough for me but I'm curious). Will awful things happen to me in the future? Peter -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]