How to update table set column = null where column = '\' without error of MySQL server ve-CodePudding

Home > Back-end > How to update table set column = null where column = '\' without error of MySQL server ve

How to update table set column = null where column = '\' without error of MySQL server ve

Time：10-01

How to update table set column = null where column = \ in mysql?

I always got error of 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 ''\'' at line 1

CodePudding user response：

You should use '\\' 


update students set firstname = null where firstname = '\\'

Page link：https//www.codepudding.com/Backend/134478.html

Prev:Insert value from B table to A table which not duplicate in mysql

Next:Sql query select by parent id [duplicate]

Tags：

mysql

Links：
CodePudding