查看方式已知至少有两种方式可以实现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:Queryselectversion_