MYSQL

Hello There!In order to enable UTF-8 encoding on spring boot application, using VS code, follow these steps, Add below code in application.xml/yml server: port: 8022 servlet: context-path: /CMNRFQ encoding: charset:…

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…

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,…

Subqueries are used to get values from multiple tables in a single query, based on conditions. We can also combine these subqueries with case statements like the exmaple below. Example…

MYSQL connection_control plugin installation on windows INSTALL PLUGIN CONNECTION_CONTROL SONAME 'connection_control.dll'; INSTALL PLUGIN CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS SONAME 'connection_control.dll'; Replace .dll with .so for non windows SHOW VARIABLES LIKE '%connection_control_%' These are the…