Changeset 2902 for pykota/trunk

Show
Ignore:
Timestamp:
05/31/06 16:39:57 (18 years ago)
Author:
jerome
Message:

Added a note about MySQL "features".

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • pykota/trunk/TODO

    r2897 r2902  
    2222TODO, in no particular order : 
    2323         
     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           
    2450        - Add a pkrefund command line tool & optional CGI script. 
    2551