Ryan Wang 👍 😅 可能我没表达清楚。意思是mysql的数据表,表结构如下:
CREATE TABLE article (
id VARCHAR(36) NOT NULL COMMENT '文章ID' COLLATE 'utf8_general_ci',
category_id VARCHAR(36) NOT NULL COMMENT '栏目ID' COLLATE 'utf8_general_ci',
title VARCHAR(200) NOT NULL COMMENT '标题' COLLATE 'utf8_general_ci',
keyword VARCHAR(50) NOT NULL DEFAULT '' COMMENT '关键词' COLLATE 'utf8_general_ci',
is_top TINYINT(4) NOT NULL DEFAULT '0' COMMENT '是否置顶',
is_carousel TINYINT(4) NOT NULL DEFAULT '0' COMMENT '是否轮播',
cover VARCHAR(200) NOT NULL DEFAULT '' COMMENT '封面图' COLLATE 'utf8_general_ci',
link VARCHAR(500) NOT NULL DEFAULT '' COMMENT '链接地址' COLLATE 'utf8_general_ci',
summary VARCHAR(500) NOT NULL DEFAULT '' COMMENT '摘要' COLLATE 'utf8_general_ci',
type VARCHAR(50) NULL DEFAULT '' COMMENT '文章类型' COLLATE 'utf8_general_ci',
publish_status VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '发布状态(1:已发布,0:未发布)' COLLATE 'utf8_general_ci',
content LONGTEXT NOT NULL COMMENT '内容' COLLATE 'utf8_general_ci',
source VARCHAR(30) NOT NULL DEFAULT '' COMMENT '来源' COLLATE 'utf8_general_ci',
publisher VARCHAR(30) NOT NULL DEFAULT '' COMMENT '发布者' COLLATE 'utf8_general_ci',
publish_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发布时间',
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (id) USING BTREE,
INDEX create_time (create_time) USING BTREE,
INDEX category_id (category_id) USING BTREE,
INDEX isTop_isCarousel (is_top, is_carousel) USING BTREE,
INDEX title (title) USING BTREE,
INDEX keyword (keyword) USING BTREE
)
COMMENT='文章'
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
如何将表里的数据导入导本项目。 感谢