MySQL Forums
Forum List  »  Knowledge Base

Re: SYNTAX ERROR
Posted by: Arnold Daniels
Date: August 14, 2007 06:36PM

Yes,

SELECT INTO table doesn't exist. There's either INSERT INTO table SELECT or SELECT INTO file. I believe you want the first one.

insert into review(wrk_rev) select min(wrk_count) from tp_workflow where wrk_prepby = CreBy and wrk_projname =ProjName group by wrk_apr limit 1;

Arnold Daniels
developer.javeline.net

Options: ReplyQuote


Subject
Views
Written By
Posted
3521
July 31, 2007 11:38PM
Re: SYNTAX ERROR
2244
August 14, 2007 06:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.