whats wrong with this query?

INSERT INTO print_development.categories (id, name)
VALUES (select id, name  from print_pro.categories where parent_id is NULL);

You have an error in your SQL syntax; check the manual that corre开发者_如何学编程sponds to your MySQL server version for the right syntax to use near 'select id, name  from print_pro.categories where parent_id is NULL)' at line 2

You have the wrong INSERT/SELECT syntax. You don't use "VALUES", just use the SELECT.

INSERT INTO print_development.categories (id, name)
select id, name  from print_pro.categories where parent_id is NULL

http://dev.mysql.com/doc/refman/5.5/en/insert.html