■Sample701
SELECT * FROM student;

■Sample702
START TRANSACTION;

■Sample703
DELETE FROM student WHERE grade = 1;

■Sample704
SELECT * FROM student;

■Sample705
DELETE FROM student WHERE id >= 3000;

■Sample706
SELECT * FROM student;

■Sample707
DELETE FROM student;

■Sample708
SELECT * FROM student;

■Sample709
ROLLBACK;

■Sample710
SELECT * FROM student;

■Sample711
SELECT * FROM student;

■Sample712
START TRANSACTION;

■Sample713
UPDATE student SET name = '山口太郎' WHERE id = 1001;

■Sample714
SELECT * FROM student;

■Sample715
UPDATE student SET name = '学生', grade = 0;

■Sample716
SELECT * FROM student;

■Sample717
ROLLBACK;

■Sample718
SELECT * FROM student;

■Sample719
SELECT * FROM sp_sample;

■Sample720
START TRANSACTION;

■Sample721
# データを追加する
INSERT INTO sp_sample (name, age) VALUES ('伊藤紀子', 32);

# セーブポイントSPを追加する
SAVEPOINT SP;

# データを追加する
INSERT INTO sp_sample (name, age) VALUES ('三島修一', 32);

■Sample722
SELECT * FROM sp_sample;

■Sample723
ROLLBACK TO SAVEPOINT SP;

■Sample724
SELECT * FROM sp_sample;

■Sample725
ROLLBACK;

■Sample726
SELECT * FROM sp_sample;

■Sample727
SHOW TABLES;

■Sample728
SELECT * FROM student;

■Sample729
SHOW COLUMNS FROM student;

■Sample730
ALTER TABLE student RENAME TO student_list;

■Sample731
SHOW TABLES;

■Sample732
SHOW COLUMNS FROM student_list;

■Sample733
SELECT * FROM student_list;

■Sample734
ALTER TABLE student_list ADD address varchar(20);

■Sample735
SHOW COLUMNS FROM student_list;

■Sample736
SELECT * FROM student_list;

■Sample737
ALTER TABLE student_list ADD age int FIRST;

■Sample738
SHOW COLUMNS FROM student_list;

■Sample739
SELECT * FROM student_list;

■Sample740
ALTER TABLE student_list ADD sex VARCHAR(2) AFTER name;

■Sample741
SHOW COLUMNS FROM student_list;

■Sample742
SELECT * FROM student_list;

■Sample743
ALTER TABLE student_list
CHANGE name student_name VARCHAR(32) NOT NULL;

■Sample744
SHOW COLUMNS FROM student_list;

■Sample745
ALTER TABLE student_list MODIFY grade INT NOT NULL;

■Sample746
SHOW COLUMNS FROM student_list;

■Sample747
ALTER TABLE student_list DROP id;

■Sample748
SHOW COLUMNS FROM student_list;

■Sample749
SELECT * FROM student_list;



■例題7-1
(1)
INSERT INTO cars (name, automaker, price)
VALUES ('ヤリス', 'トヨタ', 265);
INSERT INTO cars (name, automaker, price)
VALUES ('ハリアー', 'トヨタ', 300);
INSERT INTO cars (name, automaker, price)
VALUES ('フィット', 'ホンダ', 200);
INSERT INTO cars (name, automaker, price)
VALUES ('N-ONE', 'ホンダ', 200);

(2)
SAVEPOINT SP1;

(3)
INSERT INTO cars(name, automaker, price) 
VALUES('セレナ', 'ニッサン', 200);
INSERT INTO cars(name, automaker, price) 
VALUES('ノート', 'ニッサン', 250);

(4)
SAVEPOINT SP2;

(5)
UPDATE cars SET price = 300 WHERE name = 'セレナ';

(6)
ROLLBACK TO SAVEPOINT SP2;

(7)
ROLLBACK TO SAVEPOINT SP1;

(8)
DELETE FROM cars WHERE automaker = 'ホンダ';

(9)
COMMIT;