mpneuried
7/19/2013 - 6:11 AM

SQL HELPERS :: SQL commands i allways have to search for

SQL HELPERS :: SQL commands i allways have to search for

helpers.sql
content_copyfile_download
/* activate global logging and the logfile path*/
SET GLOBAL general_log = 'ON';
SET GLOBAL general_log_file = '/Users/mathiaspeter/logs/mysql_general.log';

/* deactivate global logging */
SET GLOBAL general_log = 'OFF';

/* show variables  */
SHOW GLOBAL VARIABLES like '%log%';

/* benchmark a sql query  */
SELECT BENCHMARK(100000,(
	SELECT 1
))