Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jude99
  • Content: Threads
  • Order by date
  1. jude99

    Move data within same table

    Is there a way to move data from field1, field2, field3, field4, id IN(200, 201, 202, 203, 204) in table1 to field1, field2, field3, field4, id IN(800, 801, 802, 803, 804) in table1 Ideally the data would be moved rather than duplicated. Is this possible, please, Experts?
  2. jude99

    Inserting into same table

    How can I insert data into the same table, please, as in duplicate 1d = '2'?
  3. jude99

    Inserting into different table, specific rows

    I need to insert into a different table, but to specify the IDs of the receiving table. Is this possible, please? Something like ... insert into table2 (row1, row2,row3)where id IN( 100,1001,1002) select row1, row2, row3 from table1 where special_number = '9';

Part and Inventory Search

Back
Top