需求,将uuid和p_uuid 转化成id 和parentId
mySql语句:
UPDATE node_type_data a
SET parent_id = (select type_data_id from (
SELECT
*
FROM
node_type_data
) as t WHERE t.uuid = a.p_uuid) WHERE a.parent_id = -3
需求,将uuid和p_uuid 转化成id 和parentId
mySql语句:
UPDATE node_type_data a
SET parent_id = (select type_data_id from (
SELECT
*
FROM
node_type_data
) as t WHERE t.uuid = a.p_uuid) WHERE a.parent_id = -3