Click here to Skip to main content
15,894,646 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i am inserting record in my sql database shows error as follows

INSERT INTO clinicalsample(RRH_LOCATION_CD,RRH_MR_NUM,RRH_FIRST_NAME,RRH_PAT_SEX,RRH_REGN_DT,RRH_PAT_DOB,AGE,MCS_CASE_SUMMARY,MCS_CRT_DT
MCS_CRT_UID,CPA_ADDR_1,CPA_ADDR_2,CPA_ADDR_3,CPA_ADDR_AREA,
CPA_ADDR_CITY,CPA_STATE_CD,CPA_COUNTRY_CD,CPA_PIN_CODE)
VALUES(NAVA,1002151,VIJAYALAKAHSMI K V,Fema,2003-12-23 14:33,1940-08-23 00:00,75,
Medical Record No. : 1057673Patient Name : MRS. SHYAMALA V Age : 71 Year(s)Sex : FemaleAddress : 2 SUBRAMANIAM COLONY 1ST STREET, N G ROAD
THIRUVANMIYUR, CHENNAI,TAMIL NADU, INDIA - 600 041Report Date : 2015-04-02 Optometrist : Start Time : Consultant :
Dr.PRASHANT OBEROI FollowUpFOLLOW-UP Instructions Action PlanOS- s/p PE+IOL. Pt. comfortable. O/E- OS- lids- min.
edema cornea- DF+ min edema, PCIOL in place. ADV- topicals started. Tab. Diamox 250mg bd*5days, iotim e/d bd *1week post op care explained.
RTC on tuesday at NSN. Nutritional ScreeningNo special dietary requirements advicedExamined by Consultant: Dr.PRASHANT OBEROI Time:
02-04-2015 08:55:42,
2015/04/01 12:07,1103830,B 2 BASERA,46 BESANT AVENUE ROAD,ADYAR,NULL,CHENNAI,TN,INDIA,600 020);

error as follows

Error Code: 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

What I have tried:

i am inserting record in my sql database shows error as follows

INSERT INTO clinicalsample(RRH_LOCATION_CD,RRH_MR_NUM,RRH_FIRST_NAME,RRH_PAT_SEX,RRH_REGN_DT,RRH_PAT_DOB,AGE,MCS_CASE_SUMMARY,MCS_CRT_DT
MCS_CRT_UID,CPA_ADDR_1,CPA_ADDR_2,CPA_ADDR_3,CPA_ADDR_AREA,
CPA_ADDR_CITY,CPA_STATE_CD,CPA_COUNTRY_CD,CPA_PIN_CODE)
VALUES(NAVA,1002151,VIJAYALAKAHSMI K V,Fema,2003-12-23 14:33,1940-08-23 00:00,75,
Medical Record No. : 1057673Patient Name : MRS. SHYAMALA V Age : 71 Year(s)Sex : FemaleAddress : 2 SUBRAMANIAM COLONY 1ST STREET, N G ROAD
THIRUVANMIYUR, CHENNAI,TAMIL NADU, INDIA - 600 041Report Date : 2015-04-02 Optometrist : Start Time : Consultant :
Dr.PRASHANT OBEROI FollowUpFOLLOW-UP Instructions Action PlanOS- s/p PE+IOL. Pt. comfortable. O/E- OS- lids- min.
edema cornea- DF+ min edema, PCIOL in place. ADV- topicals started. Tab. Diamox 250mg bd*5days, iotim e/d bd *1week post op care explained.
RTC on tuesday at NSN. Nutritional ScreeningNo special dietary requirements advicedExamined by Consultant: Dr.PRASHANT OBEROI Time:
02-04-2015 08:55:42,
2015/04/01 12:07,1103830,B 2 BASERA,46 BESANT AVENUE ROAD,ADYAR,NULL,CHENNAI,TN,INDIA,600 020);

error as follows

Error Code: 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
Posted
Updated 14-Dec-17 21:11pm

1 solution

You must quote all text field values:
SQL
... VALUES('NAVA', 1002151, 'VIJAYALAKAHSMI K V', 'Fema', 2003-12-23 14:33, 1940-08-23 00:00, 75, 'Medical Record No. ...', ...);

In your above example the MCS_CASE_SUMMARY value contains a comma which is the field delimiter.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900