[DUG] MySql - copy table contents

[John C]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20140729/dd56e277/attachment.html