iteye_11197的博客

mysql隔离级别转自[url]http://www.cnblogs.com/zemliu/archive/2012/06/17/2552301.html[/url]这篇文章，貌似说update时，用到了共享锁(因为能select)，其实从官网文档来看是不正确。update用的是排它锁，而select时，没用到锁。...

1、查看函数[code="java"]show function status;[/code]2、查看用户权限[code="java"]show grants for username@'%';[/code]3、导出表数据--导出部分表数据[code="java"]mysqldump -h ip -uroot -p table1,table2 > d:/syst...

sql server row number分页：[code="java"] select b.* FROM ( select row_number() over(order by t.id desc) as rownumber, t.* from table_name t ) as b where b.rownumber <= #endIndex# and b...

转自[url]http://www.cnblogs.com/xiaoluo501395377/archive/2013/04/07/3003278.html[/url]

[b]1、创建用户[/b]可以在任何地方登陆[code="java"]CREATE USER test IDENTIFIED BY 'test123';[/code]或[code="java"]CREATE USER 'test'@'%' IDENTIFIED BY 'test123';[/code]在本地登陆[code="java"]CREATE USER 'te...

msql-proxy实现：[url]http://blog.youkuaiyun.com/justdb/article/details/17331569[/url]amoeba实现：[url]https://www.centos.bz/2012/05/amoeba-for-mysql/[/url]