updatesql.txt

来自「jsp+servlet+javabean实现完整新闻发布系统」· 文本 代码 · 共 12 行

update newsusr set purview=1;
update news set kindId=kindId+2;
update news set kindId=2 where kindId=17;
update news set kindId=1 where kindId=16;
update news set tag=1 where tag=0;
update news set tag=0 where tag=1;
update newscommon set counter=2061;

create database ntsky;
create database nt;
drop database nt;
drop database ntsky;