还是没有成功,是不是差后边的where那里,写成 insert into 3(date) select date from 2007.12 where 2008.3.3_bianhao=2007.12.12_bianhao这样提示unknown column'2008.3.3_bianhao' in 'where clause'
我改变了一下,也达到目的了就是用CREATE TABLE new2007.12 SELECT * FROM 2007.12 然后再用update 2008.3 set 2008.3.3_data where 2008.3.3_bianhao=2007.12.3_bianhao 就是有点笨
insert into 3(date) select date from 2007.12 where 2008.3.3_bianhao=2007.12.12_bianhao这样提示unknown column'2008.3.3_bianhao' in 'where clause'
然后再用update 2008.3 set 2008.3.3_data where 2008.3.3_bianhao=2007.12.3_bianhao 就是有点笨