MySQL Forums
Forum List  »  Newbie

Re: another 1064 error
Posted by: Peter Brawley
Date: October 05, 2018 10:15AM

In a script, MySQL wants a semicolon at the end of the USE cmd.

There are several other syntax errors in this script---commas after the last column def in three Create Table commands.

And there is a fatal design flaw: no table has a primary key. Except perhaps for temp utility tables, every table needs a primary key. Stop what you're doing till you've worked through a relational database tutorial.

And upper case identifier names are generally bad for portability. Consider using lower case.



Edited 1 time(s). Last edit at 10/05/2018 10:15AM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
October 05, 2018 10:01AM
Re: another 1064 error
October 05, 2018 10:15AM
October 05, 2018 10:36AM
October 05, 2018 11:01AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.