Forum Moderators: open

Message Too Old, No Replies

mySQL 5 - look outs

keywords, quirks, etc.

         

txbakers

6:14 pm on Nov 4, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



just found out that you can't have a column name called "condition" in mySQL5. It was allowed in 4.

As people play with 5, let's try to keep a central location for quirks, and changes we come across.

bcolflesh

6:38 pm on Nov 4, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



MySQL 5 Reserved Word List:

[dev.mysql.com...]

txbakers

6:49 pm on Nov 4, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



that's funny because it let me create a column called "name" without a problem.

coopster

11:11 pm on Nov 6, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



A reserved word can be used as an identifier if you quote it.