Moving a row to another table

[Fredrick Ughimi]

Using MySQL. Is it possible to move records from table to another.

Any hint would greatly be appreciated.

[swampBoogie]

insert into t1 select <columns> from t2 where <condition>
delete from t2 where <condition>

[Fredrick Ughimi]

Hello swampBoogie,

Thanks.