Vue

MySql 建立資料庫與創建資料表

建立資料庫

1
create 資料庫名稱;

創建table

1
2
3
4
5
6
CREATE TABLE table_name (
  column_name1 data_type,
  column_name2 data_type,
  column_name3 data_type,
  ···
);

建立一個 “customers” 資料表，其中包含這幾個欄位 - C_Id, Name, Address, Phone：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
CREATE TABLE `users` ( 
    id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    uId INT NOT NULL UNIQUE, 
    userName VARCHAR(30) NOT NULL, 
    userEmail VARCHAR(50) NOT NULL, 
    userPassword VARCHAR(30) NOT NULL, 
    userPhone VARCHAR(10) NOT NULL, 
    roleId INT NOT NULL, 
    createdAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    updatedAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    deletedAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP 
);
CREATE TABLE `users` (
    id INT NOT NULL AUTO_INCREMENT, 
    uId INT NOT NULL, 
    userName VARCHAR(50) NOT NULL, 
    userEmail VARCHAR(30)NOT NULL, 
    userPassword VARCHAR(30) NOT NULL, 
    userPhone VARCHAR(10) NOT NULL, 
    roleId INT NOT NULL, 
    createdAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    updatedAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    deletedAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , 
    PRIMARY KEY (id), 
    UNIQUE (uId) 
);