Jump to content

1064 SQLSTATE: 42000 (ER_PARSE_ERROR)

ask

By ask
in MySQL Help

 Share

Recommended Posts

ask Newbie

ask

Posted
Posted

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!

Link to comment
Share on other sites
ask Newbie

ask

Posted
  • Author
Posted

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

Link to comment
Share on other sites
kickstart Member

kickstart

Posted
Posted

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

 

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.