[DUG] MySql - copy table contents

[David Moorhouse]

With some SQl

combine a select with an insert

HTH

D

On 29/07/14 18:05, John C 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
>