常用的sql语句 古城微笑少年丶 2022-06-10 05:58 231阅读 0赞 把Chanpin1表里面的数据导入Chanpin里面 INSERT INTO \[t\].\[dbo\].\[Chanpin\](\[shengfen\] ,\[s\_name\],\[product\_name\],\[product\_sb\],\[ton\],\[zsbh\],\[date\]) select \[F2\],\[F3\],\[F4\],\[F5\],\[F6\],\[F7\],\[F8\] from Chanpin1 下面是sql语句的批处理更新操作: update product1\_26bak2\_12 setproduct1\_26bak2\_12.company=companybak2\_10.name from companybak2\_10 where product1\_26bak2\_12.comid=companybak2\_10.id update a set namecn=b.namecn,nameen=b.nameen from chemDictionary a,chemDictionary\_5\_1b wherea.cas=b.casand a.id<601641 下面是sql语句的批量删除操作,就是这时候的id不要用=号而用in来进行操作 delete from product1\_26where idin(select idfromproduct1\_26) delete from productbak2\_14testwhere id notin (selectmin(id) from productbak2\_14test group by namecn,company) 如果是跨库操作的话 select \* intochemcndata.dbo.admin\_group1 from admin\_group 下面一行的作用是创建于Pollu\_freeProduct表结构相同的Pollu\_freeProduct1表,然后把Pollu\_freeProduct表中的不相同的数据放入Pollu\_freeProduct1中,太强大了 select distinct\*into Pollu\_freeProduct1fromPollu\_freeProduct UPDATE HomelyRecipe SET food\_res=replace(food\_res,'&\#8226;','') REPLACE(<string\_expression1>,<string\_expression2>,<string\_expression3>) 用string\_expression3 替换在string\_expression1中的子串string\_expression2。 简单的创建存储过程: create procedure proc\_company as declare @avg float select @avg = avg(validate) from company print '平均:'+convert(varchar(5),@avg) go 执行存储过程: exec proc\_company 创建触发器: create trigger cfq on company for update as begin insert into company(name)values('触发器插入') end select id,vip,email from ( select c.id,c.vip,c.email,c.name,a.createtime as acreatetime,a.validate as avalidate,a.id as aid from company c,auditedSupplier a where c.id=a.comid ) as t [正序反序正序的分页存储方法][Link 1] select top 5 \* from table where id in (select top 5 id from table where id in (select top 10 idfrom table order by id ) order by id desc) order by id 好了,到这里,我们的第六条到第十条,也就是第二页的内容就算是取出来了 ## Mysql 多个join 语句的写法 ## ELECT view\_kwarg\_temp.kwarg\_id, course\_name, class\_name, teacher\_name, classroom\_name, jkjsA, jkjsB FROM view\_kwarg\_temp LEFT JOIN jkjsA ON view\_kwarg\_temp.kwarg\_id = jkjsA.kwarg\_id LEFT JOIN jkjsB ON view\_kwarg\_temp.kwarg\_id = jkjsB.kwarg\_id [Link 1]: http://blog.csdn.net/wxwzy738/article/details/7710193
还没有评论,来说两句吧...