MySQL插入一列数据

insert into order(要插入列名) select 要插入列名 from xxx列名位置要一一对应例：insert into t_competitive_order (candidate_id) select candidate_id from t_competitive;