Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

Just bump into the issue that I can't execute multiple sql queries using the $wpdb->query(). Generated queries work fine directly in phpmyadmin so its something will the ezSQL class only. By design perhaps?

I found this http://wordpress.org/support/topic/wpdb-gtquery-fails-when-multiple-update-statements-are-used which also says its by design. Can anyone confirm? ezSQL docs dont say anything about multiple queries support.

If you have to do a bunch of queries mainly (INSERT/UPDATE/DELETE), any better way of doing them other than doing them one by one using $wpdb->insert() and like functions?

share|improve this question
    
Interesting question, can you edit it and include a code example? This will teach more users about multiple statements in one query. Does it help to use transactions here? –  Jan Fabry Apr 26 '11 at 7:04
    
What's the issue with doing them one by one? –  AlxVallejo Mar 6 '12 at 15:46
add comment

1 Answer

up vote 0 down vote accepted

Using PHP 5.3.5, I was unable to make this syntax work even after setting the 5th parameter of mysql_connect() to 65536 (CLIENT_MULTI_STATEMENTS). Looks like it's not possible to concatenate multiple queries into one statement as long as the old-school MySQL API is running the show.

I assume you're familiar with the MySQL multiple row INSERT syntax, but I mention it just in case.

share|improve this answer
    
Thanks for checking, looks like its mysql's fault then and not of ezSQL. Yes, I am using multiple row syntax for inserts now. I will just wait for sometime in case someone stops by and add something here before accepting your answer. –  Ashfame Apr 25 '11 at 21:43
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.