MySQL关于UPDATE操作语句的问题

新建一个表:

+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name    | varchar(10) | YES  |     | NULL    |       |
| age     | int         | YES  |     | NULL    |       |
| sex     | char(1)     | YES  |     | NULL    |       |
| bobbies | char(10)    | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+

使用UPDATE语句:

UPDATE tb_test SET hobbies = "CODING" WHERE hobbies IS NULL;

此时报错:Unknown column 'hobbies' in 'where clause'
为什么呢?

单词拼写错误啦! 表里打成bobby了 粗心的小问题