I am tying to dupilicate a set of records changing only one field. That
field is part of a UNIQUE key. So far I copy the records into themselves
and keep the same number of records:
insert ignore into user_projects select * from user_projects where
user_id="[EMAIL PROTECTED]" and fac_id="FAC-0002" ON DUPLICATE KEY UPDATE
FAC_ID="FAC-0003"
Now in my untrained mind, this should create 4 new, identical records with
only the fac_id field changed.
Where am I going wrong?
Thanks.
Chris Jones
14 Oneida Avenue
Toronto, ON M5J 2E3.
Tel. 416-203-7465
Fax. 416-946-1005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]