
复制CREATETABLE `t_qa` ( `id` bigint(20) NOTNULL AUTO_INCREMENT,记种 `title` varchar(200) NOTNULLDEFAULT COMMENT 标题, `answer_count` int(5) unsigned NOTNULLDEFAULT0 COMMENT 回答个数, `label_id` bigint(20) unsigned NOTNULLDEFAULT0 COMMENT 标签id, `create_by` bigint(20) unsigned NOTNULLDEFAULT0 COMMENT 创建人, `create_date` datetime NOTNULLDEFAULT0000-00-00 00:00:00 COMMENT 创建时间, `update_by` bigint(20) unsigned DEFAULTNULL COMMENT 更新人, `update_date` datetime DEFAULTNULL COMMENT 更新时间, `del_flag` tinyint(1) unsigned NOTNULLDEFAULT0 COMMENT 0:不删除,1:删除,记种
PRIMARYKEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERTINTO `t_qa` (`id`, `title`, `answer_count`, `label_id`, `create_by`, `create_date`, `update_by`, `update_date`, `del_flag`) VALUES (1, Java是什么?, 5, 1, 0, 2017-08-24 17:43:53, 0, 2017-08-24 17:43:53, 0), (2, PHP是
云服务器提供商什么?, 4, 2, 0, 2017-08-24 17:43:53, 0, 2017-08-24 17:43:53, 0), (3, 前端是什么?, 3, 3, 0, 2017-08-24 17:43:53, 0, 2017-08-24 17:43:53, 0), (4, nodejs是
云南idc服务商什么?, 2, 0, 0, 2017-08-24 17:43:53, 0, 2017-08-24 17:43:53, 0), (5, css是什么?, 1, 0, 0, 2017-08-24 17:43:53, 0, 2017-08-24 17:43:53, 0), (6, JavaScript是
IT技术网什么?, 0, 0, 0, 2017-08-24 17:43:53, 0, 2017-08-24 17:43:53, 0); 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.