insert into table_3(number_1,number_2) ( select table_1.number ,table_2.number from table_1,table_2);
update table_3 set data_time='2012-08-09' where id > 0;
注意inser into 后面只能接一条select 语句,其它的可以用update 更新一下。
insert into table_3(number_1,number_2) ( select table_1.number ,table_2.number from table_1,table_2);
update table_3 set data_time='2012-08-09' where id > 0;