List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:January 7 2000 4:49pm
Subject:Re: Please HElp with Query.
View as plain text  
At 10:38 AM -0600 2000-01-07, William X. Kerber wrote:
>//I try this query.
>
>INSERT INTO EE_EARN ratecode, amount, clientcode, eecode, schedfreq, 
>ortaxfreq,
>taxfreq, hoursonly, inout, overtime, accrual, earncode, earndesc, baseearn,
>g2ncode, g2nsub, ertaxcalc, ertcdesc, taxfica, taxfwt, taxsit, taxlocal,
>taxfuta, taxsui, taxfed28 SELECT ratecode, 33 AS amount, '00139' AS 
>clientcode,
>'74' AS eecode,
>schedfreq, ortaxfreq, taxfreq, hoursonly, inout, overtime, accrual, earncode,
>earndesc, baseearn, g2ncode, g2nsub, ertaxcalc, ertcdesc, taxfica, taxfwt,
>taxsit, taxlocal,
>taxfuta, taxsui, taxfed28 FROM CL_EARN WHERE (clientcode='00139') AND
>(earncode='BON')
>
>//I get this ERROR:
>MySQL said: parse error near 'ratecode, amount, clientcode, eecode, schedfreq,
>ortaxfreq, taxfreq, hoursonly, ' at line 1
>
>can someone tell me where the mistake is?
>ARE YOU NOT allowed to use Insert(field1, field2....) position list with an
>Insert - Select Opertation.


Sure, but you don't *have* any parens around your field list.

-- 
Paul DuBois, paul@stripped
Thread
Re: COM/ADO component for MYSQLAlok Singh7 Jan