In Operator allows to specify multiple values in where clauseSELECT *FROM booksWHERE ISBN IN (123456, 456789, ...);It also smart enough to support nested queries as well,SELECT *FROM bo… Read More

It is often required to investigate the queries executed on MySQL Server Log for many reasons when debugging.Specially it allows to see the values passed in for the parameters for… Read More

Sonar IssueViolation : Explicitly Import the Specific Classes NeededRule : Wildcard imports should not be usedIntelliJ IDEA Menu NavigationSettings > Editor > Code Style > Java >… Read More

Define the variable and set it in the server,SET @country = 'Sri Lanka';SET @section = 'Science Fiction';Now you can write the query with placeholders,SELECT book_name, isbn_number, author_i… Read More

Cmder - Portable console emulator for WindowsLooking for a nice console emulator on Windows ?Cmder is a software package created out of pure frustration over the absence of nice co… Read More

Replace All Spaces in a Stringtrim()Removes only the leading & trailing spaces.From Java Doc,"Returns a string whose value is this string, with any leading and trailing whitesp… Read More

Exclude Third Party Sources from SonarProject Level ConfigurationThe easiest and the cleanest way to make an exclusion of source files from Sonar scanning is from sonar-project.pro… Read More

Apache Tomcat as a Windows Service & Configure for Remote DebuggingDownload Apache TomcatGo directly to the Apache Tomcat Site, select the version you prefer for download . Select&n&hell…Read More

Multiple Log Files View in a Single Consoletail Multiple Log Files in to a Single Linux Console  You may already know that it is possible to view a log file in Linux by tail comman… Read More

Tail Multiple Log Files in to a Single Linux Console  You may already know that it is possible to view a log file in Linux by tail command.tail command allows to display… Read More