Mysql used words

C++, C#, Java, PHP, ect...
Post Reply
User avatar
hallsofvallhalla
Site Admin
Posts: 12026
Joined: Wed Apr 22, 2009 11:29 pm

Mysql used words

Post 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
Xaleph
Posts: 897
Joined: Mon Feb 07, 2011 2:55 am

Re: Mysql used words

Post 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 :)
User avatar
hallsofvallhalla
Site Admin
Posts: 12026
Joined: Wed Apr 22, 2009 11:29 pm

Re: Mysql used words

Post by hallsofvallhalla »

ah yes kill was one i tried and had issues with.
User avatar
Jackolantern
Posts: 10891
Joined: Wed Jul 01, 2009 11:00 pm

Re: Mysql used words

Post by Jackolantern »

Although "exp" isn't listed as a reserved word, I assume it is an alias for "explain"
The indelible lord of tl;dr
User avatar
Perry
Posts: 409
Joined: Tue Jun 23, 2009 4:26 pm

Re: Mysql used words

Post by Perry »

mod is another one. I found that one out from experience. :P
User avatar
hallsofvallhalla
Site Admin
Posts: 12026
Joined: Wed Apr 22, 2009 11:29 pm

Re: Mysql used words

Post by hallsofvallhalla »

hehe

exp is a weird one. It will work then not work.
Post Reply

Return to “Coding”