mysql创建表k12,有字段id自增长、keyword为字符串并添加为索引、title为字符串并添加为索引、body为长字符串、fenlei为字符串并添加为索引,编码为utf8mb4 -- UTF-8 Unicode,utf8mb4_general_ci
CREATE TABLE k12 ( id INT AUTO_INCREMENT PRIMARY KEY, keyword VARCHAR(255), title VARCHAR(255), body LONGTEXT, fenlei VARCHAR(255), INDEX idx_keyword (keyword), INDEX idx_title (title), INDEX idx_fenlei (fenlei) ) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;