摘要:
select nvl(t1.xfc,0) as hj,substr(t.today,6,5) as rq from (select to_char (sysdate-level + 1,'yyyy-mm-dd') today from dual connect by level <=7 ) t,(s 阅读全文
摘要:
多表修改: update t_user u inner join t_student s on s.u_id=u.id set u.password='zhangsan1243',s.teacher='hehe' where u.card='zhangsan123'; 多表删除: delete u, 阅读全文