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