mysql事务-2020-11-21

use test
查询事务隔离级别：
select @@tx_isolation;

设置事务隔离级别：
//全局的
set global transaction isolation level read committed;
//当前会话
set session transaction isolation level read committed;

SET SESSION TRANSACTION ISOLATION LEVEL read uncommitted;
SET SESSION TRANSACTION ISOLATION LEVEL read committed;
SET SESSION TRANSACTION ISOLATION LEVEL repeatable read;
SET SESSION TRANSACTION ISOLATION LEVEL serializable;

查询数据库：
show databases;
查询表：
show tables;
查询建表语句：
show create table xxx;
查询列信息：
show columns from xxx;