创建数据表:
DROP TABLE IF EXISTS `blog_article`;
CREATE TABLE `blog_article` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`content` mediumtext NOT NULL COMMENT '文章内容',
`sort` smallint(6) unsigned DEFAULT '0' COMMENT '排序权重',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态(0:禁用,1:启用,)',
`is_open` tinyint(1) DEFAULT '1' COMMENT '是否公开 (0:否,1:是)',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否删除(0:删除,1:正常启用,)',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='项目同步结果列表';
添加表字段:
ALTER TABLE `tour_guide` ADD
(`link_e` mediumtext NOT NULL COMMENT '链接',
`link_z` mediumtext NOT NULL COMMENT '链接');
添加索引:
ALTER TABLE `tour_guide`
ADD PRIMARY KEY (`id`) USING BTREE;
修改表字段:
ALTER TABLE `about_us`
MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `tour_guide`
CHANGE `create_by``create_by_id` int(10) DEFAULT '0' COMMENT '创建人';
删除表字段:
ALTER TABLE blog_article DROP create_by;
数据增删改语句:
INSERT INTO `blog_article` VALUES (4,6,0,'新增','/static/temp/blog/art.jpg');
DELETE
FROM
blog_article
WHERE
orderid IN ("1","2","3","4","5","6");