MySQL Reserved Words

http://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 correct syntax until you realize it is a reserved word.