同事寫了一個(gè) update，誤用一個(gè)雙引號(hào)，生產(chǎn)數(shù)據(jù)全變 0 了！

一、前言

二、過(guò)程

update?tablename?set?source_name?=?"bj1062-北京市朝陽(yáng)區(qū)常營(yíng)北辰福第"???????????where?source_name?=?????"-北京市朝陽(yáng)區(qū)常營(yíng)北辰福第"

Harvey，我執(zhí)行了update，where條件都是對(duì)的，set的值也是對(duì)的，但是set后的字段全部都變成了0，你趕緊幫我看看，看看能不能恢復(fù)數(shù)據(jù)。

update?tbl_name?set?str_col="xxx"?=?"yyy"

update?tbl_name?set?(str_col="xxx"?)=?"yyy"

update?tbl_name?set?str_col=("xxx"?=?"yyy")

select?"xxx"?=?"yyy"

update?tbl_name?set?str_col="xxx"?=?"yyy"

update?tbl_name?set?str_col=0

mysql?[localhost]?{msandbox}?(test)?>?select?id,str_col?from?tbl_name?where?str_col="xxx"?=?"yyy";
+----+---------+
|?id?|?str_col?|
+----+---------+
|??1?|?aaa?????|
|??2?|?aaa?????|
|??3?|?aaa?????|
|??4?|?aaa?????|
+----+---------+

mysql?[localhost]?{msandbox}?(test)?>?warnings
Show?warnings?enabled.
mysql?[localhost]?{msandbox}?(test)?>?explain?extended?select?id,str_col?from?tbl_name?where?str_col="xxx"?=?"yyy"\G
***************************?1.?row?***************************
???????????id:?1
??select_type:?SIMPLE
????????table:?tbl_name
?????????type:?index
possible_keys:?NULL
??????????key:?idx_str
??????key_len:?33
??????????ref:?NULL
?????????rows:?4
?????filtered:?100.00
????????Extra:?Using?where;?Using?index
1?row?in?set,?1?warning?(0.00?sec)

Note?(Code?1003):?/*?select#1?*/?select?`test`.`tbl_name`.`id`?AS?`id`,`test`.`tbl_name`.`str_col`?AS?`str_col`?from?`test`.`tbl_name`?where?((`test`.`tbl_name`.`str_col`?=?'xxx')?=?'yyy')

((`test`.`tbl_name`.`str_col`?=?'xxx')?=?'yyy')

mysql?[localhost]?{msandbox}?(test)?>?select?'yyy'+0.0;
+-----------+
|?'yyy'+0.0?|
+-----------+
|?????????0?|
+-----------+

1?row?in?set,?1?warning?(0.00?sec)

mysql?[localhost]?{msandbox}?(test)?>?select?0=0;
+-----+
|?0=0?|
+-----+
|???1?|
+-----+
1?row?in?set?(0.00?sec)

?select?id,str_col?from?tbl_name?where?1=1;

三、小結(jié)

點(diǎn)贊是最大的支持?