CREATE TABLE `batch_info` ( `batch_id` bigint(20) NOT NULL COMMENT '批次ID', `batch_modality` int(1) NOT NULL COMMENT '批次类型', `batch_name` varchar(20) NOT NULL COMMENT '批次名称', `card_amount` int(6) NOT NULL COMMENT '卡券数量', `end_date` timestamp NULL DEFAULT NULL COMMENT '截止日期', `card_source` int(1) NOT NULL COMMENT '卡券来源', `card_no_prefix` varchar(10) DEFAULT NULL COMMENT '卡券前缀', `card_no_length` int(12) DEFAULT NULL COMMENT '起始卡号长度', `need_password` int(1) DEFAULT NULL COMMENT '需要密码', `show_price` int(1) DEFAULT NULL COMMENT '展示价格', `pay_type` int(1) DEFAULT NULL COMMENT '付费模式', `can_give` int(1) DEFAULT NULL COMMENT '可否转增', `fixed_price` int(10) DEFAULT NULL COMMENT '固定价格', `discount` int(4) DEFAULT NULL COMMENT '折扣', `not_small_change` int(1) DEFAULT NULL COMMENT '抹零方式', `extra_info` int(1) DEFAULT NULL COMMENT '附加信息', `extra_info_content` varchar(10) DEFAULT NULL COMMENT '附加信息内容', `extra_must` int(1) DEFAULT NULL COMMENT '是否必填', `batch_notes` varchar(100) DEFAULT NULL COMMENT '批次备注', `card_name` varchar(20) DEFAULT NULL COMMENT '卡券名', `card_type` int(1) DEFAULT NULL COMMENT '卡券类型', `item_id` bigint(20) DEFAULT NULL COMMENT '线上商品ID', `template_id` bigint(20) NOT NULL COMMENT '模板Id', `use_store_ids` varchar(5000) DEFAULT NULL COMMENT '适用店铺', `designate_type` int(1) DEFAULT NULL COMMENT '适用店铺类型', `store_id` varchar(20) NOT NULL COMMENT '店铺ID', `create_by` varchar(15) NOT NULL COMMENT '创建人', `update_by` varchar(15) DEFAULT NULL COMMENT '修改人', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `start_no` bigint(10) DEFAULT NULL COMMENT '起始卡号', `end_no` bigint(10) DEFAULT NULL COMMENT '截至卡号', UNIQUE KEY `idx_batch_store_id` (`store_id`,`batch_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8按照这个表生成一个全参insert语句
时间: 2023-11-21 09:49:20 浏览: 34
INSERT INTO `batch_info` (`batch_id`, `batch_modality`, `batch_name`, `card_amount`, `end_date`, `card_source`, `card_no_prefix`, `card_no_length`, `need_password`, `show_price`, `pay_type`, `can_give`, `fixed_price`, `discount`, `not_small_change`, `extra_info`, `extra_info_content`, `extra_must`, `batch_notes`, `card_name`, `card_type`, `item_id`, `template_id`, `use_store_ids`, `designate_type`, `store_id`, `create_by`, `update_by`, `create_time`, `update_time`, `start_no`, `end_no`) VALUES ([batch_id_value], [batch_modality_value], '[batch_name_value]', [card_amount_value], '[end_date_value]', [card_source_value], '[card_no_prefix_value]', [card_no_length_value], [need_password_value], [show_price_value], [pay_type_value], [can_give_value], [fixed_price_value], [discount_value], [not_small_change_value], [extra_info_value], '[extra_info_content_value]', [extra_must_value], '[batch_notes_value]', '[card_name_value]', [card_type_value], [item_id_value], [template_id_value], '[use_store_ids_value]', [designate_type_value], '[store_id_value]', '[create_by_value]', '[update_by_value]', '[create_time_value]', '[update_time_value]', [start_no_value], [end_no_value]);
请将 [xxx_value] 替换为具体的值。