Syntax error...again
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.