mysql 查询参数不存在表

mysql 查询参数不存在表

8.0以上版本

SELECT
	jt.* 
FROM
	JSON_TABLE ( '["LC222017",
		"K9357",
		"21B11SS131",
		"99110",
		"804",
		"10",
		"4",
	"2"]', '$[*]' COLUMNS ( supplier_styles_code VARCHAR ( 100 ) PATH '$' DEFAULT '111' ON EMPTY DEFAULT '999' ON ERROR ) ) AS jt
	LEFT JOIN goods_selection_spu spu ON jt.supplier_styles_code = spu.supplier_styles_code 
WHERE
	spu.selection_spu_id IS NULL;