Quote:
Originally Posted by jugule
Hi, how can I move a column from this table: Example1 and then move it to Example2? (in plugin)
and then delete the column from the old table if it has been moved to the new table.
|
SELECT Column1 FROM table1;
In your results handler:
INSERT INTO table2 (Column2) VALUES (col1_value);
Then delete
ALTER TABLE table1
DROP COLUMN Column1;
__________________