Re: Insert syntaxis not working

[David Shrewsbury]

You are inventing syntax. Valid syntax is:

INSERT INTO x VALUES (y);

Or

INSERT INTO x SELECT y FROM z;

But definitely NOT:

INSERT INTO x VALUES (y) SELECT * FROM z;

Read the Reference Manual (see http://dev.mysql.com/doc/refman/5.0/en/insert.html) for the complete syntax description.

-Dave