mysql数据记录插入
首先由二张表 t_a(b,c,d),t_his_a (day,b,c,d)
我们需要从t_a中查询出b,c,d字段,插入到t_his_a并且t_his_a有day
/*先删除表中数据可以根据实际情况*/
delete from t_his_a;
insert into t_his_a(
day,
b,
c,
d)
select
"20150102" as day,
a.b,
a.c,
a.d from t_a a;
我们需要从t_a中查询出b,c,d字段,插入到t_his_a并且t_his_a有day
/*先删除表中数据可以根据实际情况*/
delete from t_his_a;
insert into t_his_a(
day,
b,
c,
d)
select
"20150102" as day,
a.b,
a.c,
a.d from t_a a;