Posted by Dave Carrera on 11/27/05 13:34

Hi All,

I have a table with a structure like this.

name
code
price

what i would like to do is copy the data in these rows to new ones in
the same table but change the

name col, keep the current data for code col and set price col to a
default value.

so if the output of my current table is

BASE 600 1.99
BASE 601 2.99

then i would like to copy these rows so that the table looks like this

BASE 600 1.99
BASE 601 2.99
NEW 600 33
NEW 601 33

i hope that makes some kind of sence...

Dave C

• Next in forum: PhpMailer vs Pear:Mail
• Prev in forum: Re: [PHP] SQL Password() function
• Thread view: probably a simple mysql copy multiple rows question

[Reply to this message]