update tb set myno=myno+(select sum(myno) from ta where mydate='11-11-2004'),
score1=100,
score2=100,
score3=100
where mydate='11-11-2004';
具体的时间格式你注意一下,意思应该是这样
score1=100,
score2=100,
score3=100
where mydate='11-11-2004';
具体的时间格式你注意一下,意思应该是这样
insert into TB(MYDATE,MYNO,SCORE1,SCORE2,SCORE1) select MYDATE,MYNO,100,100,100 from TA where MYDATE=to_date('11-11月-2004')mydate字符型:
insert into TB(MYDATE,MYNO,SCORE1,SCORE2,SCORE1) select MYDATE,MYNO,100,100,100 from TA where MYDATE='11-11月-2004'
where MYDATE=to_date('2004-11-11','yyyy-mm-dd')