104 lines
5.0 KiB
Plaintext
104 lines
5.0 KiB
Plaintext
mysql> CREATE TABLE book_table (
|
|
-> book_id INT,
|
|
-> book_name VARCHAR(50),
|
|
-> author_name VARCHAR(50),
|
|
-> price INT,
|
|
-> sales_flag INT
|
|
-> );
|
|
Query OK, 0 rows affected (0.03 sec)
|
|
|
|
mysql> INSERT INTO book_table VALUES (10001, 'TwoPeace', '三田栄一郎', 420, 1);
|
|
Query OK, 1 row affected (0.02 sec)
|
|
|
|
mysql> INSERT INTO book_table VALUES (10002, '名探偵金田二', '青山ふみや', 460, 1);
|
|
Query OK, 1 row affected (0.01 sec)
|
|
|
|
mysql> INSERT INTO book_table VALUES (20001, '坊ちゃま', '冬目漱岩', 460, 1);
|
|
Query OK, 1 row affected (0.01 sec)
|
|
|
|
mysql> INSERT INTO book_table VALUES (30001, '西方見聞録', '不明', 1000, 1);
|
|
Query OK, 1 row affected (0.01 sec)
|
|
|
|
mysql> INSERT INTO book_table VALUES (40010, '吾輩は犬である', '冬目漱岩', 420, 1);
|
|
Query OK, 1 row affected (0.00 sec)
|
|
|
|
mysql> SELECT * FROM book_table;
|
|
+---------+----------------+-------------+-------+------------+
|
|
| book_id | book_name | author_name | price | sales_flag |
|
|
+---------+----------------+-------------+-------+------------+
|
|
| 10001 | TwoPeace | 三田栄一郎 | 420 | 1 |
|
|
| 10002 | 名探偵金田二 | 青山ふみや | 460 | 1 |
|
|
| 20001 | 坊ちゃま | 冬目漱岩 | 460 | 1 |
|
|
| 30001 | 西方見聞録 | 不明 | 1000 | 1 |
|
|
| 40010 | 吾輩は犬である | 冬目漱岩 | 420 | 1 |
|
|
+---------+----------------+-------------+-------+------------+
|
|
5 rows in set (0.00 sec)
|
|
|
|
mysql> SELECT book_name , author_name FROM book_table;
|
|
+----------------+-------------+
|
|
| book_name | author_name |
|
|
+----------------+-------------+
|
|
| TwoPeace | 三田栄一郎 |
|
|
| 名探偵金田二 | 青山ふみや |
|
|
| 坊ちゃま | 冬目漱岩 |
|
|
| 西方見聞録 | 不明 |
|
|
| 吾輩は犬である | 冬目漱岩 |
|
|
+----------------+-------------+
|
|
5 rows in set (0.00 sec)
|
|
|
|
mysql> SELECT * FROM book_table;
|
|
+---------+----------------+-------------+-------+------------+
|
|
| book_id | book_name | author_name | price | sales_flag |
|
|
+---------+----------------+-------------+-------+------------+
|
|
| 10001 | TwoPeace | 三田栄一郎 | 420 | 1 |
|
|
| 10002 | 名探偵金田二 | 青山ふみや | 460 | 1 |
|
|
| 20001 | 坊ちゃま | 冬目漱岩 | 460 | 1 |
|
|
| 30001 | 西方見聞録 | 不明 | 1000 | 0 |
|
|
| 40010 | 吾輩は犬である | 冬目漱岩 | 420 | 1 |
|
|
+---------+----------------+-------------+-------+------------+
|
|
5 rows in set (0.00 sec)
|
|
|
|
mysql> SELECT * FROM book_table WHERE sales_flag = 1;
|
|
+---------+----------------+-------------+-------+------------+
|
|
| book_id | book_name | author_name | price | sales_flag |
|
|
+---------+----------------+-------------+-------+------------+
|
|
| 10001 | TwoPeace | 三田栄一郎 | 420 | 1 |
|
|
| 10002 | 名探偵金田二 | 青山ふみや | 460 | 1 |
|
|
| 20001 | 坊ちゃま | 冬目漱岩 | 460 | 1 |
|
|
| 40010 | 吾輩は犬である | 冬目漱岩 | 420 | 1 |
|
|
+---------+----------------+-------------+-------+------------+
|
|
4 rows in set (0.00 sec)
|
|
|
|
mysql> SELECT * FROM book_table WHERE author_name = '冬目漱岩' AND price = 420;
|
|
+---------+----------------+-------------+-------+------------+
|
|
| book_id | book_name | author_name | price | sales_flag |
|
|
+---------+----------------+-------------+-------+------------+
|
|
| 40010 | 吾輩は犬である | 冬目漱岩 | 420 | 1 |
|
|
+---------+----------------+-------------+-------+------------+
|
|
1 row in set (0.00 sec)
|
|
|
|
mysql> SELECT * FROM book_table;
|
|
+---------+----------------+-------------+-------+------------+
|
|
| book_id | book_name | author_name | price | sales_flag |
|
|
+---------+----------------+-------------+-------+------------+
|
|
| 10001 | TwoPeace | 三田栄一郎 | 420 | 1 |
|
|
| 10002 | 名探偵金田二 | 青山ふみや | 460 | 1 |
|
|
| 30001 | 西方見聞録 | 不明 | 1000 | 0 |
|
|
| 40010 | 吾輩は犬である | 冬目漱岩 | 420 | 1 |
|
|
+---------+----------------+-------------+-------+------------+
|
|
4 rows in set (0.00 sec)
|
|
|
|
mysql> UPDATE book_table SET author_name = 'マール＝コー＝ポロ' WHERE book_id = 30001;
|
|
Query OK, 1 row affected (0.00 sec)
|
|
Rows matched: 1 Changed: 1 Warnings: 0
|
|
|
|
mysql> SELECT * FROM book_table;
|
|
+---------+----------------+--------------------+-------+------------+
|
|
| book_id | book_name | author_name | price | sales_flag |
|
|
+---------+----------------+--------------------+-------+------------+
|
|
| 10001 | TwoPeace | 三田栄一郎 | 420 | 1 |
|
|
| 10002 | 名探偵金田二 | 青山ふみや | 460 | 1 |
|
|
| 30001 | 西方見聞録 | マール＝コー＝ポロ | 1000 | 0 |
|
|
| 40010 | 吾輩は犬である | 冬目漱岩 | 420 | 1 |
|
|
+---------+----------------+--------------------+-------+------------+
|
|
4 rows in set (0.00 sec) |