Change Mysql password.

  We all have worked in Mysql with the default username ‘root’ and password ‘root’ but we should not keep our Mysql password to default as its insecure. I am here with a blog which helps you change the password of Mysql with minimal steps...

Power of Liquibase

Hi Guys! I am back with a new blog post titled “Power of Liquibase”. This post is meant for those who have a basic idea of using Liquibase. As we know that Liquibase is used to keep a track of the changes that we apply to the database. It not only keeps a...

Liquibase Basics

Liquibase is an open source technology for tracking, managing and applying database schema changes. All changes to the database are stored in XML files in the form of change-sets and is identified by a combination of an “id” and “author” tag....

Create-A-New-User-In-MySQL

In general, We did all of the editing in MySQL as the root user, with full access to all of the databases. However, in the cases where more restrictions may be required, there are ways to create users with custom permissions. Let’s start by making a new user within...

Transaction isolation levels in database

I was recently studying about transaction isolation levels in database. First of all, let us see the definition of transaction isolation level. Definition: Every transaction specify an isolation level that defines the level at which one transaction must be isolated...

Configure MYSQL as case insensitive on Linux

Few months back I was working on a task in which I had to construct few SQL queries to fetch specific data and display on the GSP pages. I fired few queries(table names were given in lower case) but it failed. It showed an error that there is no such table with the...

Date manipulation using SQL query

I have written some useful query. When you need some customization in date format and find some prior date using SQL then below query might be useful for you. Find prior/future date from the current/given date: SELECT now()::date + 2 AS date1, current_date -1 AS date2...

Custom sorting in sql

Order by with a particular value on TOP or Custom sorting in order by clause. ORDER clause can be used to sort the results returned by SELECT statement in SQL Server. It orders the result set by specified column list. When used with character data type columns it...

Using SQLFiddle

Hi Guys, this is my second blog post of this month. The title is “Using SQLFiddle”. In this post I am going to explain about a very useful online tool SQLFiddle which I have been using for a while. As JSFiddle is used to run and test CSS, JQuery etc, using...