UPDATE VIDEO_VIO_VIODATASET sbbh = SELECT sbbm FROM busi_device ORDER BY RAND LIMIT 1;报错 缺失右括号
请将查询语句括号右边的分号移到括号外部,如下所示:
UPDATE VIDEO_VIO_VIODATA SET sbbh = ( SELECT sbbm FROM busi_device ORDER BY RAND() LIMIT 1 );
原文地址: https://www.cveoy.top/t/topic/iQFr 著作权归作者所有。请勿转载和采集!