(0)執行CMD
(1)啟動MYSQL命令列
C:> cd C:\AppServ\MySQL\bin
C:> mysql -p -uroot
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.17 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
(2) 設定欄名採用UTF8字元集：
mysql> set names utf8;
Query OK, 0 rows affected, 1 warning (0.06 sec)
(3) 使用selldb資料庫
mysql> use selldb;
(4)建立factory資料表
mysql> CREATE TABLE factory (facno char(20) primary key, facname char(30) default 'x', master char(30) default 'x',tel char(20) default '0823-12312' , addr char(40) default '-' , lastdeal char(10) default '-', accountd char(20) default '-', ps char(40) default '0');
Query OK, 0 rows affected (0.28 sec)
(5)列出factory資料表的欄位結構
mysql> desc factory;
+----------+----------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------+------+-----+------------+-------+
| facno | char(20) | NO | PRI | NULL | |
| facname | char(30) | YES | | x | |
| master | char(30) | YES | | x | |
| tel | char(20) | YES | | 0823-12312 | |
| addr | char(40) | YES | | - | |
| lastdeal | char(10) | YES | | - | |
| accountd | char(20) | YES | | - | |
| ps | char(40) | YES | | 0 | |
+----------+----------+------+-----+------------+-------+
8 rows in set (0.00 sec)
(6-1)加入一筆資料到factory資料表成功:
mysql> insert into factory (facno,facname,master, tel,addr,lastdeal,accountd) values ('717','花草樹木','吳花果','082-333274','田裡100號','2020-05-11','郵局013124-7');
Query OK, 1 row affected (0.04 sec)
(6-2)再加入一筆同樣的資料到factory資料表失敗:
mysql> insert into factory (facno,facname,master, tel,addr,lastdeal,accountd) values ('717','花草樹木','吳花果','082-333274','田裡100號','2020-05-11','郵局013124-7');
ERROR 1062 (23000): Duplicate entry '717' for key 'PRIMARY'
mysql>
(6-3)再加入另一筆資料到factory資料表成功:
mysql> insert into factory (facno,facname,master, tel,addr,lastdeal,accountd) values ('727','蟲魚鳥獸','楊一心','082-111222','山裡200號','2020-05-10','台銀111222-3');
Query OK, 1 row affected (0.06 sec)
(6-4)再加入另一筆資料到factory資料表成功:
mysql> insert into factory (facno,facname,master, tel,addr,lastdeal,accountd) values ('077','金農行','金老板','082-777777','金湖1號','2020-06-08','台銀777666-2');
Query OK, 1 row affected (0.04 sec)
(7)列出factory資料表的內容：
mysql> select * from factory;
+-------+----------+--------+------------+-----------+------------+--------------+------+
| facno | facname | master | tel | addr | lastdeal | accountd | ps |
+-------+----------+--------+------------+-----------+------------+--------------+------+
| 077 | 金農行 | 金老板 | 082-777777 | 金湖1號 | 2020-06-08 | 台銀777666-2 | 0 |
| 717 | 花草樹木 | 吳花果 | 082-333274 | 田裡100號 | 2020-05-11 | 郵局013124-7 | 0 |
| 727 | 蟲魚鳥獸 | 楊一心 | 082-111222 | 山裡200號 | 2020-05-10 | 台銀111222-3 | 0 |
+-------+----------+--------+------------+-----------+------------+--------------+------+
3 rows in set (0.00 sec)
mysql>
(8)結束MYSQL命令列
mysql>quit |