wpdb->query and running 2 sql statements with one go

[Haluk Karamete]

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 would
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 to
your MySQL server version for the right syntax to use near 'ALTER TABLE
`my_new_table` auto_increment = 1)' at line 1]

[J.D. Grimes]

wpdb uses mysqli_query() - https://core.trac.wordpress.org/browser/tags/3.9.1/src/wp-includes/wp-db.php#L1616

mysqli_multi_query() must be used to run multiple statements - http://php.net/manual/en/mysqli.quickstart.multiple-statement.php

-J.D.

Post by Haluk Karamete
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 would
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 to
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
http://lists.automattic.com/mailman/listinfo/wp-hackers

[Haluk Karamete]

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
injection concerns...

So, I took a different route;

instead of going

$sql=statement1;statement2",

I array'ed them.

sql[]='statement1';
sql[]='statement2';

the rest was smooth...

if (is_array($sql)):
#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.
return FALSE;
endif;
$wpdb->flush();
endforeach;
else:
#this is when $sql is a string
$query_result = $wpdb->query($sql);
endif;

Post by J.D. Grimes
wpdb uses mysqli_query() -
https://core.trac.wordpress.org/browser/tags/3.9.1/src/wp-includes/wp-db.php#L1616
mysqli_multi_query() must be used to run multiple statements -
http://php.net/manual/en/mysqli.quickstart.multiple-statement.php
-J.D.

Post by Haluk Karamete
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

would

Post by Haluk Karamete
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

to

Post by Haluk Karamete
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
http://lists.automattic.com/mailman/listinfo/wp-hackers

_______________________________________________
wp-hackers mailing list
http://lists.automattic.com/mailman/listinfo/wp-hackers