非空约束对数据更新的影响:
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