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…
Posted inSPRING BOOT

HITTING URL AND READING JSON RESPONSE IN JAVA

In this example, we going to hit a URL and read its response String urlString = "http://gd.geobytes.com/GetCityDetails"; URL url = new URL(urlString); BufferedReader reader = new BufferedReader(new InputStreamReader(url.openStream())); //or url.getContent();…