Using SQL to Copy Table Content
How to copy the contents of one table to another using SQL is not immediately obvious.
Create and Populate Table
create table mytablecopy select * from originaltable
Copying a Table into an Existing Table
insert into originaltable select * from mytablecopy
Sub-Selects
MySQL does support sub-selects. For example you can do this:
select * from things where thing.userid not in (select userid from otherthings)
| Discuss on Forum | More Tutorials » |