MySQL - INSERT 集合

范例1：

INSERT INTO t_table SELECT ot.* FROM t_other_table ot WHERE ot.is_sent = ? and ot.insert_time <= ?

 

 

范例2：

INSERT INTO t_dict_province(code, name) SELECT p.id, p.name FROM t_dict_provinces p where p.id = ?