数据库-Mysql-SQL

1. alter table person modify id int auto_increment ;

1.1 select max(id) from person ;
2. alter table person auto_increment=2 ;  #重新设置自动增长基数

  事务

3. select @@tx_isolation ;#查看事务隔离级别

4. set transaction isolation level read uncommitted / read committed / repeatable read/ serializable

 

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

7.mysql备份与还原

（1）--mysqldump

....