Two Consecutive Insert Statements
The simple confounds the wise. Is there a seperator needed between multiple insert statements? I tried semicolon, the word "go". See example and error below.
Thanks,
Neal Walters
insert authors
values('238-95-7766', 'Carson', 'Cheryl', '415 548-7723',
'589 Darwin Ln.', 'Berkeley', 'CA', '94705', 1)
insert authors
values('998-72-3567', 'Ringer', 'Albert', '801 826-0752',
'67 Seventh Av.', 'Salt Lake City', 'UT', '84152', 1)
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 'insert authors
values('998-72-3567', 'Ringer', 'Albert', '801 826-0752',
' at line 5