新建一个表:
+---------+-------------+------+-----+---------+-------+
| 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了 粗心的小问题