INSERT INTO `mydbuser`.`mytable`(`col_id`, `row_id`, `col_name`, `col_seq`, `col_def_id`, `is_constant`, `constant_value`, `col_length`, `is_left_align`, `append_char`, `inserted_time`, `inserted_by`, `updated_time`, `updated_by`) VALUES (1, 1, '委托日期', 1, 6, 'Y', '委托日期', 20, 'Y', '', '2019-04-15 17:18:00', '400', '2019-04-15 17:18:00', '400');
INSERT INTO `mydbuser`.`mytable`(`col_id`, `row_id`, `col_name`, `col_seq`, `col_def_id`, `is_constant`, `constant_value`, `col_length`, `is_left_align`, `append_char`, `inserted_time`, `inserted_by`, `updated_time`, `updated_by`) VALUES (2, 1, '客户编号', 2, 6, 'Y', '客户编号', 20, 'Y', '', '2019-04-15 17:18:00', '400', '2019-04-15 17:18:00', '400');
INSERT INTO `mydbuser`.`mytable`(`col_id`, `row_id`, `col_name`, `col_seq`, `col_def_id`, `is_constant`, `constant_value`, `col_length`, `is_left_align`, `append_char`,
INSERT INTO `mydbuser`.`t_trans_column_def`(`col_def_id`, `col_def_code`, `col_name`, `ref_function`, `create_desc`, `inserted_time`, `inserted_by`, `updated_time`, `updated_by`) VALUES (1, 'AMOUNT_DECIMAL', '有小数点的金额', 'fetchAmount', '有小数点的金额', '2022-03-11 10:19:22', 'aaaaaaa', '2022-03-11 10:19:22', 'aaaaaaa');
INSERT INTO `mydbuser`.`t_trans_column_def`(`col_def_id`, `col_def_code`, `col_name`, `ref_function`, `create_desc`, `inserted_time`, `inserted_by`, `updated_time`, `updated_by`) VALUES (2, 'DATE_YYYY_MM_DD', '时间:yyyy-mm-dd', 'fetchCurrentDateWithYYYYDDMM', '时间:yyyy-mm-dd', '2022-03-11 10:19:22', 'aaaaaaa', '2022-03-11 10:19:22', 'aaaaaaa');
Mysql 插入脚本
于 2022-03-16 07:30:10 首次发布