INSERT INTO form_field ( CODE, NAME, lable, type, required, query_code, seq, OPTIONS ) SELECT
'111' CODE,
t.NAME,
t.lable,
t.type,
t.required,
t.query_code,
field( t.NAME, 'major', 'birthday', 'tel', 'm_2', 'formal', 'NAME' ) AS seq,
t.OPTIONS
FROM
form_field t
INNER JOIN (
SELECT NAME ,CODE
FROM class a
WHERE
is_del = '0'
AND type = 2
AND EXISTS ( SELECT NULL FROM class WHERE CODE IN ( 'draft.hire', 'basic' ) AND type = '0' AND a.parent_id = id )
GROUP BY
a.CODE,
a.NAME
) up ON up.CODE = t.CODE
WHERE
t.NAME IN ( 'major', 'birthday', 'tel', 'm_2', 'formal', 'NAME' )
ORDER BY
field( t.NAME, 'major', 'birthday', 'tel', 'm_2', 'formal', 'NAME' )
order by LOCATE(id,(select subj_ids from subject where uuid = ' '));
mysql 自定义排序 行号
最新推荐文章于 2024-01-11 11:36:04 发布
这段内容涉及到了SQL查询语句的使用,特别是INNER JOIN和EXISTS子句,用于从form_field和class表中筛选特定记录。ORDER BY字段的用法显示了对数据排序的需求,而LOCATE函数则可能在搜索特定ID的位置上发挥作用。整个查询似乎与数据库管理和数据检索流程相关。
摘要由CSDN通过智能技术生成