You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
13 lines
388 B
13 lines
388 B
SELECT
|
|
t1.`dict_id` AS `dict_id`,
|
|
t1.`dict_kind` AS `dict_kind`,
|
|
t1.`dict_code` AS `dict_code`,
|
|
t1.`dict_value` AS `dict_value`,
|
|
t1.`dict_remark` AS `dict_remark`,
|
|
t1.`dict_parent` AS `dict_parent`,
|
|
t1.`sort_id` AS `sort_id`,
|
|
cast( t1.`b_use` AS signed ) AS `b_use`,
|
|
'-1' as bureau_id,
|
|
case t1.`b_use` when -2 then 1 else 0 end AS `del_flag`
|
|
FROM
|
|
`t_sys_dict` as t1 |