Is type keyword in MySQL?

Is Key a keyword in MySQL?

Key is synonymous to an index. If you want to create an index for a column, then use 'Key'.

Is status a keyword in MySQL?

You're correct that STATUS is a keyword, likely owing to SHOW STATUS . If renaming the column isn't much of a chore for you, changing the name is the best choice.

Is state a keyword in SQL?

"State" is a keyword – SQLServerCentral Forums.

Is name a reserved keyword in MySQL?

You should be fine calling a column 'name'. Check out http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html for more details on how to deal with reserved words. Wrapping column names in the (`) character ensures that even reserved words won't be misinterpreted. Show activity on this post.