Vue

MySql Tables 操作(創建/查看 /刪除)

建立資料庫

1
2
3
4
5
6
7
8
9
10
11
12
13
create database demo_db;
Query OK, 1 row affected (0.00 sec)
show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| demo_db            |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)
  • create table創建單一table
  • show tables查看所有tables
  • show columns tables from tableName查看單一table
  • desc tableName 查看單一table
  • drop table tableName刪除單一table

創建table

1
2
3
4
5
//使用資料庫
use  demo_db
//建立table 
create table person(name varchar(20),phone varchar(20),age int);
Query OK, 0 rows affected (0.04 sec)

查看剛剛新增的table

1
2
3
4
5
6
7
8
9
10
//指令
desc person;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name  | varchar(20) | YES  |     | NULL    |       |
| phone | varchar(20) | YES  |     | NULL    |       |
| age   | int(11)     | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

show tables 查看所有tables

1
2
3
4
5
6
7
show tables;
+-------------------+
| Tables_in_demo_db |
+-------------------+
| person            |
+-------------------+
1 row in set (0.00 sec)

show columns tables from tableName（查看單一table）

1
2
3
4
5
6
7
8
show columns from person;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name  | varchar(20) | YES  |     | NULL    |       |
| phone | varchar(20) | YES  |     | NULL    |       |
| age   | int(11)     | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+

drop table tableName(刪除table)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
show tables;
+-------------------+
| Tables_in_demo_db |
+-------------------+
| person            |
| products          |
+-------------------+
2 rows in set (0.00 sec)

//刪除table
drop table products;
Query OK, 0 rows affected (0.01 sec)

show tables;
+-------------------+
| Tables_in_demo_db |
+-------------------+
| person            |
+-------------------+
1 row in set (0.00 sec)