摘要:
select/update where id in(上万个元素)的优化方案: 优化前: selectselect docId from tab1 where word in (select word from tab1 where docId=123) group by docId limit 10 阅读全文
摘要:
mysql 用户授权: 1.创建用户:create user 'user1'@'100.%' identified by 'pwd' //创建用户并无权限 2.授权:grant all privileges on *.* TO 'user1'@'100.%' with grant option; / 阅读全文