MySQL 的一些语句

select @@tx_isolation
set transaction isolation level read uncommitted
                                read committed
                                repeatable read
                                serializable;

start transaction;

commit|rollback;

FOUND_ROWS() : select ，使用UI工具总是返回1，直接在mysql上的命令行好象又可以；
select ROW_COUNT() :update,insert,delete

---------------------------------------

查看mysql当前连接数
C:\Documents and Settings\Administrator>mysqladmin -uroot -pok -P3307 processlist