chenxuedong

## failed：× ； pass：✓ ## 1. rollback test [×] ### case： ``` create table psn(id int primary key, name varchar(10)) engine=TIANMU; insert into psn values(1,'zhangsan'); insert into psn values(2,'lisi'); insert...

## 2. autocommit test [×] ### case: ``` set autocommit = 0; set session transaction isolation level read committed; update psn set name ='jjj' where id = 2; select *...

## 3. subquery test [✓] ### case: ``` CREATE TABLE `teachers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `age` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=TIANMU...

## 4. unique index [×] ### case: ``` CREATE TABLE `d` ( `id` int(11) NOT NULL, `name` varchar(255) DEFAULT NULL, `class` varchar(255) DEFAULT NULL, `count` int(11) DEFAULT NULL, `date` date...

## 5. primary key auto_increment [✓] ### case : ``` CREATE TABLE study( ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT , NAME VARCHAR(20) NOT NULL, AGE INT(10) )ENGINE=TIANMU; INSERT INTO...

## 6. ADD COLUMN [×] ### case: ``` CREATE TABLE Students( id INT PRIMARY KEY auto_increment, name VARCHAR(20), Teacher_id TINYINT, key (Teacher_id) )engine=TIANMU; ALTER TABLE Students ADD COLUMN school_score int(20)...

## 7.union all [✓] ### case: ``` CREATE TABLE Students( id INT PRIMARY KEY auto_increment, name VARCHAR(20), Teacher_id TINYINT, key (Teacher_id) )engine=TIANMU; iNSERT INTO Students (name,Teacher_id) VALUES ("ViewIn1",1); CREATE TABLE...

## 8. inner join、right join、left join [✓] ### case: ``` create table Student3(Sid varchar(6), Sname varchar(10), Sage datetime, Ssex varchar(10)) engine=TIANMU; insert into Student3 values('01' , '赵雷' , '1990-01-01' ,...

## 9. txt load file [✓] ### case: ``` cxdtest.txt: 1 abc 123 2 def 456 3 ghi 789 4 jkl 101 5 mno 112 create table cxd1(id int, name...

## 10.csv load file [✓] ### case: ``` 10.csv: 1 abc 123 2 def 456 3 ghi 789 4 jkl 101 5 mno 112 create table cxd1(id int, name varchar(10),...