Posts with the tag Database:

Grokking SQL Interview by Javin Paul

Grokking the SQL Interview by Javin Paul

🎁⏰ Grokking the SQL Interview Launch Sale Ending in 2 Days !!

Hello there,

Just wanted to send a gentle reminder that the launch sale of my friend Javin Paul’s new book, Grokking the SQL Interview is ending soon. It is a special link with the offer code friends50 for 50% already applied in it.

Read More ...

Assign Grant Priviliges to an User in MySQL

Assign Grant Priviliges to an User in MySQL Database

In this post, we will see how do we assign the Grant Privileges to a particular user, without which it is very difficult to assign a grant to an another user, and we need to always be dependent on the root user or the DBA.

Read More ...

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 ...