how to check history of database in phpmyadmin code example

Example 1: how to check history of database in phpmyadmin

To view the past queries simply run this query in phpMyAdmin.

SELECT * FROM `general_log`
if it is not enabled, run the following two queries before running it.

SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';

Example 2: how to check history of database in phpmyadmin

To view the past queries simply run this query in phpMyAdmin.

SELECT * FROM `general_log`
if it is not enabled, run the following two queries before running it.

SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';

Tags:

Sql Example