/** matrix 自动添加库注释:库名:hbos_basedata */ --中山执行 INSERT INTO hbos_basedata.dic_config_param_value (id, customer_code, category_id, category_code, param_code, param_name, param_type, param_value, param_desc, status, is_deleted, create_by, create_time, update_by, update_time) VALUES ((select max(id) + 1 from dic_config_param_value a), 'Hbos.Emergency.Treatment.GeneralTreatment@20012004#30061002', null, 'HP00007', 'submitBeanName', '急诊普通治疗数字化(提交)', 'String', 'doctorOrderDigitalServiceImpl', '', 1, 0, -1, '2022-12-13 11:27:51', -1, '2022-12-23 11:27:51'); INSERT INTO hbos_basedata.dic_config_param_value (id, customer_code, category_id, category_code, param_code, param_name, param_type, param_value, param_desc, status, is_deleted, create_by, create_time, update_by, update_time) VALUES ((select max(id) + 1 from dic_config_param_value a), 'Hbos.Outpatient.Treatment.GeneralTreatment@20012004#30061002', null, 'HP00007', 'submitBeanName', '门诊普通治疗数字化(提交)-口腔科门诊', 'String', 'doctorOrderDigitalServiceImpl', '', 1, 0, -1, '2022-12-13 11:27:51', -1, '2022-12-23 11:27:51');
时间: 2024-04-15 17:25:27 浏览: 139
这是两条 SQL 语句用于向 `hbos_basedata.dic_config_param_value` 表中插入数据。
第一条语句插入了一条记录,其中包含了以下字段的值:
- `id`:根据已有数据的最大 `id` 值加 1 生成
- `customer_code`:'Hbos.Emergency.Treatment.GeneralTreatment@20012004#30061002'
- `category_id`:null
- `category_code`:'HP00007'
- `param_code`:'submitBeanName'
- `param_name`:'急诊普通治疗数字化(提交)'
- `param_type`:'String'
- `param_value`:'doctorOrderDigitalServiceImpl'
- `param_desc`:''
- `status`:1
- `is_deleted`:0
- `create_by`:-1
- `create_time`:'2022-12-13 11:27:51'
- `update_by`:-1
- `update_time`:'2022-12-23 11:27:51'
第二条语句插入了另一条记录,字段值与第一条类似,只有部分字段不同。
这两条语句将数据插入了名为 `hbos_basedata.dic_config_param_value` 的表中。
阅读全文