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]

Reply via email to