SQL基础(五)-update2

非空约束对数据更新的影响：

mysql> update t_debt
    -> set famount=NULL
    -> where fperson='Tom';
1048 - Column 'famount' cannot be null
mysql> update t_debt
    -> set famount=199.99
    -> where fperson='Tom';
Query OK, 1 row affected
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from t_debt;
+---------+---------+---------+
| fnumber | famount | fperson |
+---------+---------+---------+
| 1       | 200     | Jim     |
| 2       | 300     | Jim     |
| 3       | 199.99  | Tom     |
+---------+---------+---------+
3 rows in set

主键约束对数据更新的影响：

mysql> update t_debt
    -> set fnumber='2'
    -> where fperson='Tom';
1062 - Duplicate entry '2' for key 'PRIMARY'
mysql> update t_debt
    -> set fnu