axiom28 Posted December 21, 2016 Share Posted December 21, 2016 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 More sharing options...
Larry Posted December 31, 2016 Share Posted December 31, 2016 Could you provide the full error message you're seeing? And the command you're executing that results in that error? user_id is a perfectly valid column name to use. Link to comment Share on other sites More sharing options...
axiom28 Posted January 5, 2017 Author Share Posted January 5, 2017 Hi Larry, Thanks for your reply the error somehow seems to have resolved itself so I moved on through your book, Link to comment Share on other sites More sharing options...
Recommended Posts