The first SQL statement seems to have no syntax error. However, the second SQL statement has a syntax error because "group" is a reserved keyword in MySQL and should be enclosed in backticks (`) or renamed to a different column name.

Here's the corrected SQL statement:

UPDATE pano_pano_fenzu SET parent = 'child', group = id, name = '默认分组', pano_id = pano_id, sort = 0 WHERE parent = 'top';

UPDATE pano_pano_fenzu SET parent = top group = 0;UPDATE pano_pano_fenzu SET parent = childgroup = idname = 默认分组pano_id = pano_idsort = 0 WHERE parent = top; 提示#1064 - You have an error in your SQL sy

原文地址: https://www.cveoy.top/t/topic/HfF 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录