楼主难道是这样的意思??insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye) (select lxr,khdw_bm,khdw,yearmonth,qcye from cw_ysz where yearmonth='200502' Union All SELECT lxr,khdw_bm,khdw,yearmonth,qmye FROM cw_ysz where yearmonth='200501')
呵呵 如果楼主确实没有笔误的话那就试试这样,还发两个贴 insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye) (select lxr,khdw_bm,khdw,yearmonth,qcye from cw_ysz where yearmonth='200502') union all (SELECT lxr,khdw_bm,khdw,yearmonth,qmye FROM cw_ysz where yearmonth='200501')
select lxr,khdw_bm,khdw,yearmonth,qcye from cw_ysz where yearmonth='200502'这个数据已经存在是吧。那就直接Update一下就可以啊。
非常感谢了,但是我对sql语句总是糊里糊涂的,提示我数据重复,不能写入!可以写一个完整的吗?
Update A Set qcye=(Select qmye from cw_ysz Where khdw_bm=A.khdw_bm and lxr=A.lxr and khdw=A.khdw And yearmonth='200501') from cw_ysz A Where yearmonth='200502'
那我觉得应该这么写, insert into insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye) (SELECT lxr,khdw_bm,khdw,'200502',qmye FROM cw_ysz where yearmonth='200501')
insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye) (select lxr,khdw_bm,khdw,'200505',qmye from cw_ysz where yearmonth='200504') 我也试出来了,感谢两位!
我晕了,还是楼主自己说吧,yearmonth为'200502'的数据存不存在。不存在,用水手的。不过要改下,水手的有BUG。insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye) (SELECT lxr,khdw_bm,khdw,'200502',qmye FROM cw_ysz where yearmonth='200501')存在的话,用我的。
晕insert into复制多了 insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye) (SELECT lxr,khdw_bm,khdw,'200502',qmye FROM cw_ysz where yearmonth='200501')
(select lxr,khdw_bm,khdw,yearmonth,qcye from cw_ysz where yearmonth='200502'
Union All
SELECT lxr,khdw_bm,khdw,yearmonth,qmye FROM cw_ysz where yearmonth='200501')
insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye)
(select lxr,khdw_bm,khdw,yearmonth,qcye from cw_ysz where yearmonth='200502')
union all
(SELECT lxr,khdw_bm,khdw,yearmonth,qmye FROM cw_ysz where yearmonth='200501')
Update A Set qcye=(Select qmye from cw_ysz Where khdw_bm=A.khdw_bm and lxr=A.lxr and khdw=A.khdw And yearmonth='200501')
from cw_ysz A Where yearmonth='200502'
insert into insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye)
(SELECT lxr,khdw_bm,khdw,'200502',qmye FROM cw_ysz where yearmonth='200501')
应该是插入一条新的记录
(select lxr,khdw_bm,khdw,'200505',qmye from cw_ysz where yearmonth='200504')
我也试出来了,感谢两位!
(SELECT lxr,khdw_bm,khdw,'200502',qmye FROM cw_ysz where yearmonth='200501')存在的话,用我的。
insert into cw_ysz(lxr,khdw_bm,khdw,yearmonth,qcye)
(SELECT lxr,khdw_bm,khdw,'200502',qmye FROM cw_ysz where yearmonth='200501')