MySQL Forums
Forum List  »  Newbie

Re: another 1064 error
Posted by: Peter Brawley
Date: October 05, 2018 11:01AM

> what do i need to do get no errors?

Stop what you're doing until you've learnt the basics of relational databases.

Database work is detail, detail then more detail. Check the script for syntax errors. Best way to do that, esp. as a beginner, is to copy & paste each command in turn into MySQL, note the error(s), correct them, run the corrected cmds, update the script, repeat till there are no more errors.

Check the script for design errors, eg no primary keys, and fix those.

And change table & column names to lower case.

Options: ReplyQuote

Written By
October 05, 2018 10:01AM
October 05, 2018 10:15AM
October 05, 2018 10:36AM
Re: another 1064 error
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.