命令產生資料表

1. 登入 mariadb。

   [root@kvm3 ~]# mycli -uroot -p123qwe
   Connecting to socket /var/lib/mysql/mysql.sock, owned by user mysql
   MariaDB 10.5.16
   mycli 1.26.1
   Home: http://mycli.net
   Bug tracker: https://github.com/dbcli/mycli/issues
   Thanks to the contributor - spacewander
   MariaDB root@(none):(none)>
   

2. 查詢資料庫。

   MariaDB root@(none):(none)> show databases;
   +--------------------+
   | Database           |
   +--------------------+
   | dyw                |
   | dywphp             |
   | information_schema |
   | mysql              |
   | performance_schema |
   +--------------------+
   
   5 rows in set
   Time: 0.070s
   

3. 使用 dyw 資料庫。

   MariaDB root@(none):(none)> use dyw;
   You are now connected to database "dyw" as user "root"
   Time: 0.004s
   

4. 產生資料表 tbl，共有 4 個欄位，id 是主鍵，不能是 NULL 且自動增加；title 最長 100 個字元的字串，不能是空的；author 最長 40 個字元的字串，不能是空的；submission_date 記錄寫入時間。

   MariaDB root@(none):dyw> create table tbl(id int not null auto_increment, title
                         -> varchar(100) not null, author varchar(40) not null, sub
                         -> mission_date date, primary key(id));
   Query OK, 0 rows affected
   Time: 0.118s
   

5. 查看 tbl 資料表欄位型態。

   MariaDB root@(none):dyw> show columns from tbl;
   +-----------------+--------------+------+-----+---------+----------------+
   | Field           | Type         | Null | Key | Default | Extra          |
   +-----------------+--------------+------+-----+---------+----------------+
   | id              | int(11)      | NO   | PRI | <null>  | auto_increment |
   | title           | varchar(100) | NO   |     | <null>  |                |
   | author          | varchar(40)  | NO   |     | <null>  |                |
   | submission_date | date         | YES  |     | <null>  |                |
   +-----------------+--------------+------+-----+---------+----------------+
   
   4 rows in set
   Time: 0.064s
   

6. desc 也可查看 tbl 資料表欄位型態。

   MariaDB root@(none):dyw> desc tbl;
   +-----------------+--------------+------+-----+---------+----------------+
   | Field           | Type         | Null | Key | Default | Extra          |
   +-----------------+--------------+------+-----+---------+----------------+
   | id              | int(11)      | NO   | PRI | <null>  | auto_increment |
   | title           | varchar(100) | NO   |     | <null>  |                |
   | author          | varchar(40)  | NO   |     | <null>  |                |
   | submission_date | date         | YES  |     | <null>  |                |
   +-----------------+--------------+------+-----+---------+----------------+
   
   4 rows in set
   Time: 0.022s
   

7. 查看 dyw 資料庫的資料表，出現 tbl。

   MariaDB root@(none):dyw> show tables;
   +---------------+
   | Tables_in_dyw |
   +---------------+
   | tbl           |
   +---------------+
   
   1 row in set
   Time: 0.029s