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
Mysql used words
Re: Mysql used words
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
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

- hallsofvallhalla
- Site Admin
- Posts: 12026
- Joined: Wed Apr 22, 2009 11:29 pm
Re: Mysql used words
ah yes kill was one i tried and had issues with.
- Jackolantern
- Posts: 10891
- Joined: Wed Jul 01, 2009 11:00 pm
Re: Mysql used words
Although "exp" isn't listed as a reserved word, I assume it is an alias for "explain"
The indelible lord of tl;dr
Re: Mysql used words
mod is another one. I found that one out from experience. 

- hallsofvallhalla
- Site Admin
- Posts: 12026
- Joined: Wed Apr 22, 2009 11:29 pm
Re: Mysql used words
hehe
exp is a weird one. It will work then not work.
exp is a weird one. It will work then not work.