1 2 3 4 5 6 7 8 9 10 11 12 13
| mysql> update ecg set id_client=null where id_ecg=3;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from ecg;
+--------+-----------+-----------+-----------+-----------------+----------------------------------+--------------+--------------+---------------------+--------+
| id_ecg | id_pharma | id_cardio | id_client | id_boitier | fichier | diagnostic | diagnostique | date | valide |
+--------+-----------+-----------+-----------+-----------------+----------------------------------+--------------+--------------+---------------------+--------+
| 1 | 1 | 1 | 1 | 0000100-1109-08 | 0000100-1109-08_161208102703.pdf | | 0 | 2008-12-22 18:46:00 | 0 |
| 2 | 1 | 4 | 1 | 0000100-1109-08 | 0000100-1109-08_161208102703.pdf | | 0 | 2008-12-23 16:24:12 | 0 |
| 3 | 1 | NULL | NULL | 0000100-1109-08 | 0000100-1109-08_161208102703.pdf | zazazazazaza | 0 | 2008-12-24 10:14:55 | 0 |
+--------+-----------+-----------+-----------+-----------------+----------------------------------+--------------+--------------+---------------------+--------+
3 rows in set (0.00 sec) |