MySQL Syntax www.barcodelabelhk.com

Create cj

CREATE TABLE IF NOT EXISTS cj (
    `item` INT  PRIMARY KEY NOT NULL AUTO_INCREMENT,
    `category` INT,
    `sub01` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `sub02` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `sub03` INT,
    `sub04` INT,
    `active` INT, 
    `question` VARCHAR(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `correct` VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `choice1` VARCHAR(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `choice2` VARCHAR(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `choice3` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `choice4` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `explanation` VARCHAR(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `name` VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `message` VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `time` INT,
    `date` VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `remark` VARCHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
);

Create db02

CREATE TABLE IF NOT EXISTS db02 (
    `id` INT  PRIMARY KEY NOT NULL AUTO_INCREMENT,
    `title_url` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d01` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d02` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d03` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d04` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d05` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d06` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d07` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d08` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d09` VARCHAR(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d10` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d11` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d12` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group01` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group02` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group03` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group04` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group05` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
);

MySQL 語法

db03

CREATE TABLE IF NOT EXISTS db03 (
    `id` INT  PRIMARY KEY NOT NULL AUTO_INCREMENT,
    `cat01` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat02` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat03` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat04` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat05` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat06` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat07` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat08` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat09` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `cat10` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d01` VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d02` VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d03` VARCHAR(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d04` VARCHAR(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d05` VARCHAR(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d06` VARCHAR(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d07` VARCHAR(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d08` VARCHAR(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d09` VARCHAR(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d10` VARCHAR(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d11` VARCHAR(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d12` VARCHAR(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d13` VARCHAR(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d14` VARCHAR(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d15` VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d16` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `int01` INT,
    `int02` INT,
    `int03` INT,
    `int04` INT,
    `int05` INT,
    `int06` INT,
    `int07` INT,
    `int08` INT,
    `int09` INT,
    `int10` INT
);

Create todo

CREATE TABLE IF NOT EXISTS todo (
    `id` INT  PRIMARY KEY NOT NULL AUTO_INCREMENT,
    `title_url` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d01` INT,
    `d02` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d03` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d04` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d05` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d06` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d07` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d08` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d09` VARCHAR(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d10` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d11` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `d12` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group01` VARCHAR(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group02` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group03` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group04` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
    `group05` VARCHAR(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
);

utf8mb4_unicode_ci:

為了能處理香港字和 ext-a, ext-b 的字, char-set 要選用 utf8mb4_unicode_ci

當連接數據庫時，php 要寫 mysqli_set_charset($link, "utf8mb4");

把Excel 轉成SQL

原 Excel File 整理好 id number

開 Excel File (cj.xls)

Copy 資料入 Excel File

Copy Header

Delete 淨 Sheet1

轉換網

Table Name: cj

每次上限5000條

備用轉換網

為全新網站建立新的 MySQL Database

Direct Admin

Your Account -> MySQL 管理 -> 新增數據庫

為新數據庫改名, 改login Name, Password

然後login 入去 phpmyadmin

選擇剛才改名的新數據庫，以SQL指令建立新table

備註:table 名: mc_db_001

Create viewcount table

常用工具

管理 A倉01 25條倉頡練習 Sitemap Generator 寫解釋加一百合體字 Add 新增