All pastes #919366 Raw Edit

Unnamed

public sql v1 · immutable
#919366 ·published 2008-02-26 19:44 UTC
rendered paste body
mysql> describe konline;+--------+------------------+------+-----+---------+-------+| Field  | Type             | Null | Key | Default | Extra |+--------+------------------+------+-----+---------+-------+| sid    | varchar(50)      | NO   | PRI |         |       || uid    | int(11)          | YES  | UNI | NULL    |       || cc     | varchar(3)       | NO   |     |         |       || vreme  | int(10) unsigned | NO   |     |         |       || strana | varchar(15)      | NO   |     |         |       || ipadr  | varchar(15)      | NO   |     |         |       || uagent | char(90)         | YES  |     | NULL    |       |+--------+------------------+------+-----+---------+-------+7 rows in set (0.06 sec)LOG:# Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0SET timestamp=1204052459;update konline set vreme = unix_timestamp() where sid = 'qnkp6m9i57o759egmm49p8eb10';# User@Host: sql_wbrod[sql_wbrod] @ localhost []# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0SET timestamp=1204052459;update konline set vreme = unix_timestamp() where sid = 'aku43lpcnv5ck9hrm09fefi8h4';# User@Host: sql_wbrod[sql_wbrod] @ localhost []# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0SET timestamp=1204052459;update konline set vreme = UNIX_TIMESTAMP(), strana = 'index' where sid = 'e2o913t58u112jig1ef81p4541';# User@Host: sql_wbrod[sql_wbrod] @ localhost []# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0SET timestamp=1204052459;update konline set vreme = unix_timestamp() where sid = 'okapkpkc3lnkabgnrokgr80tt1';