Inserting records from a SELECT statement (MySQL)

September 9, 2008

I often forget even simple syntax that makes MySQL operation easy. I’m just adding this basically for personal reference.
Using INSERT statement combined with the SELECT statement you could actually add records from one table to another table. Adding a WHERE clause could enable you to filter the records to copy. Below is the syntax.

INSERT INTO [...]

Filed under: MySQL | Comments (4)
Related Links:

NOT id IN (1, 2, 3) vs NOT (id IN (1, 2, 3))

September 5, 2008

Problem:
You’re probably wondering why the following query doesn’t  work on some mySQL databases
SELECT * FROM table1 WHERE NOT id IN (1, 2, 3)
works on mySQL v5.0.51a
doesn’t work on mySQL v4.1.21
Solution:

Filed under: MySQL | Comments (2)
Related Links: