Re: select first then insert (same table)

Louie Miranda wrote: How do i select and insert a data from 1 table to another with same table fields. INSERT .. SELECT -- it's in the manual at: http://dev.mysql.com/doc/mysql/en/insert-select.html It's always good to read the manual before asking questions on the list, as a large number of

select first then insert (same table)

Guys, How do i select and insert a data from 1 table to another with same table fields. mysql> select * from cardv2_data where refcode = '10-44'; Is it like this?? mysql> select * from cardv2_data where refcode = '10-44'; insert into * copy this to this table. Please help! -- Louie Miranda ht