Error nesting select statement into insert statement MYSQL

Asked Mar 02 '16 at 22:11

Active Mar 02 '16 at 22:11

Viewed 14 times

Hey Everyone,

insert into IP values (select * from Proxies where Accs_On_IP = 0);

What is wrong with this? The columns from IP and Proxies are the same (just migrating some out of one table into another). Any help or resources would be great! Thanks!

asked Mar 02 '16 at 22:11

k9b

1,457
4
24
54

1

Isn't the syntax `insert into table select` without `values` -- or does mysql allow that? – sgeddes Mar 02 '16 at 22:15
Also see here: http://stackoverflow.com/a/5253322/1073631 – sgeddes Mar 02 '16 at 22:16
First comment worked :) Answer so I can accept it thanks so much – k9b Mar 02 '16 at 22:17

Error nesting select statement into insert statement MYSQL

0 Answers0