Re: select first then insert (same table)

[Jasper Bryant-Greene]

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 your questions will be answered there.

-- 
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/