mysql: momentarily enable general log file / table

mysql-momentary-general-log.sql

# mysql: momentarily enable, then view, general log table
SET GLOBAL log_output = 'TABLE';

SET GLOBAL general_log = 'ON';
SELECT SLEEP(5);
SET GLOBAL general_log = 'OFF';

SELECT * FROM mysql.general_log;

######
# OR #
######

# mysql: momentarily enable general log file

SET GLOBAL log_output = "FILE"; // default
SET GLOBAL general_log_file = "/var/log/mysql-general.log";

SET GLOBAL general_log = 'ON';
SELECT SLEEP(5);
SET GLOBAL general_log = 'OFF';

# original: http://stackoverflow.com/questions/650238/how-to-show-the-last-queries-executed-on-mysql