Multiple Query Statement
Posted: Tue Aug 15, 2006 10:30 am
Hey,
Is there a way to string together multiple queries into one statement?
Ex:
-------------
INSERT INTO news (article, date) VALUES ('blah blah', CURDATE());
INSERT INTO news (article, date) VALUES ('blah blah blah', CURDATE());
-------------
In Query Browser you have to execute each line separately. When I try to execute something like this using mysql_query I get an error. I would have thought that since the line is ended with a ";" I'd be able to.
Is there a way to string together multiple queries into one statement?
Ex:
-------------
INSERT INTO news (article, date) VALUES ('blah blah', CURDATE());
INSERT INTO news (article, date) VALUES ('blah blah blah', CURDATE());
-------------
In Query Browser you have to execute each line separately. When I try to execute something like this using mysql_query I get an error. I would have thought that since the line is ended with a ";" I'd be able to.