Insert

[jamal_dakak]

Hi,

Can someone help me with this query:

INSERT INTO Frequency(
Search,
DateAdded
)
VALUES
SELECT Search, DateAdded
FROM Searches

I get this error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT Search, DateAdded
FROM Searches' at line 4

Thanks

[obrienkev]

Leave out VALUES.

[jamal_dakak]

Thank you very much it is working

[obrienkev]

Glad to be of help.

Could you please mark as RESOLVED (under THREAD TOOLS menu link).
Makes it easier for people searching a similar problem.

Cheers.

Kevin.