37 lines
847 B
SQL
37 lines
847 B
SQL
--問１
|
|
CREATE TABLE book_table (
|
|
book_id INT,
|
|
book_name VARCHAR(50),
|
|
author_name VARCHAR(50),
|
|
price INT,
|
|
sales_flag INT
|
|
);
|
|
|
|
--問２
|
|
INSERT INTO book_table VALUES(10001,'TwoPeace','三田英一郎',420,1);
|
|
INSERT INTO book_table VALUES(10002,'名探偵金田二','青山ふみや',460,1);
|
|
INSERT INTO book_table VALUES(20001,'坊ちゃま','冬目漱岩',460,1);
|
|
INSERT INTO book_table VALUES(30001,'西方見聞録','不明',1000,1);
|
|
INSERT INTO book_table VALUES(40010,'吾輩は犬である','冬目漱岩',420,1);
|
|
|
|
--問３
|
|
SELECT book_name,author_name FROM book_table;
|
|
|
|
--問４
|
|
UPDATE book_table
|
|
SET author_name = 'マール＝コー＝ポロ',
|
|
sales_flag = 0
|
|
WHERE book_id = 30001;
|
|
|
|
--問５
|
|
SELECT * FROM book_table
|
|
WHERE sales_flag = 1;
|
|
|
|
--問６
|
|
SELECT * FROM book_table
|
|
WHERE author_name = '冬目漱岩' AND price = 420;
|
|
|
|
--問７
|
|
DELETE FROM book_table
|
|
WHERE book_id = 20001;
|