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 <[email protected]> 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: [email protected] > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to [email protected] with > Subject: unsubscribe >
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
