mysql general log example

gistfile1.txt

mysql> select * from general_log;
+---------------------+---------------------------+-----------+-----------+--------------+-------------------------------------+
| event_time          | user_host                 | thread_id | server_id | command_type | argument                            |
+---------------------+---------------------------+-----------+-----------+--------------+-------------------------------------+
| 2013-07-08 10:27:30 | root[root] @ localhost [] |        37 |         0 | Query        | create table databasea (id integer) |
| 2013-07-08 10:27:35 | root[root] @ localhost [] |        37 |         0 | Query        | insert into databasea values (1)    |
| 2013-07-08 10:27:36 | root[root] @ localhost [] |        37 |         0 | Query        | insert into databasea values (2)    |
| 2013-07-08 10:27:37 | root[root] @ localhost [] |        37 |         0 | Query        | insert into databasea values (3)    |
| 2013-07-08 10:27:38 | root[root] @ localhost [] |        37 |         0 | Query        | insert into databasea values (4)    |
| 2013-07-08 10:27:43 | root[root] @ localhost [] |        37 |         0 | Query        | select * from databasea             |
| 2013-07-08 10:27:50 | root[root] @ localhost [] |        37 |         0 | Query        | drop table databasea                |
| 2013-07-08 10:27:52 | root[root] @ localhost [] |        37 |         0 | Query        | set global general_log = off        |
+---------------------+---------------------------+-----------+-----------+--------------+-------------------------------------+