MySQL Command Center Query Failing 1

[jkpalmer52]

Running MySQL for Windows on a machine with Windows 2000 Professional

mysql Ver 11.18 Distrib 3.23.58, for Win95/Win98 (i32)

Trying to execute the following query in MySQL Command Center 0.9.4-beta.

insert into Fee (Description, MunicipalAssmt, SupervisionAssmt, CircuitJudgeAssmt, MustApprAssmt, AuditTime) values
Select CodeValue, 'N', 'N', 'N', 'N', now()
from CodeTable
where CodeType='FEE DESCRIPTION';

I receive the following error message:

[FineCost-cpjkpdell] ERROR 1064: You have an error in your SQL syntax near 'Select CodeValue, 'N', 'N', 'N', 'N', now() from CodeTable where CodeType='FEE D' at line 1

I've made sure that the select works by itself, and it does.

Something when the query gets parsed by MySQLCC??

Any ideas????

I'm lost.

 

[vanekl]

Your INSERT looks good except for the word 'values.'
Delete it and the query should work.

 

[theScien]

I think it's the Now() function, at least I can't insert Now's because MySQL datetime datatype is of format yyyy-mm-dd hh-mm-ss and my server is dd-mm-yyyy... so it errors out, it could be the same in your case.

------------------------------

http://www.mylittlehost.com

------------------------------