Hi.. I'm getting error in my query.. while using it in oracle it is working.. But when using it in mysql it is not working.. i'm getting error as

insert into ProjectHealthReportAudit(clientid, projectid, month, year, phasesId,ACTIVITIESSUBTYPEID, ACTIVITIESARTIFACTSID,processConformance,comments, pcinumber, pciscore, colour, createddate,createdby) values ( (select clientid from client where clientName = ?), (select projectid from project where projectName = ?) ,  ? , ?,(select distinct  phasesid from auditcolumns where phases = ?),(select distinct  activitiesSubTypeId from auditcolumns where activitiesSubType = ?), (select distinct  activitiesArtifactsId from auditcolumns where activitiesArtifacts =?),?,?, (select distinct pcinumber from pcinumberTable where processconformance = ?),?,?,sysdate(), (select  distinct userid from users where fullname = ?))

nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'pcinumber' in 'field list'] with root cause com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'pcinumber' in 'field list'

Edited by pritaeas: Added markdown.

3 Years
Discussion Span
Last Post by usha_bandela

Sorry....... Thank you..... Found the answer.. column name is wrong in the table..

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.