How to export mysql sql to separate create table, create index? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

This question does not appear to be about programming within the scope defined in the help center.

Closed 16 mins ago.

Improve this question

I have some mysql tables, and I want to export them to the form which sqlite can accept, then import into sqlite.

When I try to use mysqldump to export it. It generate the followings.

DROP TABLE IF EXISTS `onl_cgform_button`;
CREATE TABLE `onl_cgform_button`  (
  `ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键ID',
  `BUTTON_CODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮编码',
  `BUTTON_ICON` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮图标',
  `BUTTON_NAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮名称',
  `BUTTON_STATUS` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮状态',
  `BUTTON_STYLE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮样式',
  `EXP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表达式',
  `CGFORM_HEAD_ID` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单ID',
  `OPT_TYPE` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮类型',
  `ORDER_NUM` int(11) NULL DEFAULT NULL COMMENT '排序',
  `OPT_POSITION` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮位置1侧面 2底部',
  PRIMARY KEY (`ID`) USING BTREE,
  INDEX `idx_ocb_CGFORM_HEAD_ID`(`CGFORM_HEAD_ID`) USING BTREE,
  INDEX `idx_ocb_BUTTON_CODE`(`BUTTON_CODE`) USING BTREE,
  INDEX `idx_ocb_BUTTON_STATUS`(`BUTTON_STATUS`) USING BTREE,
  INDEX `idx_ocb_ORDER_NUM`(`ORDER_NUM`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_gene开发者_运维技巧ral_ci COMMENT = 'Online表单自定义按钮' ROW_FORMAT = Dynamic;

Actually, I want to change to the following form which separate the create table and create index.

DROP TABLE IF EXISTS `onl_cgform_button`;
CREATE TABLE `onl_cgform_button`  (
  `ID` varchar(32) NOT NULL,
  `BUTTON_CODE` varchar(50) NULL DEFAULT NULL,
  `BUTTON_ICON` varchar(20) NULL DEFAULT NULL,
  `BUTTON_NAME` varchar(50) NULL DEFAULT NULL,
  `BUTTON_STATUS` varchar(2) NULL DEFAULT NULL,
  `BUTTON_STYLE` varchar(20) NULL DEFAULT NULL,
  `EXP` varchar(255) NULL DEFAULT NULL,
  `CGFORM_HEAD_ID` varchar(32) NULL DEFAULT NULL,
  `OPT_TYPE` varchar(20) NULL DEFAULT NULL,
  `ORDER_NUM` int(11) NULL DEFAULT NULL,
  `OPT_POSITION` varchar(3) NULL DEFAULT NULL,
  PRIMARY KEY (`ID`)
);
CREATE INDEX `idx_ocb_CGFORM_HEAD_ID` on `onl_cgform_button` (`CGFORM_HEAD_ID`);
CREATE INDEX `idx_ocb_BUTTON_CODE` on `onl_cgform_button` (`BUTTON_CODE`);
CREATE INDEX `idx_ocb_BUTTON_STATUS` on `onl_cgform_button` (`BUTTON_STATUS`);
CREATE INDEX `idx_ocb_ORDER_NUM` on `onl_cgform_button` (`ORDER_NUM`);

Is there any mysqldump options can do it or use some other tools for this purpose?