php sql

[Pouncer]

is there a way i can move a record from 1 table to another?

both tables have the same table structure wth the same fields..

do i have to do it the long way? i.e..

grab all items from table1

insert into table2 .....

or is there a quicker way?

[mendhak]

You can run a few simple SQL statements to do this.

INSERT INTO Table2(field1,field2,field3,field4)
SELECT T1.field1,T1.field2,T1.field3,T1.field4 FROM Table1 T1 WHERE T1.field1 = 29385

Then,

DELETE FROM Table1 WHERE T1.field1 = 29385

HTH

[Pouncer]

You can run a few simple SQL statements to do this.

INSERT INTO Table2(field1,field2,field3,field4)
SELECT T1.field1,T1.field2,T1.field3,T1.field4 FROM Table1 T1 WHERE T1.field1 = 29385

Then,

DELETE FROM Table1 WHERE T1.field1 = 29385

HTH

awesome reply, perfect.