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
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:
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
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