Page 1 of 1
Mysql used words
Posted: Wed Jun 15, 2011 5:38 pm
by hallsofvallhalla
I find some weird ones that will throw errors every now and then so I want to start a topic on field names you cannot use for MYSQL that come up in our type of games. I have seen a ton but have forgotten them so I will post them as I remember them.
character
exp
Re: Mysql used words
Posted: Thu Jun 16, 2011 1:18 pm
by Xaleph
Key, Authentication, add, all, char, column, delayed, div, force, keys, kill, natural, union
and theres many, MANY more words you cannot use. However, these are some words I reckon people want to use. Anyway, they`re not allowed
Re: Mysql used words
Posted: Thu Jun 16, 2011 1:59 pm
by hallsofvallhalla
ah yes kill was one i tried and had issues with.
Re: Mysql used words
Posted: Thu Jun 16, 2011 4:33 pm
by Jackolantern
Although "exp" isn't listed as a reserved word, I assume it is an alias for "explain"
Re: Mysql used words
Posted: Fri Jun 17, 2011 3:45 pm
by Perry
mod is another one. I found that one out from experience.
Re: Mysql used words
Posted: Fri Jun 17, 2011 5:13 pm
by hallsofvallhalla
hehe
exp is a weird one. It will work then not work.