版本: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
求大神指点,大概要替换20W条数据