Columns 
MariaDB [jogrid_db]> show columns from Presence; +-----------------+--------------+------+-----+--------------------------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+-----+--------------------------------------+-----------------------------+ | UserID | varchar(255) | NO | MUL | NULL | | | RegionID | char(36) | NO | MUL | 00000000-0000-0000-0000-000000000000 | | | SessionID | char(36) | NO | PRI | 00000000-0000-0000-0000-000000000000 | | | SecureSessionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | LastSeen | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +-----------------+--------------+------+-----+--------------------------------------+-----------------------------+ 5 rows in set (0.00 sec)
Select
MariaDB [jogrid_db]> select UserID,RegionID,LastSeen from Presence; +--------------------------------------+--------------------------------------+---------------------+ | UserID | RegionID | LastSeen | +--------------------------------------+--------------------------------------+---------------------+ | 926f9d30-a751-408d-a01d-f733b3d5082f | 82c38909-6b24-4d34-bce5-9051e55cb116 | 2016-05-17 14:17:09 | | 03995f91-c73f-4407-9fb9-d1e369386400 | 25906268-f6bf-4efa-ba90-0f38e93fb503 | 2016-05-17 14:25:47 | | 0fa2fdd3-e4b7-456f-aa79-75aade09aded | d631135c-6617-491b-a3fd-bf3c1be345e0 | 2016-05-17 11:06:46 | +--------------------------------------+--------------------------------------+---------------------+ 3 rows in set (0.00 sec)
Counter: 788,
today: 1,
yesterday: 5
Last-modified: 2016-07-06 (Wed) 15:24:02 (JST) (2852d) by iseki
