probably a simple mysql copy multiple rows question
| From: | Dave Carrera | Date: | Sun, 27 Nov 2005 11:34:09 +0000 |
| Subject: | probably a simple mysql copy multiple rows question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-226506@lists.php.net to get a copy of this message | ||
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 33i hope that makes some kind of sence... Dave C