虽然已经有很多类似的写法,我这里还是自己写一写,有些分隔符分出的列数是不固定的,这时候怎么根据分隔符拆分出多列呢
insert into tpems.sp_questions_bank (id, title, option_a, option_b, option_c, option_d, option_e, answer1, answer2, parse, qtpye, diff, md5, subjectId, gradeId, knowledges, area, year, paperTpye, source, fromSite, isSub, isNormal, isKonw, tiid, Similarity, isunique, md52, s_type, s_qid, s_pid, s_user_id, s_user_name, s_option_number, s_status, s_create_time, s_last_update_time, s_is_exercise, s_select_number
)
SELECT
null,
t.title,
IF(t.opi >= 1, t.option_a, \) a,
IF(t.opi >= 2, t.option_b, \) b,
IF(t.opi >= 3, t.option_c, \) c,
IF(t.opi >= 4, t.option_d, \) d,
IF(t.opi >= 5, t.option_e, \) e,
t.answer,
null,
t.description,
t.type,
null,
null,
nu