Posts with the tag Database:

Where Clause vs Having Clause in SQL

In this blog post, we will see the differences between the condition applied in the where clause and the having clause.

Read More ...

How to get the current time in MySQL

How to get the Current Server Time in MySQL

In this blog post, we will see how to get the current server time in the MySQL session.

Read More ...

How to get the Grant Details

How to get the Grant Details in MySQL

In this blog post, we will see how to get the privileges granted for a particular user, or the currently logged in user with the MySQL Database.

A proper way to verify the privileges granted or revoked to an user, is a good practice for all the authorization activities.

Read More ...

How to get the Current User Details

How to Get the Current User Details in MySQL

In this blog post, we will see the different ways we can get the currently logged in user in the MySQL Client inside the MySQL Session.

It is good to verify the currently logged in user details with the host name, for certain authentication and authorization purposes.

Read More ...