[wp-hackers] wpdb->query and running 2 sql statements with one go
halukkaramete at gmail.com
Tue Jul 15 18:43:23 UTC 2014
thank you J.D,
I figured that what I wanted to do was not possible __within the wpdb__
environment, (which is the environment I'd like to stay in whenever I touch
the wordpress database)
I figured so because my guess is that Wordpress doesn't/and/would not
opt-in for the multiquery support you've mentioned about due to SQL
So, I took a different route;
instead of going
I array'ed them.
the rest was smooth...
#this is an exception
foreach ($sql as $cur_sql):
$query_result = $wpdb->query($cur_sql); # $results could be
FALSE if in errors!
if ( FALSE === $query_result ):
#early exit time, one of the baby sql's failed us.
#this is when $sql is a string
$query_result = $wpdb->query($sql);
On Tue, Jul 15, 2014 at 11:31 AM, J.D. Grimes <jdg at codesymphony.co> wrote:
> wpdb uses mysqli_query() -
> mysqli_multi_query() must be used to run multiple statements -
> On Jul 15, 2014, at 2:14 PM, Haluk Karamete <halukkaramete at gmail.com>
> > I'd like to be able to run this SQL using one wpdb->query call.
> > $sql = 'TRUNCATE TABLE `my_new_table` ;ALTER TABLE `my_new_table`
> > auto_increment = 1';
> > $query_result = $wpdb->query($sql);
> > As of 3.9.1, we do have the mysqli support. So, I'm not sure why this
> > not fly.
> > Is that one of my brain-freeze moments again?
> > but I'm getting the *familiar error: *
> > You have an error in your SQL syntax; check the manual that corresponds
> > your MySQL server version for the right syntax to use near 'ALTER TABLE
> > `my_new_table` auto_increment = 1)' at line 1]
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers