MySQL Forums
Forum List  »  Newbie

Syntax error...again
Posted by: allison ose
Date: January 19, 2013 04:20PM

l'm having a concern that my book might not match the version of mySQL l'm using, it says it works for 4.1 and up. l'm using 5.1 but l've asked around and nobody can help with this error.

INSERT INTO MARINA
VALUES
(`Alexamara East',`108 2nd Ave',`Brinman',`FL',`32273');
(`Alexamara Central',`283 Branston',`W Brimman',`FL',`32274');
INSERT INTO OWNER
VALUES
(`AD57',`Adney',`Bruce and Jean',`208 Citrus',`Bowton',`FL',`31313');
(`AN75',`Anderson',`Bill',`18 Wilcox',`Glander Bay',`FL',`31044');

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '108 2
nd Ave',`Brinman',`FL',`32273');
(`Alexamara Central',`283 Branston',`W Bri' at line 3

note: l tried this with the marina numbers for the Alexamara lines, too (1 and 2) but it doesn't seem to make a difference.

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Syntax error...again
January 19, 2013 04:20PM
January 19, 2013 05:17PM
January 19, 2013 07:21PM
January 19, 2013 07:25PM
January 20, 2013 11:23AM


Sorry, you can't reply to this topic. It has been closed.

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.