[DUG] MySql - copy table contents

[Robo]

INSERT INTO table (clientId, field1, field2, field3)
SELECT 2, field1, field2, field3
FROM table
WHERE clientId = 1;


On Tue, Jul 29, 2014 at 8:05 AM, John C <jc at sunshinesoftware.co.nz> wrote:

> Hi all
>
>
>
> I have a table with a CLIENT index field. How can I copy (within the same
> table) the contents from one client to another client?
>
>
>
> Table structure: Client_ID, Field1, Field2, Field3
>
> Before             1, 222, 333, 444
>
>                         1, 555, 666, 777
>
>
>
> After                1, 222, 333, 444
>
>                         1, 555, 666, 777
>
>                         *2*, 222, 333, 444
>
>                         *2*, 555, 666, 777
>
>
>
> Thanks a lot
>
> John C
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at listserver.123.net.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at listserver.123.net.nz with
> Subject: unsubscribe
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20140729/dfbad149/attachment.html