Tutorials

How to Select Only Rows With Max Value On A Column in SQL?

by

In this post, we will learn how to SQL select only rows with max value on a column which we can perform using two different methods, Using subquery and self- join, Which we will discuss here one by one with examples of code( Commands). Different Ways to Get Max Values There are different ways to … Read more

When to Use Single Quotes, Double Quotes, and Backticks in MySQL

by

In this post, we will get to know When to use single quotes , double quotes, and backticks in MySQL there are these three types of quotes in MySQL that we use for enclosing the strings at different parts of the time when we need here we will learn the different uses of each quote … Read more

Which MySQL Data Type To Use For Storing Boolean Values?

by

In this tutorial, we will find Which MySQL Data Type To Use For Storing Boolean Values MySQL does not have any such kind of data type as Boolean but we make int as TINYINT to store only two values that are zero or one where zero means false and one means true. DataTypes In MySQL … Read more

Database | How Do I quickly Rename A MySQL Database?

by

Here we will know How Do I quickly Rename A MySQL Database where we know we can not rename the existing database but we can put the whole data in the new database and we can put the name of the new database as per our choice, Which indirectly renaming the database. Steps To Rename … Read more

Insert Into A MySQL Table Or Update If Exists

by

In this tutorial we will learn Insert Into A MySQL Table Or Update If Exists there is a command to insert the data in a table that is insert into table and to update the table we use update command to update it. Insert A New Record In to Table Insert is a command which … Read more

What Are Primary Key And How It Is Different From Other?

by

In this tutorial, we will learn What are Primary Key and how it is different from other keys where the primary key uniquely identifies each row in the table as it stores only a unique value for each record. Primary Key As we know to identify someone around tons of things we need a unique … Read more

GROUP BY | How We Can Use MySQL Query GROUP BY?

by

In this tutorial, we will Find out How We Can Use MySQL Query GROUP BY as a group is used to display the result of the table in a grouped manner means grouping the same data in one set to display. Use Of GROUP BY This clause is always used with some function like sum, … Read more

How do I see all foreign keys to a table or column?

by

In this Tutorial, we will learn How to see all Foreign Keys to a table or column in MySQL a foreign key is a column or group of columns used for establishing a relation between two tables during extracting the data from two tables it provides a filter to get the data that we want. … Read more

Query | How To Select All The Possible Row By a Query?

by

Here we are going to discuss How To Select All The Possible Row By a Query where we want to display either the whole data of the table or the data of selected columns and to do so we use the select command to display such things. We can display the data of the table … Read more

How do I Change the Data Type for a column in MySQL?

by

In this tutorial we will learn How to Change the data Type for a column in MySQL As changing the datatype of any column is a making change in the definition of a table and for making changes in the definition of a table we use alter command where Alter command is used for making … Read more

%d bloggers like this: