npm install -g express-generator
npm install -g nodemon
# 有缺模組執行
npm install
# 執行有問題的話 嘗試修復
npm audit fix --force
# 套件更新
npm update
# 移除套件
npm uninstall mysqlnodemon start#看端口
netstat -ano | findstr :8888
#終止端口
taskkill /PID ***** /F- 下載安裝(mysql)[https://dev.mysql.com/downloads/mysql/]
- 建立資料庫 member_data
- 執行以下指令
-- 會員表
CREATE TABLE members (
ID int(11) NOT NULL AUTO_INCREMENT,
EMAIL varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL UNIQUE,
SEX enum('male', 'female', 'other') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
NAME varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
COUNTRY varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CITY varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
INTERESTS text COLLATE utf8mb4_unicode_ci,
NOTE text COLLATE utf8mb4_unicode_ci,
RECORD_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- 訂單表
CREATE TABLE orders (
ID int(11) NOT NULL AUTO_INCREMENT,
MEMBER_ID int(11) NOT NULL,
SERIAL_NUMBER varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL UNIQUE,
ORDER_DATE TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PURCHASED_ITEMS text COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (ID),
FOREIGN KEY (MEMBER_ID) REFERENCES members(ID) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;(dberve 無法連線處理)[https://sinyilin.github.io/SQL/20230425/4002286829/]
- 將config.ini.example 複製檔 並命名為config.ini
- 到config.ini檔案內更改db, server 配置