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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Want to Move records from One table to another

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Hi

I want to move records from one table to another. Is there a "move" keyword that I can use and if so, what is the correct syntax ?
 
Sort by date Sort by votes
INSERT INTO TargetTable
SELECT * FROM SourceTable
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
462
spamjim
spamjim
penguinspeaks
  • Locked
  • Question
Update column based on input from another column 3
Replies
6
Views
404
penguinspeaks
penguinspeaks
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
384
EdLentz
EdLentz
EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
362
Chris Miller
Chris Miller
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
431
lupidol
lupidol

Part and Inventory Search

Sponsor

Back
Top