Skip to content

Category Archives: SQL

There might arise a situation where you need to reset the root password for your MySQL database.  It can be because you forgot your password… Read More
Prerequisite – Power BI The main goal of power BI is to build the dashboard and to keep the data up to date and make… Read More
1.What do you understand by Adaptive query processing launched in SQL Server? Answer: SQL Server and Azure SQL Database introduce a new generation of query… Read More
Structured Query Language or SQL is a standard database language that is used to create, maintain, destroy, update and retrieve the data from relational databases… Read More
In Cassandra, CQL(Cassandra Query Language) has two partitions as follows – Single-Row Partitions Multi-Row Partitions Single-Row Partitions :In Cassandra, the primary key represents a unique… Read More
Whenever any value is passed to the variable or column of character data type, the string value has single quotes(”) around them otherwise it will… Read More
While inserting data in tables, sometimes we need to capture insert timestamp in the table. There is a very simple way that we could use… Read More
Do you know that the post you have uploaded on social media or the article you are currently reading is stored in a virtual space?… Read More
CURRENT_USER() function :This function in SQL Server is used to return the current user’s name in the database of SQL Server in use. Features :… Read More
SQL is a Structured Query Language which is a computer language for storing, manipulating, and retrieving data stored in a relational database. SQL is the… Read More
LENGTH() : This function in MySQL is used to find the string length which is of type bytes. Features : This function is used to… Read More
MySQL Date Data Type : There are various data types that are supported in MySQL. Among them sometimes we need to take DATE data type… Read More
In this age of technological advancement, Data is considered to be the new oil.  With this, there is an increase in the necessity of people… Read More
As the name suggests, the auto-commit statement is used to avoid the explicit mention of the commit command after each SQL statement. The commit statement… Read More
CASE() function in MySQL is used to find a value by passing over conditions whenever any condition satisfies the given statement otherwise it returns the… Read More