Jump to content
Larry Ullman's Book Forums

Recommended Posts

Hi,

 

I am now going through the SQL part of the above mentioned book, I tried to create the table "users" using the mySQL client command window and I kept getting an error message 1064, endless searches through google kept telling me there was something wrong with the syntax, yet I entered it exactly as in the book (several times). What was exactly wrong with the syntax I couldn't tell except that it has something to do with the first line user_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,

 

I then tried using PHPmyAdmin which also wouldn't work, with a lot of experimentation i changed user_id to userid, then everything worked perfectly, can anyone tell me why this is, is user_id a built in key phrase I shouldn't use, is my version wrong (too old (5.6.17)).

 

Anyway an explanation would help.

 

Ian

Link to comment
Share on other sites

  • 2 weeks later...
 Share

×
×
  • Create New...