sql mysql oracle语句实现
qq_19396231
去去去去去去去去去去去去去
展开
-
mysql对数据库多个字段同时进行模糊查询
mysql对数据库多个字段同时进行模糊查询select CONCAT_WS(',',loginname,real_name,null ) from user_fore where CONCAT(loginname,real_name) like '%1%' 参考网址 http://jingyan.baidu.com/article/11c17a2c6da078f446e39daa...原创 2015-08-10 15:36:40 · 5554 阅读 · 1 评论 -
sql :符合某一条件时执行update
update configset role = 'abc' where id = '2' and (select 1 from ( select 1 from config where role='abc' having count(1)<3 ) t ) 更新config表中id=2的role为abc 前提条...原创 2016-08-03 08:57:59 · 1451 阅读 · 0 评论