Mysqlロックの表示

#         
select * from information_schema.innodb_trx;  

#      
select * from information_schema.innodb_locks; 

#        
select * from information_schema.innodb_lock_waits 

#    autocommit  
select @@autocommit;


1813
#           ：
select @@tx_isolation;

#            ：
show full processlist;

# kill   
kill 1825;


#            
SELECT * FROM information_schema.tables WHERE table_schema='test1' AND table_name='rpt_test' ;

#       
mysqldump -u root -p --databases wxss  > C:\Users\Administrator\Desktop\sql\wxss_database.sql