Crate duplicates?

[calle08]

I want to crate duplicates of the following but cnage the date to 2011-09-10 how can i do that?

 

SELECT firstname, lastname, date, info FROM all WHERE date '2011-08-30'

[The Little Guy]

You want to do a insert into ... select from.

 

It would look something like this:

insert into all (firstname, lastname, '2011-09-10', info) SELECT firstname, lastname, date, info FROM all WHERE date = '2011-08-30'

[The Little Guy]

insert into all (firstname, lastname, '2011-09-10', info) SELECT firstname, lastname, date, info FROM all WHERE date = '2011-08-30'

 

Just realized the above has a tiny error

 

insert into all (firstname, lastname, date, info) SELECT firstname, lastname, '2011-09-10', info FROM all WHERE date = '2011-08-30'