24 | | - Work around some of MySQL "features" like this one : |
25 | | |
26 | | --- CUT --- |
27 | | mysql> SELECT datelimit FROM userpquota WHERE userid=1 AND printerid=1; |
28 | | +---------------------+ |
29 | | | datelimit | |
30 | | +---------------------+ |
31 | | | 2006-05-31 16:20:03 | |
32 | | +---------------------+ |
33 | | 1 row in set (0.00 sec) |
34 | | |
35 | | mysql> UPDATE userpquota SET datelimit=NULL WHERE userid=1 AND printerid=1; |
36 | | Query OK, 1 row affected (0.05 sec) |
37 | | Rows matched: 1 Changed: 1 Warnings: 0 |
38 | | |
39 | | mysql> SELECT datelimit FROM userpquota WHERE userid=1 AND printerid=1; |
40 | | +---------------------+ |
41 | | | datelimit | |
42 | | +---------------------+ |
43 | | | 2006-05-31 16:27:45 | |
44 | | +---------------------+ |
45 | | 1 row in set (0.00 sec) |
46 | | |
47 | | mysql> |
48 | | --- CUT --- |
49 | | |