注意 sql update的语法啊 已经被这个问题纠结过N次了, 每次都搞得头晕眼花
update sex_person set sex = '男' and keywords = '刚' where name like '%刚' AND LENGTH(NAME) < 10; // error
不能用and啊
update sex_person set sex = '男' , keywords = '刚' where name like '%刚' AND LENGTH(NAME) < 10;
Truncated incorrect DOUBLE value: '男'