MySQL statement should pay attention to the problem

Just started to write MySQL statements more cumbersome, noisy, summed up a few points should be noted:

1 note punctuation, when creating a table create table, the parentheses contain the contents of the "," number split open, the last statement does not add punctuation;

2 in setting the primary key primary key, the contents of the inside with ' ' ' cause;

3 When setting foreign keys, pay attention to the MySQL engine mode, the default is Engine=myisam, this engine mode is unable to add foreign keys, need to change to Engine=innodb,

and two tables to add, pay attention to the table statement to the same wording

MySQL statement should pay attention to the problem