SQL批量替换字段名问题
shugu4
中国
版本：Navicat Premium 12描述：在查询界面update [ABC] set sex = replace(sex,'男','1')后报错，sex字段名为varchar类型。报错信息：update [ABC] set sex = replace(sex,'男','1')1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[ ABC]set sex = replace(sex,'男','1')' at line 1时间: 0s
回答数
3
浏览数
1270
2018-11-28 18:14:24
