In this article, we will learn about how to get random records from the database table in MySQL. In MySQL, there is no built-in function to retrieve the random records. In order to achieve this, you can use the ORDER BY RAND() clause in your SQL query.
Read More..In this article, you will learn how to drop or delete a single column or multiple columns from an existing table in MySQL. Sometimes, you need to remove a single or multiple unused or obsolete column from an existing table.
Read More..In this article, you will learn how to add or subtract years, months, weeks, days, hours, minutes, seconds, microseconds to a DateTime in MySQL. DateTime manipulation is the most common scenario is when we fetching data from the database or storing data in a database. Here, we used the MySQL built-in DateTime functions: ADDDATE(), DATE_ADD(), DATE_SUB(), and add and subtract dates without using any built-in function.
Read More..In this article, you will learn how to calculate total no. of days between two specific dates using the DATEDIFF function in MySQL. To get a total no. of days between two specific dates, we use the DATEDIFF function of MySQL.
Read More..In this article, we will learn how to get a list of all the databases in MySQL.
Read More..In this article, we will learn how to how to get a list of all the table names of a particular database by using a query in MySQL. There are two ways to find all table names present in a specific database by using the following Show tables or metadata tables commands in MySQL.
Read More..In this article, we will learn how to convert UTC to the local timezone in MySQL. When we are working with the big database, it is important to manage the default database time zone. MySQL does not store time zone information when storing timestamps. It also uses the host server time as the basis for generating the output of NOW() function.
Read More..In this article, we will learn about how to deal with date and time in MySQL. In MySQL, it supports a bunch of date and time utility functions that we can use to handle DATE and TIME efficiently.
Read More..In this article, we will learn How to get the First Day and the Last Day of the Month in MySQL.
Read More..