Mysql DB move 1 column (w/ data) from one table to another seamlessly?

Mysql DB move 1 column (w/ data) from one table to another seamlessly?

El Forum
Guest

09-18-2008, 08:02 AM

[eluser]drewbee[/eluser]
Not sure if you have what you need, but just so you konw you can do a subquery from an insert as well. IE

INSERT INTO new_table (col1, col2, col3) VALUES (SELECT col1, col2, col3 FROM old_table)

PS. Corn jobs are the best! Big Grin

Messages In This Thread

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-17-2008, 03:00 PM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-17-2008, 03:41 PM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-17-2008, 06:04 PM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-17-2008, 07:50 PM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-17-2008, 11:33 PM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-17-2008, 11:54 PM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-18-2008, 12:19 AM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-18-2008, 04:16 AM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-18-2008, 08:02 AM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 09-18-2008, 10:58 AM

Mysql DB move 1 column (w/ data) from one table to another seamlessly? - by El Forum - 07-17-2012, 08:21 AM