56,679
社区成员
发帖
与我相关
我的任务
分享
mysql> select * from t5 where id=20;
+------+---------------+
| id | c1 |
+------+---------------+
| 20 | http://123123 |
+------+---------------+
1 row in set (0.00 sec)
mysql> update t5 set c1=null where id=20;
Query OK, 1 row affected (0.16 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from t5 where id=20;
+------+------+
| id | c1 |
+------+------+
| 20 | NULL |
+------+------+
1 row in set (0.00 sec)
mysql>