Posted inMYSQL

MYSQL subquery with case statement

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…
Posted inMYSQL

MYSQL connection_control plugin installation

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…