select into

[doddo]

Hi, I want to copy some columns from a table into another table as in:

select table.column1,table.column2 into table_new from table

Mysql doesn't seem to support 'select into's' other than for exporting. Does anybody have a work around?

cheers

 

[Broccoli2]

Try this:

CREATE TABLE table_new
SELECT table.column1, table.column2
FROM table;

Hope this helps
-Rob

 

[doddo]

thanks, but I meant for adding rows to a table from the result of a select as opposed to creating a new one.

I guess I could create a new one from the old one plus the additional rows but that would mean each time i performed the update I would have to change the name

i.e
create table_2 from update_table and table_1
create table_3 from update_table and table_2
create table_4 from update_table and table_3

cheers

 

[Broccoli2]

Ah, apologies. Maybe you need

INSERT INTO table_new(column1,column2)
SELECT column1, column2
FROM table;

Hope this is more appropriate for your purposes
-Rob

 

[doddo]

yes that would do it. I didn't expect it to work as it's kind of nested

cheers