Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
Passing many SQL queries to one mysql_query

Posted by pgroves (pgroves), 25 October 2002
Hi - I need to run a number of SQL queries via PHP from one PHP script and was wondering whether I have to open a seperate mysql_query($querystring, $dbid) call for each query or if I can seperate them out with ";" characters like you normally can in SQL and do everything in one mysql_query function e.g.

$querystring = "INSERT INTO table 1 VALUES("value1", "value2"); INSERT INTO table 3 (VALUES ("value1", "value2"),("value3", "value4");";

One first experiments, it doesn't seem to work, but maybe I'm doing this wrong



Posted by admin (Graham Ellis), 26 October 2002
I think you have to generate separate queries. The ";" character that you may be familiar with  using as a command line (or script) input to the mysql client program is a statement terminator that the mysql program uses. Mysql strips it off and it never gets passed on to mysqld.

This page is a thread posted to the opentalk forum at and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: • WEB: • SKYPE: wellho