Help for this page

Select Code to Download


  1. or download this
         id        int      NOT NULL auto_increment,
         useragent char(32) NOT NULL,
    ...
         date      char(32) NOT NULL,
         useragent char(32),              -- added field for ua
         primary key  (id)
    
  2. or download this
         ...
         countdown  int  default(0),
         ...
    
  3. or download this
        UPDATE Table set countdown = countdown + 1 where useragent = ?;
    
        DELETE FROM Table WHERE countdown > 10;