MySQL Reserved Wordshttp://dev.mysql.com/doc/mysql/en/reserved-words.html
You should familiarize yourself with these because you will have unexpected results if you use any of them.
Eg. try creating a table with what you think is valid syntax like this:
CREATE Table Order(
.......);
The word 'Order' is a reserved word and used to ORDER the results so you will get a syntax error from this one and you would think everything is........