Re: HELP: How to duplicate rows...

2007-12-07 Thread rfeio
I knew it had to be something REAL simple! :-) Thanks guys, that worked perfectly! Ananda Kumar wrote: > > u want something like this > > INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, 'abcd' > from table_name > WHERE field2=x > > > > On 12/7/07, rfeio <[EMAIL PROT

Re: HELP: How to duplicate rows...

2007-12-07 Thread 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:

Re: HELP: How to duplicate rows...

2007-12-07 Thread Ananda Kumar
u want something like this INSERT INTO table1 (field2, field3, field4) SELECT field2, field3, 'abcd' from table_name WHERE field2=x On 12/7/07, rfeio <[EMAIL PROTECTED]> wrote: > > > Hi! > > I have a table with several rows, some of which I need to duplicate. > > The fields of table1 are field1

HELP: How to duplicate rows...

2007-12-07 Thread rfeio
Hi! I have a table with several rows, some of which I need to duplicate. The fields of table1 are field1, field2, field3 and field4. Field1 is automatically incremented, field2 will serve as a filter condition. Normally to duplicate the rows that matched a certain condition I would do: INSERT