IP Admin

labelroll

hkcards

Direct Admin

labelroll

hkcards

學倉頡

導言及簡介

速成輸入法

速成輸入法

打字練習

Index

六國論

把Excel 轉成SQL

原 Excel File 整理好 id number

開 Excel File (cj.xls)

Copy 資料 入 Excel File

Copy Header

Delete 淨 Sheet1

轉換網

Table Name: cj

每次上限5000條


Cpanel - barckcom

倉頡: DELETE FROM `mc_db_001` WHERE `category`=2

粵音: DELETE FROM `mc_db_001` WHERE `category`=3

: DELETE FROM `mc_db_001` WHERE `category`=4

倉頡字母: DELETE FROM `mc_db_001` WHERE `category`=7

特選字: DELETE FROM `mc_db_001` WHERE `category`=8

備用轉換網

全新網站建立新的 MySQL Database

Direct Admin

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

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

然後login 入去 phpmyadmin

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

備註:table 名: mc_db_001

MySQL

DELETE FROM `cj` WHERE `category`=10

DELETE FROM `cj` WHERE `category`=2

DROP TABLE cj

DELETE FROM `cj` WHERE `id` > 18981

DELETE FROM `cj` WHERE `id` = 18979

SELECT * FROM cj WHERE question="𢭃" AND category=10

顯示每一頁下面的字面的php code

case ($last_two_digit == 1):
echo "last digit: ($last_two_digit)";
include("../cj/w-list-1.php");
break;

www.labelroll.com 倉頡速成字典 © 2021