mysql - ERROR 1117 (HY000): Too many columns -
hi trying bring together 2 tables in mysql , came error 1117: many columns,i have around 800 columns in both table ...is there way resolve issue because need single table,because need analytial purpose .... checked on web , found mysql incapable handle such big data,but hold around 4000 columns ....
create table full_join select a.period, a.market, det_cs_grp, dove_cs_grp, vivel_cs_grp, venus_cs_grp, cin_cs_grp, chand_cs_grp, san_orange_cs_grp, fiama_cs_grp, jb_cs_grp, rex_cs_grp, lux_cs_grp, lb_cs_grp, pears_cs_grp, empty_cs_grp, hamam_cs_grp, liril_cs_grp, margo_cs_grp, breeze_cs_grp, gd_cs_grp, nima_cs_grp, savlon_cs_grp, superia_cs_grp, san_white_cs_grp, mysore_cs_grp, med_cs_grp, nature_power_cs_grp, emami_cs_grp, san_gly_cs_grp, cuticura_cs_grp, park_avn_cs_grp, k_p_nambood_cs_grp, san_others_cs_grp, dyna_cs_grp, himalaya_neem_cs_grp, moti_cs_grp, doy_cs_grp, yardley_eng_laven_cs_grp, jo_cs_grp, axe_cs_grp, fair_beat_cs_grp, san_gly_genre1_cs_grp, san_gly_genre2_cs_grp, san_gly_genre3_cs_grp, san_gly_genre4_cs_grp, san_gly_genre5_cs_grp, san_gly_genre6_cs_grp, san_gly_genre7_cs_grp, san_gly_genre8_cs_grp, san_gly_genre9_cs_grp, san_gly_genre10_cs_grp, san_gly_genre11_cs_grp, san_gly_genre12_cs_grp, san_gly_genre13_cs_grp, san_gly_genre14_cs_grp, san_gly_genre15_cs_grp, san_gly_genre16_cs_grp, san_gly_genre17_cs_grp, san_gly_genre18_cs_grp, san_gly_genre19_cs_grp, san_gly_genre20_cs_grp, san_gly_genre21_cs_grp, san_gly_genre22_cs_grp, san_gly_genre23_cs_grp, san_gly_genre24_cs_grp, san_gly_genre25_cs_grp, san_gly_genre26_cs_grp, san_gly_genre27_cs_grp, san_gly_genre28_cs_grp, san_gly_genre29_cs_grp, san_gly_genre30_cs_grp, san_gly_genre31_cs_grp, san_gly_genre32_cs_grp, san_gly_genre33_cs_grp, san_gly_genre34_cs_grp, san_gly_genre35_cs_grp, san_gly_genre36_cs_grp, san_gly_genre37_cs_grp, san_gly_genre38_cs_grp, san_gly_genre39_cs_grp, san_gly_genre40_cs_grp, san_gly_genre41_cs_grp, san_gly_genre42_cs_grp, san_gly_genre43_cs_grp, san_orange_genre1_cs_grp, san_orange_genre2_cs_grp, san_orange_genre3_cs_grp, san_orange_genre4_cs_grp, san_orange_genre5_cs_grp, san_orange_genre6_cs_grp, san_orange_genre7_cs_grp, san_orange_genre8_cs_grp, san_orange_genre9_cs_grp, san_orange_genre10_cs_grp, san_orange_genre11_cs_grp, san_orange_genre12_cs_grp, san_orange_genre13_cs_grp, san_orange_genre14_cs_grp, san_orange_genre15_cs_grp, san_orange_genre16_cs_grp, san_orange_genre17_cs_grp, san_orange_genre18_cs_grp, san_orange_genre19_cs_grp, san_orange_genre20_cs_grp, san_orange_genre21_cs_grp, san_orange_genre22_cs_grp, san_orange_genre23_cs_grp, san_orange_genre24_cs_grp, san_orange_genre25_cs_grp, san_orange_genre26_cs_grp, san_orange_genre27_cs_grp, san_orange_genre28_cs_grp, san_orange_genre29_cs_grp, san_orange_genre30_cs_grp, san_orange_genre31_cs_grp, san_orange_genre32_cs_grp, san_orange_genre33_cs_grp, san_orange_genre34_cs_grp, san_orange_genre35_cs_grp, san_orange_genre36_cs_grp, san_orange_genre37_cs_grp, san_orange_genre38_cs_grp, san_orange_genre39_cs_grp, san_orange_genre40_cs_grp, san_orange_genre41_cs_grp, san_orange_genre42_cs_grp, san_orange_genre43_cs_grp, san_orange_genre44_cs_grp, san_orange_genre45_cs_grp, san_others_genre1_cs_grp, san_others_genre2_cs_grp, san_others_genre3_cs_grp, san_others_genre4_cs_grp, san_others_genre5_cs_grp, san_others_genre6_cs_grp, san_others_genre7_cs_grp, san_others_genre8_cs_grp, san_others_genre9_cs_grp, san_others_genre10_cs_grp, san_others_genre11_cs_grp, san_others_genre12_cs_grp, san_others_genre13_cs_grp, san_others_genre14_cs_grp, san_others_genre15_cs_grp, san_others_genre16_cs_grp, san_others_genre17_cs_grp, san_others_genre18_cs_grp, san_others_genre19_cs_grp, san_others_genre20_cs_grp, san_others_genre21_cs_grp, san_others_genre22_cs_grp, san_others_genre23_cs_grp, san_others_genre24_cs_grp, san_others_genre25_cs_grp, san_others_genre26_cs_grp, san_others_genre27_cs_grp, san_others_genre28_cs_grp, san_others_genre29_cs_grp, san_others_genre30_cs_grp, san_others_genre31_cs_grp, san_others_genre32_cs_grp, san_others_genre33_cs_grp, san_others_genre34_cs_grp, san_others_genre35_cs_grp, san_others_genre36_cs_grp, san_white_genre1_cs_grp, san_white_genre2_cs_grp, san_white_genre3_cs_grp, san_white_genre4_cs_grp, san_white_genre5_cs_grp, san_white_genre6_cs_grp, san_white_genre7_cs_grp, san_white_genre8_cs_grp, san_white_genre9_cs_grp, san_white_genre10_cs_grp, san_white_genre11_cs_grp, san_white_genre12_cs_grp, san_white_genre13_cs_grp, san_white_genre14_cs_grp, san_white_genre15_cs_grp, san_white_genre16_cs_grp, san_white_genre17_cs_grp, san_white_genre18_cs_grp, san_white_genre19_cs_grp, san_white_genre20_cs_grp, san_white_genre21_cs_grp, san_white_genre22_cs_grp, san_white_genre23_cs_grp, san_white_genre24_cs_grp, san_white_genre25_cs_grp, san_white_genre26_cs_grp, san_white_genre27_cs_grp, san_white_genre28_cs_grp, san_white_genre29_cs_grp, san_white_genre30_cs_grp, san_white_genre31_cs_grp, san_white_genre32_cs_grp, san_white_genre33_cs_grp, san_white_genre34_cs_grp, san_white_genre35_cs_grp, san_white_genre36_cs_grp, san_white_genre37_cs_grp, san_gly_creative1_cs_grp, san_gly_creative10_cs_grp, san_gly_creative11_cs_grp, san_gly_creative12_cs_grp, san_gly_creative13_cs_grp, san_gly_creative14_cs_grp, san_gly_creative15_cs_grp, san_gly_creative16_cs_grp, san_gly_creative17_cs_grp, san_gly_creative18_cs_grp, san_gly_creative19_cs_grp, san_gly_creative2_cs_grp, san_gly_creative20_cs_grp, san_gly_creative21_cs_grp, san_gly_creative3_cs_grp, san_gly_creative4_cs_grp, san_gly_creative5_cs_grp, san_gly_creative6_cs_grp, san_gly_creative7_cs_grp, san_gly_creative8_cs_grp, san_gly_creative9_cs_grp, san_orange_creative1_cs_grp, san_orange_creative10_cs_grp, san_orange_creative11_cs_grp, san_orange_creative12_cs_grp, san_orange_creative13_cs_grp, san_orange_creative14_cs_grp, san_orange_creative15_cs_grp, san_orange_creative16_cs_grp, san_orange_creative17_cs_grp, san_orange_creative18_cs_grp, san_orange_creative19_cs_grp, san_orange_creative2_cs_grp, san_orange_creative20_cs_grp, san_orange_creative21_cs_grp, san_orange_creative22_cs_grp, san_orange_creative23_cs_grp, san_orange_creative24_cs_grp, san_orange_creative25_cs_grp, san_orange_creative26_cs_grp, san_orange_creative27_cs_grp, san_orange_creative28_cs_grp, san_orange_creative29_cs_grp, san_orange_creative3_cs_grp, san_orange_creative30_cs_grp, san_orange_creative31_cs_grp, san_orange_creative32_cs_grp, san_orange_creative33_cs_grp, san_orange_creative34_cs_grp, san_orange_creative35_cs_grp, san_orange_creative36_cs_grp, san_orange_creative37_cs_grp, san_orange_creative38_cs_grp, san_orange_creative39_cs_grp, san_orange_creative4_cs_grp, san_orange_creative40_cs_grp, san_orange_creative41_cs_grp, san_orange_creative42_cs_grp, san_orange_creative43_cs_grp, san_orange_creative44_cs_grp, san_orange_creative45_cs_grp, san_orange_creative46_cs_grp, san_orange_creative47_cs_grp, san_orange_creative48_cs_grp, san_orange_creative49_cs_grp, san_orange_creative5_cs_grp, san_orange_creative50_cs_grp, san_orange_creative51_cs_grp, san_orange_creative52_cs_grp, san_orange_creative53_cs_grp, san_orange_creative54_cs_grp, san_orange_creative55_cs_grp, san_orange_creative56_cs_grp, san_orange_creative57_cs_grp, san_orange_creative58_cs_grp, san_orange_creative59_cs_grp, san_orange_creative6_cs_grp, san_orange_creative60_cs_grp, san_orange_creative61_cs_grp, san_orange_creative62_cs_grp, san_orange_creative63_cs_grp, san_orange_creative64_cs_grp, san_orange_creative7_cs_grp, san_orange_creative8_cs_grp, san_orange_creative9_cs_grp, san_others_creative1_cs_grp, san_others_creative2_cs_grp, san_others_creative3_cs_grp, san_others_creative4_cs_grp, san_others_creative5_cs_grp, san_others_creative6_cs_grp, san_white_creative1_cs_grp, san_white_creative2_cs_grp, san_white_creative3_cs_grp, san_white_creative4_cs_grp, san_white_creative5_cs_grp, san_white_creative6_cs_grp, san_orange_30sec_cs_grp, san_orange_15sec_cs_grp, san_orange_10sec_cs_grp, san_orange_5sec_cs_grp, san_orange_45sec_cs_grp, san_orange_20sec_cs_grp, san_white_30sec_cs_grp, san_white_20sec_cs_grp, san_white_15sec_cs_grp, san_white_5sec_cs_grp, san_orange_25sec_cs_grp, san_gly_20sec_cs_grp, san_gly_25sec_cs_grp, san_orange_40sec_cs_grp, san_gly_30sec_cs_grp, san_white_10sec_cs_grp, san_others_40sec_cs_grp, san_others_5sec_cs_grp, san_gly_5sec_cs_grp, san_others_15sec_cs_grp, san_others_35sec_cs_grp, san_gly_10sec_cs_grp, san_gly_15sec_cs_grp, san_white_40sec_cs_grp, san_white_25sec_cs_grp, san_others_20sec_cs_grp, san_orange_35sec_cs_grp, san_others_10sec_cs_grp, san_others_30sec_cs_grp, san_gly_35sec_cs_grp, emami_npt_cs_grp, emami_pt_cs_grp, empty_pt_cs_grp, empty_npt_cs_grp, det_npt_cs_grp, det_pt_cs_grp, lux_pt_cs_grp, lux_npt_cs_grp, lb_pt_cs_grp, lb_npt_cs_grp, dove_npt_cs_grp, vivel_npt_cs_grp, vivel_pt_cs_grp, pears_npt_cs_grp, pears_pt_cs_grp, dove_pt_cs_grp, liril_npt_cs_grp, liril_pt_cs_grp, superia_npt_cs_grp, superia_pt_cs_grp, margo_npt_cs_grp, margo_pt_cs_grp, cin_npt_cs_grp, cin_pt_cs_grp, venus_npt_cs_grp, venus_pt_cs_grp, chand_pt_cs_grp, san_orange_pt_cs_grp, chand_npt_cs_grp, san_orange_npt_cs_grp, fiama_pt_cs_grp, rex_npt_cs_grp, fiama_npt_cs_grp, jb_npt_cs_grp, jb_pt_cs_grp, rex_pt_cs_grp, hamam_npt_cs_grp, hamam_pt_cs_grp, breeze_npt_cs_grp, breeze_pt_cs_grp, gd_npt_cs_grp, gd_pt_cs_grp, nima_pt_cs_grp, mysore_npt_cs_grp, savlon_npt_cs_grp, san_white_pt_cs_grp, savlon_pt_cs_grp, nima_npt_cs_grp, san_white_npt_cs_grp, mysore_pt_cs_grp, med_pt_cs_grp, med_npt_cs_grp, nature_power_npt_cs_grp, nature_power_pt_cs_grp, park_avn_npt_cs_grp, park_avn_pt_cs_grp, moti_npt_cs_grp, moti_pt_cs_grp, san_gly_npt_cs_grp, san_gly_pt_cs_grp, cuticura_pt_cs_grp, cuticura_npt_cs_grp, k_p_nambood_pt_cs_grp, san_others_npt_cs_grp, san_others_pt_cs_grp, k_p_nambood_npt_cs_grp, dyna_pt_cs_grp, dyna_npt_cs_grp, himalaya_neem_npt_cs_grp, himalaya_neem_pt_cs_grp, doy_npt_cs_grp, doy_pt_cs_grp, yardley_eng_laven_npt_cs_grp, yardley_eng_laven_pt_cs_grp, jo_npt_cs_grp, jo_pt_cs_grp, axe_npt_cs_grp, axe_pt_cs_grp, fair_beat_npt_cs_grp, fair_beat_pt_cs_grp, san_gly_national_cs_grp, san_gly_regional_cs_grp, san_orange_national_cs_grp, san_orange_regional_cs_grp, san_others_national_cs_grp, san_others_regional_cs_grp, san_white_national_cs_grp, san_white_regional_cs_grp, cin_vol_tons, cin_val_mns, cin_ms_vol, cin_ms_val, cin_ndist, cin_wtd_val, cin_sah_val, cin_nos, dett_vol_tons, dett_val_mns, dett_ms_vol, dett_ms_val, dett_ndist, dett_wtd_val, dett_sah_val, dett_nos, dove_vol_tons, dove_val_mns, dove_ms_vol, dove_ms_val, dove_ndist, dove_wtd_val, dove_sah_val, dove_nos, gd_vol_tons, gd_val_mns, gd_ms_vol, gd_ms_val, gd_ndist, gd_wtd_val, gd_sah_val, gd_nos, hamam_vol_tons, hamam_val_mns, hamam_ms_vol, hamam_ms_val, hamam_ndist, hamam_wtd_val, hamam_sah_val, hamam_nos, jb_vol_tons, jb_val_mns, jb_ms_vol, jb_ms_val, jb_ndist, jb_wtd_val, jb_sah_val, jb_nos, lb_vol_tons, lb_val_mns, lb_ms_vol, lb_ms_val, lb_ndist, lb_wtd_val, lb_sah_val, lb_nos, liril_vol_tons, liril_val_mns, liril_ms_vol, liril_ms_val, liril_ndist, liril_wtd_val, liril_sah_val, liril_nos, lux_vol_tons, lux_val_mns, lux_ms_vol, lux_ms_val, lux_ndist, lux_wtd_val, lux_sah_val, lux_nos, med_vol_tons, med_val_mns, med_ms_vol, med_ms_val, med_ndist, med_wtd_val, med_sah_val, med_nos, pears_vol_tons, pears_val_mns, pears_ms_vol, pears_ms_val, pears_ndist, pears_wtd_val, pears_sah_val, pears_nos, rex_vol_tons, rex_val_mns, rex_ms_vol, rex_ms_val, rex_ndist, rex_wtd_val, rex_sah_val, rex_nos, san_gly_vol_tons, san_gly_val_mns, san_gly_ms_vol, san_gly_ms_val, san_gly_ndist, san_gly_wtd_val, san_gly_sah_val, san_gly_nos, san_orange_vol_tons, san_orange_val_mns, san_orange_ms_vol, san_orange_ms_val, san_orange_ndist, san_orange_wtd_val, san_orange_sah_val, san_orange_nos, san_other_vol_tons, san_other_val_mns, san_other_ms_vol, san_other_ms_val, san_other_ndist, san_other_wtd_val, san_other_sah_val, san_other_nos, san_others_vol_tons, san_others_val_mns, san_others_ms_vol, san_others_ms_val, san_others_ndist, san_others_wtd_val, san_others_sah_val, san_others_nos, san_total_vol_tons, san_total_val_mns, san_total_ms_vol, san_total_ms_val, san_total_ndist, san_total_wtd_val, san_total_sah_val, san_total_nos, san_white_vol_tons, san_white_val_mns, san_white_ms_vol, san_white_ms_val, san_white_ndist, san_white_wtd_val, san_white_sah_val, san_white_nos, sav_vol_tons, sav_val_mns, sav_ms_vol, sav_ms_val, sav_ndist, sav_wtd_val, sav_sah_val, sav_nos, vivel_vol_tons, vivel_val_mns, vivel_ms_vol, vivel_ms_val, vivel_ndist, vivel_wtd_val, vivel_sah_val, vivel_nos, breeze_creative1_ncs_grp, breeze_creative2_ncs_grp, breeze_creative3_ncs_grp, breeze_creative4_ncs_grp, breeze_creative5_ncs_grp, breeze_creative6_ncs_grp, chand_creative1_ncs_grp, chand_creative2_ncs_grp, chand_creative3_ncs_grp, chand_creative4_ncs_grp, chand_creative5_ncs_grp, chand_creative6_ncs_grp, chand_creative7_ncs_grp, chand_creative8_ncs_grp, chand_creative9_ncs_grp, chand_creative10_ncs_grp, chand_creative11_ncs_grp, chand_creative12_ncs_grp, chand_creative13_ncs_grp, chand_creative14_ncs_grp, chand_creative15_ncs_grp, chand_creative16_ncs_grp, chand_creative17_ncs_grp, chand_creative18_ncs_grp, chand_creative19_ncs_grp, chand_creative20_ncs_grp, chand_creative21_ncs_grp, chand_creative22_ncs_grp, chand_creative23_ncs_grp, chand_creative24_ncs_grp, chand_creative25_ncs_grp, chand_creative26_ncs_grp, chand_creative27_ncs_grp, chand_creative28_ncs_grp, chand_creative29_ncs_grp, chand_creative30_ncs_grp, chand_creative31_ncs_grp, chand_creative32_ncs_grp, chand_creative33_ncs_grp, cin_creative1_ncs_grp, cin_creative2_ncs_grp, cin_creative3_ncs_grp, cin_creative4_ncs_grp, cin_creative5_ncs_grp, cin_creative6_ncs_grp, cin_creative7_ncs_grp, cin_creative8_ncs_grp, cin_creative9_ncs_grp, cin_creative10_ncs_grp, cin_creative11_ncs_grp, cin_creative12_ncs_grp, cin_creative13_ncs_grp, cin_creative14_ncs_grp, cin_creative15_ncs_grp, cin_creative16_ncs_grp, cin_creative17_ncs_grp, cin_creative18_ncs_grp, cin_creative19_ncs_grp, cin_creative20_ncs_grp, cin_creative21_ncs_grp, cin_creative22_ncs_grp, cin_creative23_ncs_grp, cin_creative24_ncs_grp, cin_creative25_ncs_grp, cin_creative26_ncs_grp, cin_creative27_ncs_grp, det_creative1_ncs_grp, det_creative2_ncs_grp, det_creative3_ncs_grp, det_creative4_ncs_grp, det_creative5_ncs_grp, det_creative6_ncs_grp, det_creative7_ncs_grp, det_creative8_ncs_grp, det_creative9_ncs_grp, det_creative10_ncs_grp, det_creative11_ncs_grp, det_creative12_ncs_grp, det_creative13_ncs_grp, det_creative14_ncs_grp, det_creative15_ncs_grp, det_creative16_ncs_grp, det_creative17_ncs_grp, det_creative18_ncs_grp, det_creative19_ncs_grp, det_creative20_ncs_grp, det_creative21_ncs_grp, det_creative22_ncs_grp, det_creative23_ncs_grp, det_creative24_ncs_grp, det_creative25_ncs_grp, det_creative26_ncs_grp, det_creative27_ncs_grp, det_creative28_ncs_grp, det_creative29_ncs_grp, det_creative30_ncs_grp, det_creative31_ncs_grp, det_creative32_ncs_grp, det_creative33_ncs_grp, det_creative34_ncs_grp, det_creative35_ncs_grp, det_creative36_ncs_grp, det_creative37_ncs_grp, det_creative38_ncs_grp, det_creative39_ncs_grp, det_creative40_ncs_grp, det_creative41_ncs_grp, det_creative42_ncs_grp, det_creative43_ncs_grp, det_creative44_ncs_grp, det_creative45_ncs_grp, det_creative46_ncs_grp, det_creative47_ncs_grp, det_creative48_ncs_grp, det_creative49_ncs_grp, det_creative50_ncs_grp, det_creative51_ncs_grp, det_creative52_ncs_grp, dove_creative1_ncs_grp, dove_creative2_ncs_grp, dove_creative3_ncs_grp, dove_creative4_ncs_grp, dove_creative5_ncs_grp, dove_creative6_ncs_grp, dove_creative7_ncs_grp, dove_creative8_ncs_grp, dove_creative9_ncs_grp, dove_creative10_ncs_grp, dove_creative11_ncs_grp, dove_creative12_ncs_grp, dove_creative13_ncs_grp, dove_creative14_ncs_grp, dove_creative15_ncs_grp, dove_creative16_ncs_grp, dove_creative17_ncs_grp, dove_creative18_ncs_grp, dove_creative19_ncs_grp, dove_creative20_ncs_grp, dove_creative21_ncs_grp, dove_creative22_ncs_grp, dove_creative23_ncs_grp, dove_creative24_ncs_grp, dove_creative25_ncs_grp, dove_creative26_ncs_grp, dove_creative27_ncs_grp, dove_creative28_ncs_grp, dove_creative29_ncs_grp, dove_creative30_ncs_grp, dove_creative31_ncs_grp, dove_creative32_ncs_grp, dove_creative33_ncs_grp, dove_creative34_ncs_grp, gd_creative1_ncs_grp, gd_creative2_ncs_grp, gd_creative3_ncs_grp, gd_creative4_ncs_grp, gd_creative5_ncs_grp, gd_creative6_ncs_grp, gd_creative7_ncs_grp, gd_creative8_ncs_grp, gd_creative9_ncs_grp, gd_creative10_ncs_grp, gd_creative11_ncs_grp, gd_creative12_ncs_grp, gd_creative13_ncs_grp, gd_creative14_ncs_grp, gd_creative15_ncs_grp, gd_creative16_ncs_grp, gd_creative17_ncs_grp, gd_creative18_ncs_grp, gd_creative19_ncs_grp, hamam_creative1_ncs_grp, hamam_creative2_ncs_grp, hamam_creative3_ncs_grp, hamam_creative4_ncs_grp, hamam_creative5_ncs_grp, hamam_creative6_ncs_grp, hamam_creative7_ncs_grp, hamam_creative8_ncs_grp, hamam_creative9_ncs_grp, hamam_creative10_ncs_grp, hamam_creative11_ncs_grp, hamam_creative12_ncs_grp, hamam_creative13_ncs_grp, hamam_creative14_ncs_grp, hamam_creative15_ncs_grp, hamam_creative16_ncs_grp, hamam_creative17_ncs_grp, hamam_creative18_ncs_grp, lb_creative1_ncs_grp, lb_creative2_ncs_grp, lb_creative3_ncs_grp, lb_creative4_ncs_grp, lb_creative5_ncs_grp, lb_creative6_ncs_grp, lb_creative7_ncs_grp, lb_creative8_ncs_grp, lb_creative9_ncs_grp, lb_creative10_ncs_grp, lb_creative11_ncs_grp, lb_creative12_ncs_grp, lb_creative13_ncs_grp, lb_creative14_ncs_grp, lb_creative15_ncs_grp, lb_creative16_ncs_grp, lb_creative17_ncs_grp, lb_creative18_ncs_grp, lb_creative19_ncs_grp, lb_creative20_ncs_grp, lb_creative21_ncs_grp, lb_creative22_ncs_grp, lb_creative23_ncs_grp, lb_creative24_ncs_grp, lb_creative25_ncs_grp, lb_creative26_ncs_grp, lb_creative27_ncs_grp, lb_creative28_ncs_grp, lb_creative29_ncs_grp, lb_creative30_ncs_grp, lb_creative31_ncs_grp, lb_creative32_ncs_grp, lb_creative33_ncs_grp, lb_creative34_ncs_grp, lb_creative35_ncs_grp, lb_creative36_ncs_grp, lb_creative37_ncs_grp, lb_creative38_ncs_grp, lb_creative39_ncs_grp, lb_creative40_ncs_grp, lb_creative41_ncs_grp, med_creative1_ncs_grp, med_creative2_ncs_grp, med_creative3_ncs_grp, med_creative4_ncs_grp, med_creative5_ncs_grp, med_creative6_ncs_grp, med_creative7_ncs_grp, med_creative8_ncs_grp, med_creative9_ncs_grp, med_creative10_ncs_grp, med_creative11_ncs_grp, med_creative12_ncs_grp, med_creative13_ncs_grp, med_creative14_ncs_grp, med_creative15_ncs_grp, med_creative16_ncs_grp, med_creative17_ncs_grp, med_creative18_ncs_grp, med_creative19_ncs_grp, med_creative20_ncs_grp, med_creative21_ncs_grp, san_gly_creative1_ncs_grp, san_gly_creative2_ncs_grp, san_gly_creative3_ncs_grp, san_gly_creative4_ncs_grp, san_gly_creative5_ncs_grp, san_gly_creative6_ncs_grp, san_gly_creative7_ncs_grp, san_gly_creative8_ncs_grp, san_gly_creative9_ncs_grp, san_gly_creative10_ncs_grp, san_gly_creative11_ncs_grp, san_gly_creative12_ncs_grp, san_gly_creative13_ncs_grp, san_gly_creative14_ncs_grp, san_gly_creative15_ncs_grp, san_gly_creative16_ncs_grp, san_gly_creative17_ncs_grp, san_gly_creative18_ncs_grp, san_gly_creative19_ncs_grp, san_gly_creative20_ncs_grp, san_gly_creative21_ncs_grp, san_gly_creative22_ncs_grp, san_gly_creative23_ncs_grp, san_orange_creative1_ncs_grp, san_orange_creative2_ncs_grp, san_orange_creative3_ncs_grp, san_orange_creative4_ncs_grp, san_orange_creative5_ncs_grp, san_orange_creative6_ncs_grp, san_orange_creative7_ncs_grp, san_orange_creative8_ncs_grp, san_orange_creative9_ncs_grp, san_orange_creative10_ncs_grp, san_orange_creative11_ncs_grp, san_orange_creative12_ncs_grp, san_orange_creative13_ncs_grp, san_orange_creative14_ncs_grp, san_orange_creative15_ncs_grp, san_orange_creative16_ncs_grp, san_orange_creative17_ncs_grp, san_orange_creative18_ncs_grp, san_orange_creative19_ncs_grp, san_orange_creative20_ncs_grp, san_orange_creative21_ncs_grp, san_orange_creative22_ncs_grp, san_orange_creative23_ncs_grp, san_orange_creative24_ncs_grp, san_orange_creative25_ncs_grp, san_orange_creative26_ncs_grp, san_orange_creative27_ncs_grp, san_orange_creative28_ncs_grp, san_orange_creative29_ncs_grp, san_orange_creative30_ncs_grp, san_orange_creative31_ncs_grp, san_orange_creative32_ncs_grp, san_orange_creative33_ncs_grp, san_orange_creative34_ncs_grp, san_orange_creative35_ncs_grp, san_orange_creative36_ncs_grp, san_orange_creative37_ncs_grp, san_orange_creative38_ncs_grp, san_orange_creative39_ncs_grp, san_orange_creative40_ncs_grp, san_orange_creative41_ncs_grp, san_orange_creative42_ncs_grp, san_orange_creative43_ncs_grp, san_orange_creative44_ncs_grp, san_orange_creative45_ncs_grp, san_orange_creative46_ncs_grp, san_orange_creative47_ncs_grp, san_orange_creative48_ncs_grp, san_orange_creative49_ncs_grp, san_orange_creative50_ncs_grp, san_orange_creative51_ncs_grp, san_orange_creative52_ncs_grp, san_orange_creative53_ncs_grp, san_orange_creative54_ncs_grp, san_orange_creative55_ncs_grp, san_orange_creative56_ncs_grp, san_orange_creative57_ncs_grp, san_orange_creative58_ncs_grp, san_orange_creative59_ncs_grp, san_orange_creative60_ncs_grp, san_orange_creative61_ncs_grp, san_orange_creative62_ncs_grp, san_orange_creative63_ncs_grp, san_orange_creative64_ncs_grp, san_orange_creative65_ncs_grp, san_orange_creative66_ncs_grp, san_orange_creative67_ncs_grp, san_orange_creative68_ncs_grp, san_orange_creative69_ncs_grp, san_orange_creative70_ncs_grp, san_orange_creative71_ncs_grp, san_orange_creative72_ncs_grp, san_orange_creative73_ncs_grp, san_orange_creative74_ncs_grp, san_others_creative1_ncs_grp, san_others_creative2_ncs_grp, san_others_creative3_ncs_grp, san_others_creative4_ncs_grp, san_others_creative5_ncs_grp, san_others_creative6_ncs_grp, san_white_creative1_ncs_grp, san_white_creative2_ncs_grp, san_white_creative3_ncs_grp, san_white_creative4_ncs_grp, san_white_creative5_ncs_grp, san_white_creative6_ncs_grp, vivel_creative1_ncs_grp, vivel_creative2_ncs_grp, vivel_creative3_ncs_grp, vivel_creative4_ncs_grp, vivel_creative5_ncs_grp, vivel_creative6_ncs_grp, vivel_creative7_ncs_grp, san_others_genre13_ncs_grp, san_others_genre14_ncs_grp, san_others_genre15_ncs_grp, san_others_genre16_ncs_grp, san_others_genre17_ncs_grp, san_others_genre18_ncs_grp, san_others_genre19_ncs_grp, san_others_genre20_ncs_grp, san_others_genre21_ncs_grp, san_others_genre22_ncs_grp, san_others_genre23_ncs_grp, san_others_genre24_ncs_grp, san_others_genre25_ncs_grp, san_others_genre26_ncs_grp, san_others_genre27_ncs_grp, san_others_genre28_ncs_grp, san_others_genre29_ncs_grp, san_others_genre30_ncs_grp, san_others_genre31_ncs_grp, san_others_genre32_ncs_grp, san_others_genre33_ncs_grp, san_others_genre34_ncs_grp, san_others_genre35_ncs_grp, san_others_genre36_ncs_grp, san_white_genre1_ncs_grp, san_white_genre2_ncs_grp, san_white_genre3_ncs_grp, san_white_genre4_ncs_grp, san_white_genre5_ncs_grp, san_white_genre6_ncs_grp, san_white_genre7_ncs_grp, san_white_genre8_ncs_grp, san_white_genre9_ncs_grp, san_white_genre10_ncs_grp, san_white_genre11_ncs_grp, san_white_genre12_ncs_grp, san_white_genre13_ncs_grp, san_white_genre14_ncs_grp, san_white_genre15_ncs_grp, san_white_genre16_ncs_grp, san_white_genre17_ncs_grp, san_white_genre18_ncs_grp, san_white_genre19_ncs_grp, san_white_genre20_ncs_grp, san_white_genre21_ncs_grp, san_white_genre22_ncs_grp, san_white_genre23_ncs_grp, san_white_genre24_ncs_grp, san_white_genre25_ncs_grp, san_white_genre26_ncs_grp, san_white_genre27_ncs_grp, san_white_genre28_ncs_grp, san_white_genre29_ncs_grp, san_white_genre30_ncs_grp, san_white_genre31_ncs_grp, san_white_genre32_ncs_grp, san_white_genre33_ncs_grp, san_white_genre34_ncs_grp, san_white_genre35_ncs_grp, san_white_genre36_ncs_grp, san_white_genre37_ncs_grp, san_white_genre38_ncs_grp, san_white_genre39_ncs_grp, san_white_genre40_ncs_grp, jb_ncs_grp, breeze_ncs_grp, lux_ncs_grp, lb_ncs_grp, rex_ncs_grp, det_ncs_grp, san_orange_ncs_grp, superia_ncs_grp, pears_ncs_grp, chand_ncs_grp, vivel_ncs_grp, venus_ncs_grp, dove_ncs_grp, san_white_ncs_grp, savlon_ncs_grp, mysore_ncs_grp, gd_ncs_grp, nima_ncs_grp, liril_ncs_grp, san_gly_ncs_grp, moti_ncs_grp, san_others_ncs_grp, dyna_ncs_grp, cin_ncs_grp, hamam_ncs_grp, himalaya_neem_ncs_grp, med_ncs_grp, margo_ncs_grp, jb_regional_ncs_grp, breeze_regional_ncs_grp, lux_regional_ncs_grp, lb_regional_ncs_grp, rex_regional_ncs_grp, lb_national_ncs_grp, lux_national_ncs_grp, breeze_national_ncs_grp, det_national_ncs_grp, jb_national_ncs_grp, san_orange_national_ncs_grp, superia_regional_ncs_grp, pears_regional_ncs_grp, san_orange_regional_ncs_grp, chand_regional_ncs_grp, vivel_regional_ncs_grp, venus_national_ncs_grp, dove_regional_ncs_grp, san_white_regional_ncs_grp, venus_regional_ncs_grp, dove_national_ncs_grp, pears_national_ncs_grp, savlon_national_ncs_grp, savlon_regional_ncs_grp, mysore_regional_ncs_grp, gd_regional_ncs_grp, nima_national_ncs_grp, liril_national_ncs_grp, empty_regional_ncs_grp, liril_regional_ncs_grp, superia_national_ncs_grp, gd_national_ncs_grp, margo_national_ncs_grp, vivel_national_ncs_grp, margo_regional_ncs_grp, san_gly_regional_ncs_grp, moti_regional_ncs_grp, san_others_regional_ncs_grp, san_gly_national_ncs_grp, dyna_regional_ncs_grp, dyna_national_ncs_grp, nima_regional_ncs_grp, san_white_national_ncs_grp, cin_regional_ncs_grp, hamam_regional_ncs_grp, rex_national_ncs_grp, himalaya_neem_regional_ncs_grp, med_regional_ncs_grp, hamam_national_ncs_grp, det_regional_ncs_grp, moti_national_ncs_grp, mysore_national_ncs_grp, jb_npt_ncs_grp, breeze_npt_ncs_grp, jb_pt_ncs_grp, lux_pt_ncs_grp, breeze_pt_ncs_grp, breeze_promo_ncs_grp markets_and_neilsenregandmaster , main_ncs b a.period = b.period , a.market = b.market grouping period; error 1117 (hy0000): many columns this exact error got. in advance :-)
why making every market column ? should have column called markets , set there markets names instead of making them columns.
make markets in 1 column , brands in other column . , have 2 easy columns :)
so if add together other market , add together other column ? improve add together value in markets column.
read maximum number of columns
mysql join mysql-workbench mysqldump
No comments:
Post a Comment