ask Posted September 6, 2010 Share Posted September 6, 2010 Hello, I've got an error in filemaker pro 10 after I edited a table called delta in sequel pro. I don't know what to do. I searched the internet and I found a lot but the thing is that I'm not familiar with mysql. If someone could help me I would be very grateful. The error message is: You have an error in your sql syntax; check the manual that corresponds to your sql mysql server version for the right syntax to use near 'Visit_id='02100301' AND Round_Number='1') OR (Visit_id='02100302' AND Round_Number' at line 1. This is the syntax CREATE TABLE `delta` ( `Visit_id` varchar(12) NOT NULL DEFAULT '', `Round_Number` enum('1','2','3','4') NOT NULL DEFAULT '1', Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/212653-1064-sqlstate-42000-er_parse_error/ Share on other sites More sharing options...
kickstart Posted September 6, 2010 Share Posted September 6, 2010 Hi The error you are getting looks to be from a select statement. Can you give us the full statement to check? All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/212653-1064-sqlstate-42000-er_parse_error/#findComment-1107805 Share on other sites More sharing options...
ask Posted September 6, 2010 Author Share Posted September 6, 2010 I hope that this is what you need... CREATE TABLE `delta` ( `Visit_id` varchar(12) NOT NULL DEFAULT 'X', `Round_Number` enum('1','2','3','4') NOT NULL DEFAULT '1', `Leeftijd_delta` int(10) DEFAULT NULL, `Leeftijd_deltaproc` int(10) DEFAULT NULL, `Gewicht_delta` decimal(5,2) DEFAULT NULL, `Gewicht_deltaproc` decimal(5,2) DEFAULT NULL, `BMI_delta` decimal(5,1) DEFAULT NULL, `BMI_deltaproc` decimal(5,1) DEFAULT NULL, `Waist_delta` decimal(5,1) DEFAULT NULL, `Waist_deltaproc` decimal(5,1) DEFAULT NULL, `Hip_delta` decimal(5,1) DEFAULT NULL, `Hip_deltaproc` decimal(5,1) DEFAULT NULL, `WHR_delta` decimal(5,2) DEFAULT NULL, `WHR_deltaproc` decimal(5,2) DEFAULT NULL, `Sternotch_carotid_delta` decimal(5,1) DEFAULT NULL, `Sternotch_carotid_deltaproc` decimal(5,1) DEFAULT NULL, `Sternotch_radial_delta` decimal(5,1) DEFAULT NULL, `Sternotch_radial_deltaproc` decimal(5,1) DEFAULT NULL, `Sternotch_femoral_delta` decimal(5,1) DEFAULT NULL, `Sternotch_femoral_deltaproc` decimal(5,1) DEFAULT NULL, `Pack_year_delta` decimal(5,1) DEFAULT NULL, `Pack_year_deltaproc` decimal(5,1) DEFAULT NULL, `Cumulatieve_duur_pilinname_delta` tinyint(4) DEFAULT NULL, `Cumulatieve_duur_pilinname_deltaproc` tinyint(4) DEFAULT NULL, `Cumulatieve_duur_substitutietherapie_delta` tinyint(4) DEFAULT NULL, `Cumulatieve_duur_substitutietherapie_deltaproc` tinyint(4) DEFAULT NULL, `HA_Tchol_delta` int(5) DEFAULT NULL, `HA_Tchol_deltaproc` int(5) DEFAULT NULL, `HA_LDL_delta` int(5) DEFAULT NULL, `HA_LDL_deltaproc` int(5) DEFAULT NULL, `HA_HDL_delta` int(5) DEFAULT NULL, `HA_HDL_deltaproc` int(5) DEFAULT NULL, `HA_TG_delta` int(5) DEFAULT NULL, `HA_TG_deltaproc` int(5) DEFAULT NULL, `Links_SBP_delta` int(5) DEFAULT NULL, `Links_SBP_deltaproc` int(5) DEFAULT NULL, `Links_DBP_delta` int(5) DEFAULT NULL, `Links_DBP_deltaproc` int(5) DEFAULT NULL, `Rechts_SBP_delta` int(5) DEFAULT NULL, `Rechts_SBP_deltaproc` int(5) DEFAULT NULL, `Rechts_DBP_delta` int(5) DEFAULT NULL, `Rechts_DBP_deltaproc` int(5) DEFAULT NULL, `Mere_SBP_delta` int(5) DEFAULT NULL, `Mere_SBP_deltaproc` int(5) DEFAULT NULL, `Mere_DBP_delta` int(5) DEFAULT NULL, `Mere_DBP_deltaproc` int(5) DEFAULT NULL, `Mere_HR_delta` int(5) DEFAULT NULL, `Mere_HR_deltaproc` int(5) DEFAULT NULL, `HA_SBP_delta` int(5) DEFAULT NULL, `HA_SBP_deltaproc` int(5) DEFAULT NULL, `HA_DBP_delta` int(5) DEFAULT NULL, `HA_DBP_deltaproc` int(5) DEFAULT NULL, `Fibrig_delta` int(5) DEFAULT NULL, `Fibrig_deltaproc` int(5) DEFAULT NULL, `RBC_delta` decimal(5,2) DEFAULT NULL, `RBC_deltaproc` decimal(5,2) DEFAULT NULL, `Hct_delta` decimal(5,1) DEFAULT NULL, `Hct_deltaproc` decimal(5,1) DEFAULT NULL, `Hgb_delta` decimal(5,1) DEFAULT NULL, `Hgb_deltaproc` decimal(5,1) DEFAULT NULL, `WBC_delta` decimal(5,2) DEFAULT NULL, `WBC_deltaproc` decimal(5,2) DEFAULT NULL, `Troc_delta` int(5) DEFAULT NULL, `Troc_deltaproc` int(5) DEFAULT NULL, `MCV_delta` decimal(5,1) DEFAULT NULL, `MCV_deltaproc` decimal(5,1) DEFAULT NULL, `MCH_delta` decimal(5,1) DEFAULT NULL, `MCH_deltaproc` decimal(5,1) DEFAULT NULL, `RDW_delta` decimal(5,1) DEFAULT NULL, `RDW_deltaproc` decimal(5,1) DEFAULT NULL, `MCHC_delta` decimal(5,1) DEFAULT NULL, `MCHC_deltaproc` decimal(5,1) DEFAULT NULL, `MPV_delta` decimal(5,1) DEFAULT NULL, `MPV_deltaproc` decimal(5,1) DEFAULT NULL, `Chol_delta` decimal(5,1) DEFAULT NULL, `Chol_deltaproc` decimal(5,1) DEFAULT NULL, `HDLCHN_delta` tinyint(5) DEFAULT NULL, `HDLCHN_deltaproc` tinyint(5) DEFAULT NULL, `HDLProc_delta` decimal(5,1) DEFAULT NULL, `HDLProc_deltaproc` decimal(5,1) DEFAULT NULL, `TRIGL_delta` decimal(8,4) DEFAULT NULL, `TRIGL_deltaproc` decimal(8,2) DEFAULT NULL, `LDLCHO_delta` decimal(5,1) DEFAULT NULL, `LDLCHO_deltaproc` decimal(5,1) DEFAULT NULL, `KREATOUD_delta` decimal(5,3) DEFAULT NULL, `KREATOUD_deltaproc` decimal(5,2) DEFAULT NULL, `KREAT_delta` decimal(5,3) DEFAULT NULL, `KREAT_deltaproc` decimal(5,2) DEFAULT NULL, `URINZ_delta` decimal(5,2) DEFAULT NULL, `URINZ_deltaproc` decimal(5,2) DEFAULT NULL, `GLUC_delta` decimal(5,3) DEFAULT NULL, `GLUC_deltaproc` decimal(5,2) DEFAULT NULL, `Na_delta` int(5) DEFAULT NULL, `Na_deltaproc` int(5) DEFAULT NULL, `K_delta` decimal(5,2) DEFAULT NULL, `K_deltaproc` decimal(5,2) DEFAULT NULL, `ss_CRP_delta` decimal(6,3) DEFAULT NULL, `ss_CRP_deltaproc` decimal(6,2) DEFAULT NULL, `OxLDL_delta` decimal(6,3) DEFAULT NULL, `OxLDL_deltaproc` decimal(6,2) DEFAULT NULL, `IL_6_delta` decimal(6,3) DEFAULT NULL, `IL_6_deltaproc` decimal(6,2) DEFAULT NULL, `Hcy_delta` decimal(6,3) DEFAULT NULL, `Hcy_deltaproc` decimal(6,2) DEFAULT NULL, `HR_delta` double(6,3) DEFAULT NULL, `HR_deltaproc` double(6,2) DEFAULT NULL, `RR_delta` double(8,3) DEFAULT NULL, `RR_deltaproc` double(8,2) DEFAULT NULL, `P_delta` double(6,3) DEFAULT NULL, `P_deltaproc` double(6,2) DEFAULT NULL, `PQ_delta` double(6,3) DEFAULT NULL, `PQ_deltaproc` double(6,2) DEFAULT NULL, `QRS_delta` double(6,3) DEFAULT NULL, `QRS_deltaproc` double(6,2) DEFAULT NULL, `QT_delta` double(6,3) DEFAULT NULL, `QT_deltaproc` double(6,2) DEFAULT NULL, `QTC_delta` double(6,3) DEFAULT NULL, `QTC_deltaproc` double(6,2) DEFAULT NULL, `PAS_delta` double(6,3) DEFAULT NULL, `PAS_deltaproc` double(6,2) DEFAULT NULL, `QRSAS_delta` double(6,3) DEFAULT NULL, `QRSAS_deltaproc` double(6,2) DEFAULT NULL, `TAS_delta` double(6,3) DEFAULT NULL, `TAS_deltaproc` double(6,2) DEFAULT NULL, `QTm_delta` double(6,3) DEFAULT NULL, `QTm_deltaproc` double(6,2) DEFAULT NULL, `QTsd_delta` double(6,3) DEFAULT NULL, `QTsd_deltaproc` double(6,2) DEFAULT NULL, `QTmin_delta` double(6,3) DEFAULT NULL, `QTmin_deltaproc` double(6,2) DEFAULT NULL, `QTmax_delta` double(6,3) DEFAULT NULL, `QTmax_deltaproc` double(6,2) DEFAULT NULL, `QTd_delta` double(6,3) DEFAULT NULL, `QTd_deltaproc` double(6,2) DEFAULT NULL, `Soklyon_delta` double(6,3) DEFAULT NULL, `Soklyon_deltaproc` double(6,2) DEFAULT NULL, `CornVD_delta` double(9,3) DEFAULT NULL, `CornVD_deltaproc` double(9,2) DEFAULT NULL, `CornGAVD_delta` double(9,3) DEFAULT NULL, `CornGAVD_deltaproc` double(9,2) DEFAULT NULL, `CornFB_delta` double(9,3) DEFAULT NULL, `AVmax_delta` double(8,3) DEFAULT NULL, `AVmax_deltaproc` double(8,2) DEFAULT NULL, `AVmean_delta` double(8,3) DEFAULT NULL, `AVmean_deltaproc` double(8,2) DEFAULT NULL, `APmax_delta` double(8,3) DEFAULT NULL, `APmax_deltaproc` double(8,2) DEFAULT NULL, `APmean_delta` double(8,3) DEFAULT NULL, `APmean_deltaproc` double(8,2) DEFAULT NULL, `AOED_delta` double(8,3) DEFAULT NULL, `AOED_deltaproc` double(8,2) DEFAULT NULL, `AOVTI_delta` double(8,3) DEFAULT NULL, `AOVTI_deltaproc` double(8,2) DEFAULT NULL, `AOHR_delta` double(8,3) DEFAULT NULL, `AOHR_deltaproc` double(8,2) DEFAULT NULL, `SVOAVTI_delta` double(8,3) DEFAULT NULL, `SVOAVTI_deltaproc` double(8,2) DEFAULT NULL, `COAOVTI_delta` double(8,3) DEFAULT NULL, `COAOVTI_deltaproc` double(8,2) DEFAULT NULL, `QAO_delta` decimal(8,3) DEFAULT NULL, `QAO_deltaproc` decimal(8,2) DEFAULT NULL, `EDRA_delta` double(8,3) DEFAULT NULL, `EDRA_deltaproc` double(8,2) DEFAULT NULL, `EDC_delta` double(8,3) DEFAULT NULL, `EDC_deltaproc` double(8,2) DEFAULT NULL, `EDA_delta` double(8,3) DEFAULT NULL, `EDA_deltaproc` double(8,2) DEFAULT NULL, `EDVLA_delta` double(8,3) DEFAULT NULL, `EDVLA_deltaproc` double(8,2) DEFAULT NULL, `EDVS_delta` double(8,3) DEFAULT NULL, `EDVS_deltaproc` double(8,2) DEFAULT NULL, `ESRA_delta` double(8,3) DEFAULT NULL, `ESRA_deltaproc` double(8,2) DEFAULT NULL, `ESC_delta` double(8,3) DEFAULT NULL, `ESC_deltaproc` double(8,2) DEFAULT NULL, `ESA_delta` double(8,3) DEFAULT NULL, `ESA_deltaproc` double(8,2) DEFAULT NULL, `ESVLA_delta` double(8,3) DEFAULT NULL, `ESVLA_deltaproc` double(8,2) DEFAULT NULL, `ESVS_delta` double(8,3) DEFAULT NULL, `ESVS_deltaproc` double(8,2) DEFAULT NULL, `EFVLA_delta` double(8,3) DEFAULT NULL, `EFVLA_deltaproc` double(8,2) DEFAULT NULL, `SVVLA_delta` double(8,3) DEFAULT NULL, `SVVLA_deltaproc` double(8,2) DEFAULT NULL, `COVLA_delta` double(8,3) DEFAULT NULL, `COVLA_deltaproc` double(8,2) DEFAULT NULL, `EFVS_delta` double(8,3) DEFAULT NULL, `EFVS_deltaproc` double(8,2) DEFAULT NULL, `SVVS_delta` double(8,3) DEFAULT NULL, `SVVS_deltaproc` double(8,2) DEFAULT NULL, `COVS_delta` double(8,3) DEFAULT NULL, `COVS_deltaproc` double(8,2) DEFAULT NULL, `LVMI2d_delta` double(6,3) DEFAULT NULL, `LVMI2d_deltaproc` double(6,2) DEFAULT NULL, `LVMIm_delta` double(6,3) DEFAULT NULL, `LVMIm_deltaproc` double(6,2) DEFAULT NULL, `LVMI_delta` double(6,1) DEFAULT NULL, `LVMI_deltaproc` double(6,1) DEFAULT NULL, `IVSD_delta` double(6,1) DEFAULT NULL, `IVSD_deltaproc` double(6,1) DEFAULT NULL, `LVEDD_delta` double(6,1) DEFAULT NULL, `LVEDD_deltaproc` double(6,1) DEFAULT NULL, `PWD_delta` double(6,1) DEFAULT NULL, `PWD_deltaproc` double(6,1) DEFAULT NULL, `EF_delta` double(6,1) DEFAULT NULL, `EF_deltaproc` double(6,1) DEFAULT NULL, `EFPSLAX_delta` double(6,1) DEFAULT NULL, `EFPSLAX_deltaproc` double(6,1) DEFAULT NULL, `SV_delta` double(6,1) DEFAULT NULL, `SV_deltaproc` double(6,1) DEFAULT NULL, `CO_delta` decimal(6,1) DEFAULT NULL, `CO_deltaproc` decimal(6,1) DEFAULT NULL, `EchoBSA_delta` double(6,3) DEFAULT NULL, `EchoBSA_deltaproc` double(6,2) DEFAULT NULL, `LVEDIDI_delta` double(6,1) DEFAULT NULL, `LVEDIDI_deltaproc` double(6,1) DEFAULT NULL, `LVEDVI_delta` double(6,1) DEFAULT NULL, `LVEDVI_deltaproc` double(6,1) DEFAULT NULL, `RWT_delta` double(6,3) DEFAULT NULL, `RWT_deltaproc` double(6,2) DEFAULT NULL, `IVSD2D_delta` decimal(8,3) DEFAULT NULL, `IVSD2D_deltaproc` decimal(8,2) DEFAULT NULL, `LVEDD2D_delta` decimal(8,3) DEFAULT NULL, `LVEDD2D_deltaproc` decimal(8,2) DEFAULT NULL, `PWD2D_delta` decimal(8,3) DEFAULT NULL, `PWD2D_deltaproc` decimal(8,2) DEFAULT NULL, `IVSS2D_delta` decimal(8,3) DEFAULT NULL, `IVSS2D_deltaproc` decimal(8,2) DEFAULT NULL, `LVESD2D_delta` decimal(8,3) DEFAULT NULL, `LVESD2D_deltaproc` decimal(8,2) DEFAULT NULL, `PWS2D_delta` decimal(8,3) DEFAULT NULL, `PWS2D_deltaproc` decimal(8,2) DEFAULT NULL, `Mass2d_delta` double(8,3) DEFAULT NULL, `Mass2d_deltaproc` double(8,2) DEFAULT NULL, `EDVtei2d_delta` double(8,3) DEFAULT NULL, `EDVtei2d_deltaproc` double(8,2) DEFAULT NULL, `ESVtei2d_delta` double(8,3) DEFAULT NULL, `ESVtei2d_deltaproc` double(8,2) DEFAULT NULL, `FS2D_delta` double(8,3) DEFAULT NULL, `FS2D_deltaproc` double(8,2) DEFAULT NULL, `EF2D_delta` double(8,3) DEFAULT NULL, `EF2D_deltaproc` double(8,2) DEFAULT NULL, `SV2D_delta` double(8,3) DEFAULT NULL, `SV2D_deltaproc` double(8,2) DEFAULT NULL, `CO2D_delta` double(8,3) DEFAULT NULL, `CO2D_deltaproc` double(8,2) DEFAULT NULL, `LVOT_delta` decimal(8,3) DEFAULT NULL, `LVOT_deltaproc` decimal(8,2) DEFAULT NULL, `LVOTArea_delta` double(8,3) DEFAULT NULL, `LVOTArea_deltaproc` double(8,2) DEFAULT NULL, `IVSDM_delta` decimal(8,3) DEFAULT NULL, `IVSDM_deltaproc` decimal(8,2) DEFAULT NULL, `LVEDDM_delta` decimal(8,3) DEFAULT NULL, `LVEDDM_deltaproc` decimal(8,2) DEFAULT NULL, `PWDM_delta` decimal(8,3) DEFAULT NULL, `PWDM_deltaproc` decimal(8,2) DEFAULT NULL, `IVSSM_delta` decimal(8,3) DEFAULT NULL, `IVSSM_deltaproc` decimal(8,2) DEFAULT NULL, `LVESDM_delta` decimal(8,3) DEFAULT NULL, `LVESDM_deltaproc` decimal(8,2) DEFAULT NULL, `PWSM_delta` decimal(8,3) DEFAULT NULL, `PWSM_deltaproc` decimal(8,2) DEFAULT NULL, `Massm_delta` double(8,3) DEFAULT NULL, `Massm_deltaproc` double(8,2) DEFAULT NULL, `EDVteim_delta` double(8,3) DEFAULT NULL, `EDVteim_deltaproc` double(8,2) DEFAULT NULL, `ESVteim_delta` double(8,3) DEFAULT NULL, `ESVteim_deltaproc` double(8,2) DEFAULT NULL, `FSm_delta` double(8,3) DEFAULT NULL, `FSm_deltaproc` double(8,2) DEFAULT NULL, `EFm_delta` double(8,3) DEFAULT NULL, `EFm_deltaproc` double(8,2) DEFAULT NULL, `SVm_delta` double(8,3) DEFAULT NULL, `SVm_deltaproc` double(8,2) DEFAULT NULL, `COm_delta` double(8,3) DEFAULT NULL, `COm_deltaproc` double(8,2) DEFAULT NULL, `EoverEm_delta` double(6,3) DEFAULT NULL, `EoverEm_deltaproc` double(6,2) DEFAULT NULL, `EoverVP_delta` double(6,3) DEFAULT NULL, `EoverVP_deltaproc` double(6,2) DEFAULT NULL, `VPe_delta` double(6,3) DEFAULT NULL, `VPe_deltaproc` double(6,2) DEFAULT NULL, `VPa_delta` double(6,3) DEFAULT NULL, `VPa_deltaproc` double(6,2) DEFAULT NULL, `VR_delta` double(6,3) DEFAULT NULL, `VR_deltaproc` double(6,2) DEFAULT NULL, `TMDT_delta` double(6,3) DEFAULT NULL, `TMDT_deltaproc` double(6,2) DEFAULT NULL, `TME_delta` double(6,3) DEFAULT NULL, `TME_deltaproc` double(6,2) DEFAULT NULL, `TMA_delta` double(6,3) DEFAULT NULL, `TMA_deltaproc` double(6,2) DEFAULT NULL, `TMEAR_delta` double(6,3) DEFAULT NULL, `TMEAR_deltaproc` double(6,2) DEFAULT NULL, `TMAdur_delta` double(6,3) DEFAULT NULL, `TMAdur_deltaproc` double(6,2) DEFAULT NULL, `TMTTPA_delta` double(6,3) DEFAULT NULL, `TMTTPA_deltaproc` double(6,2) DEFAULT NULL, `TMPHT_delta` double(6,3) DEFAULT NULL, `TMPHT_deltaproc` double(6,2) DEFAULT NULL, `TMEdur_delta` double(6,3) DEFAULT NULL, `TMEdur_deltaproc` double(6,2) DEFAULT NULL, `TMExdur_delta` double(6,3) DEFAULT NULL, `TMExdur_deltaproc` double(6,2) DEFAULT NULL, `TMEAdur_delta` double(6,3) DEFAULT NULL, `TMEAdur_deltaproc` double(6,2) DEFAULT NULL, `TMAEdur_delta` double(6,3) DEFAULT NULL, `TMAEdur_deltaproc` double(6,2) DEFAULT NULL, `TDSMAX_delta` double(6,3) DEFAULT NULL, `TDSMAX_deltaproc` double(6,2) DEFAULT NULL, `TDSMEAN_delta` double(6,3) DEFAULT NULL, `TDSMEAN_deltaproc` double(6,2) DEFAULT NULL, `TDSET_delta` double(6,3) DEFAULT NULL, `TDSET_deltaproc` double(6,2) DEFAULT NULL, `TDSVTI_delta` double(6,3) DEFAULT NULL, `TDSVTI_deltaproc` double(6,2) DEFAULT NULL, `TDHR_delta` double(6,3) DEFAULT NULL, `TDHR_deltaproc` double(6,2) DEFAULT NULL, `TDSE_delta` double(6,3) DEFAULT NULL, `TDSE_deltaproc` double(6,2) DEFAULT NULL, `TDVR_delta` double(6,3) DEFAULT NULL, `TDVR_deltaproc` double(6,2) DEFAULT NULL, `TDDT_delta` double(6,3) DEFAULT NULL, `TDDT_deltaproc` double(6,2) DEFAULT NULL, `TDE_delta` double(6,3) DEFAULT NULL, `TDE_deltaproc` double(6,2) DEFAULT NULL, `TDA_delta` double(6,3) DEFAULT NULL, `TDA_deltaproc` double(6,2) DEFAULT NULL, `TDEAR_delta` double(6,3) DEFAULT NULL, `TDEAR_deltaproc` double(6,2) DEFAULT NULL, `TDAdur_delta` double(6,3) DEFAULT NULL, `TDAdur_deltaproc` double(6,2) DEFAULT NULL, `TDTTPA_delta` double(6,3) DEFAULT NULL, `TDTTPA_deltaproc` double(6,2) DEFAULT NULL, `TDPHT_delta` double(6,3) DEFAULT NULL, `TDPHT_deltaproc` double(6,2) DEFAULT NULL, `TDArea_delta` double(6,3) DEFAULT NULL, `TDArea_deltaproc` double(6,2) DEFAULT NULL, `TDEdur_delta` double(6,3) DEFAULT NULL, `TDEdur_deltaproc` double(6,2) DEFAULT NULL, `TDEXdur_delta` double(6,3) DEFAULT NULL, `TDEXdur_deltaproc` double(6,2) DEFAULT NULL, `TDEAdur_delta` double(6,3) DEFAULT NULL, `TDEAdur_deltaproc` double(6,2) DEFAULT NULL, `TDAEdur_delta` double(6,3) DEFAULT NULL, `TDAEdur-deltaproc` double(6,2) DEFAULT NULL, `IVRT_delta` double(6,3) DEFAULT NULL, `IVRT_deltaproc` double(6,2) DEFAULT NULL, `clh_delta` double(6,3) DEFAULT NULL, `clh_deltaproc` double(6,2) DEFAULT NULL, `IMTCL_delta` double(6,2) DEFAULT NULL, `IMTCL_deltaproc` double(6,2) DEFAULT NULL, `IMTCLMIN_delta` double(6,3) DEFAULT NULL, `IMTCLMIN_deltaproc` double(6,2) DEFAULT NULL, `IMTCLMAX_delta` double(6,3) DEFAULT NULL, `IMTCLMAX_deltaproc` double(6,2) DEFAULT NULL, `crh_delta` double(6,3) DEFAULT NULL, `crh_deltaproc` double(6,2) DEFAULT NULL, `IMTCR_delta` double(6,2) DEFAULT NULL, `IMTCR_deltaproc` double(6,2) DEFAULT NULL, `IMTCRMIN_delta` double(6,3) DEFAULT NULL, `IMTCRMIN_deltaproc` double(6,2) DEFAULT NULL, `IMTCRMAX_delta` double(6,3) DEFAULT NULL, `IMTCRMAX_deltaproc` double(6,2) DEFAULT NULL, `flh_delta` double(6,3) DEFAULT NULL, `flh_deltaproc` double(6,2) DEFAULT NULL, `IMTFL_delta` double(6,3) DEFAULT NULL, `IMTFL_deltaproc` double(6,2) DEFAULT NULL, `IMTFLMIN_delta` double(6,3) DEFAULT NULL, `IMTFLMIN_deltaproc` double(6,2) DEFAULT NULL, `IMTFLMAX_delta` double(6,3) DEFAULT NULL, `IMTFLMAX_deltaproc` double(6,2) DEFAULT NULL, `frh_delta` double(6,3) DEFAULT NULL, `frh_deltaproc` double(6,2) DEFAULT NULL, `IMTFR_delta` double(6,3) DEFAULT NULL, `IMTFR_deltaproc` double(6,2) DEFAULT NULL, `IMTFRMIN_delta` double(6,3) DEFAULT NULL, `IMTFRMIN_deltaproc` double(6,2) DEFAULT NULL, `IMTFRMAX_delta` double(6,3) DEFAULT NULL, `IMTFRMAX_deltaproc` double(6,2) DEFAULT NULL, `QCAR_delta` double(6,3) DEFAULT NULL, `QCAR_deltaproc` double(6,2) DEFAULT NULL, `QFEM_delta` double(6,3) DEFAULT NULL, `QFEM_deltaproc` double(6,2) DEFAULT NULL, `Left carotid hump (mm)_delta` decimal(6,3) DEFAULT NULL, `Left carotid hump (mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Right carotid hump (mm)_delta` decimal(6,3) DEFAULT NULL, `Right carotid hump (mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Left femoral hump (mm)_delta` decimal(6,3) DEFAULT NULL, `Left femoral hump (mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Right femoral hump (mm)_delta` decimal(6,3) DEFAULT NULL, `Right femoral hump (mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (left carotid; mean; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (left carotid; mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (left carotid; min; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (left carotid; min; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (left carotid; max; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (left carotid; max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (right carotid; mean; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (right carotid; mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (right carotid; min; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (right carotid; min; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (right carotid; max; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (right carotid; max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (left femoral; mean; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (left femoral; mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (left femoral; min; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (left femoral; min; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (left femoral; max; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (left femoral; max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (right femoral; mean; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (right femoral; mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (right femoral; min; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (right femoral; min; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `IMT (right femoral; max; mm)_delta` decimal(6,3) DEFAULT NULL, `IMT (right femoral; max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (left carotid; mean; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (left carotid; mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (left carotid; max; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (left carotid; max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (left carotid; min; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (left carotid; min; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (right carotid; mean; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (right carotid; mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (right carotid; max; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (right carotid; max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (right carotid; min; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (right carotid; min; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (left femoral; mean; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (left femoral; mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (left femoral; max; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (left femoral; max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (left femoral; min; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (left femoral; min; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (right femoral; mean; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (right femoral; mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (right femoral; max; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (rigth femoral; max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Low shear stress IMT (right femoral; min; mm)_delta` decimal(6,3) DEFAULT NULL, `Low shear stress IMT (right femoral; min; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Carotid IMT (mean-mean; mm)_delta` decimal(6,3) DEFAULT NULL, `Carotid IMT (mean-mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Carotid IMT (max-mean; mm)_delta` decimal(6,3) DEFAULT NULL, `Carotid IMT (max-mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Carotid IMT (mean-max; mm)_delta` decimal(6,3) DEFAULT NULL, `Carotid IMT (mean-max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Carotid IMT (max-max; mm)_delta` decimal(6,3) DEFAULT NULL, `Carotid IMT (max-max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Femoral IMT (mean-mean; mm)_delta` decimal(6,3) DEFAULT NULL, `Femoral IMT (mean-mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Femoral IMT (max-mean; mm)_delta` decimal(6,3) DEFAULT NULL, `Femoral IMT (max-mean; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Femoral IMT (mean-max; mm)_delta` decimal(6,3) DEFAULT NULL, `Femoral IMT (mean-max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Femoral IMT (max-max; mm)_delta` decimal(6,3) DEFAULT NULL, `Femoral IMT (max-max; mm)_deltaproc` decimal(6,2) DEFAULT NULL, `Riskc_delta` decimal(10,1) DEFAULT NULL, `Riskc_deltaproc` decimal(10,1) DEFAULT NULL, `Risknc_delta` decimal(10,1) DEFAULT NULL, `Risknc_deltaproc` decimal(10,1) DEFAULT NULL, `Risktot_delta` decimal(10,1) DEFAULT NULL, `Risktot_deltaproc` decimal(10,1) DEFAULT NULL, `Agescore_delta` int(6) DEFAULT NULL, `Agescore_deltaproc` int(6) DEFAULT NULL, `Riskc60_delta` decimal(10,1) DEFAULT NULL, `Riskc60_deltaproc` decimal(10,1) DEFAULT NULL, `Risknc60_delta` decimal(10,1) DEFAULT NULL, `Risknc60_deltaproc` decimal(10,1) DEFAULT NULL, `Risktot60_delta` decimal(10,1) DEFAULT NULL, `Risktot60_deltaproc` decimal(10,1) DEFAULT NULL, PRIMARY KEY (`Visit_id`,`Round_Number`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; Thank you very much for your help Quote Link to comment https://forums.phpfreaks.com/topic/212653-1064-sqlstate-42000-er_parse_error/#findComment-1107825 Share on other sites More sharing options...
kickstart Posted September 6, 2010 Share Posted September 6, 2010 Hi Somewhere you will have a line that looks something like SELECT * FROM delta WHERE (Visit_id='02100301' AND Round_Number='1') OR (Visit_id='02100302' AND Round_Number='1') OR (Visit_id='02100303' AND Round_Number='1') OR (Visit_id='02100304' AND Round_Number='1') The error you are getting is with that statement (or possibly an UPDATE or DELETE statement) rather than the table create statement. As an aside, having a table that large is generally not a good idea. The fields look like various measurements, which may or may not be there for a visit date. I would separate each pair of fields off onto a separate table, something like this VisitUniqueId - ie, some way to refer to a combination of visit_id and round_number MeasurementType - ie, whether it is Sternotch_carotid or Sternotch_radial or some other measure DeltaValue DeltaProcValue You currently have around 470 columns of data, and I suspect that on most rows most of those fields are NULL. Also, the field CornFB_delta doesn't appear to have a coresponding CornFB_deltaproc. Is that deliberate? All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/212653-1064-sqlstate-42000-er_parse_error/#findComment-1107834 Share on other sites More sharing options...
ask Posted September 6, 2010 Author Share Posted September 6, 2010 Hi Keith Thanks for all your help! You're right concerning the statement I will have a look but I think I might need some help. Famke Quote Link to comment https://forums.phpfreaks.com/topic/212653-1064-sqlstate-42000-er_parse_error/#findComment-1107842 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.