UPDATE tables
SET properties = ‘{“number_of_partitions”: “16”,“enabled_full_index_table”: “false”}’
WHERE
id IN (SELECT id FROM( SELECT id FROM tables WHERE locate( ‘enabled_full_index_table’, properties )= 0 ) as t)
记录sql 查询字符串是否有指定key
UPDATE tables
SET properties = ‘{“number_of_partitions”: “16”,“enabled_full_index_table”: “false”}’
WHERE
id IN (SELECT id FROM( SELECT id FROM tables WHERE locate( ‘enabled_full_index_table’, properties )= 0 ) as t)
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
