万答21,如何查看MySQL数据库一段时

查看方式已知至少有两种方式可以实现1.开启general_log就可以观察到开启命令

mysqlsetglobalgeneral_log=ON;执行一些操作

[root

mgr2~]#mysql-uGreatSQL-pGreatSQL-h..6.-Pmysqlusetest;mysqlshowtables;+----------------+

Tables_in_test

+----------------+

book

student

t1

+----------------+3rowsinset(0.01sec)mysqlselect*fromt1;+------+--------+

id

name

+------+--------+

1

哈哈

2

你好

3

呵呵

+------+--------+5rowsinset(0.00sec)mysqldeletefromtest.t1whereid=4;QueryOK,1rowaffected(0.02sec)查看general_log日志信息，已经完整记录到了。

-01-20T21:46:17.-05:ConnectGreatSQL

..6.onusingTCP/IP-01-20T21:46:17.-05:Queryselect

version_

转载请注明：http://www.aierlanlan.com/tzrz/7685.html