Posted inMYSQL
Change date format in MYSQL
Sometimes the situation may demand to change the MYSQL date format, when we are using select query. MYSQL has builtin functions for this purpose, take a look at example below…
Posted inMYSQL
How to kill all mysql process
Use the below query to get all the process SELECT CONCAT('KILL ',id,';') AS run_this FROM information_schema.processlist WHERE user='your database username' Here replace 'your database username' with your actual database username,…