Re: HELP: How to duplicate rows...

[mos]

At 09:39 AM 12/7/2007, rfeio wrote:
INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, field4
WHERE field2=x


Have you tried:

INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, "ABCD"
WHERE field2=x

Mike 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]