mysql> set global transaction isolation level read committed;
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
±---------------+
| Tables_in_liu |
±---------------+
| data_vendor |
| employee |
| ju |
| org |
| orga |
| t_class |
| t_organization |
| t_student |
| t_teacher |
| t_user |
±---------------+
10 rows in set (0.00 sec)
mysql> desc t_student;
±--------±------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±--------±------------±-----±----±--------±------+
| sno | int(3) | NO | PRI | NULL | |
| sname | varchar(32) | NO | | NULL | |
| classno | int(3) | YES | MUL | NULL | |
±--------±------------±-----±----±--------±------+
3 rows in set (0.01 sec)
mysql> insert into t_student(sno,sname) values(12,