(0)執行CMD
(1)啟動MYSQL命令列
C:> cd C:\AppServ\MySQL\bin
C:> mysql -p -uroot
Enter password: ************
:
mysql>
(2) 設定欄名採用UTF8字元集：
mysql> set names utf8;
Query OK, 0 rows affected, 1 warning (0.06 sec)
(3) 使用selldb資料庫
mysql> use selldb;
Database changed
(4)建立new_id_reg資料表:
mysql> create table new_id_reg (
sta_no char(1),
inday char(20) default '2018-08-08 08:08:08',
custno char(10) default '818818',
money_store int default 0,
saleno char(10) default '-' ,
remain int default 0,
serial char(20) primary key,
oldremain int default 0) ;
Query OK, 0 rows affected (0.03 sec)
(5)列出new_id_reg資料表的欄位結構：
mysql> desc new_id_reg;
+-------------+----------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------------------+-------+
| sta_no | char(1) | YES | | NULL | |
| inday | char(20) | YES | | 2018-08-08 08:08:08 | |
| custno | char(10) | YES | | 818818 | |
| money_store | int(11) | YES | | 0 | |
| saleno | char(10) | YES | | - | |
| remain | int(11) | YES | | 0 | |
| serial | char(20) | NO | PRI | NULL | |
| oldremain | int(11) | YES | | 0 | |
+-------------+----------+------+-----+---------------------+-------+
8 rows in set (0.03 sec)
(7-1)插入一筆資料到new_id_reg資料表：
mysql>insert into new_id_reg
(sta_no,inday,custno,money_store,
saleno,remain,serial,oldremain)
values
('A','2018-10-10 21:24:00','312001',
5000, 'X',6100,'A2018101000001',1100);
Query OK, 1 row affected (0.03 sec)
(7-2)再插入一筆資料到new_id_reg資料表：
mysql>insert into new_id_reg
(sta_no,inday,custno,money_store,
saleno,remain,serial,oldremain)
values
('B','2020-06-18 21:07:00','312002',9000,
'Y',9100,'B2020061800001',100);
Query OK, 1 row affected (0.00 sec)
(7-3)再插入一筆資料到new_id_reg資料表：
mysql>insert into new_id_reg
(sta_no,inday,custno,money_store,
saleno,remain,serial,oldremain)
values
('B','2020-06-18 21:11:00','312003',2000,
'Y',2900,'B2020061800002',900);
Query OK, 1 row affected (0.00 sec)
(8)列出new_id_reg資料表的所有資料錄
mysql> select * from new_id_reg;
+--------+---------------------+--------+-------------+--------+--------+----------------+-----------+
| sta_no | inday | custno | money_store | saleno | remain | serial | oldremain |
+--------+---------------------+--------+-------------+--------+--------+----------------+-----------+
| A | 2018-10-10 21:24:00 | 312001 | 5000 | X | 6100 | A2018101000001 | 1100 |
| B | 2020-06-18 21:07:00 | 312002 | 9000 | Y | 9100 | B2020061800001 | 100 |
| B | 2020-06-18 21:11:00 | 312003 | 2000 | Y | 2900 | B2020061800002 | 900 |
+--------+---------------------+--------+-------------+--------+--------+----------------+-----------+
3 rows in set (0.00 sec)
mysql>
|