mysql insert - select syntax error

Question

This is my query -

$q = "CREATE TEMPORARY TABLE tmp SELECT * from category c  WHERE category_id IN (SELECT category_id FROM category_to_store WHERE store_id = '".(int)$from_store_id."');
                ALTER TABLE tmp drop category_id; 
                INSERT INTO category SELECT 0,tmp.* FROM tmp;
                SET @last_id_in_category := LAST_INSERT_ID();
                select @last_id_in_category;
                DROP TABLE tmp;"

mysql_query($q);

I am getting this error on execution

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 tmp drop category_id; INSERT INTO category SELECT 0' at line 2 Error No: 1064

But when I run the query in database directly then I am not getting any error. Please help me !

Sirko · Accepted Answer · 2012-04-25 13:08:30Z

3

From the php docu on `mysql_query'

mysql_query() sends a unique query (multiple queries are not supported) to the currently active database ...

So basically split your queries to multiple calls of `mysql_query' each with a single query and you should be fine.

answered Apr 25, 2012 at 13:08

Sirko

74.3k19 gold badges157 silver badges194 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql insert - select syntax error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related