MySQL

How-tos How to Stop Mysqld This tutorial guides you about what mysqld is and how can you stop it in a Windows and Linux operating systems. ↗ How-tos How to Loop PHP MySQLi Fetch Array Function This tutorial guides you about php mysqli_fetch_array() function and represents how can you iterate over mysqli query. ↗ How-tos How to Copy Data From One Database to Another in MySQL This tutorial guides you about how can you copy data from one database to another having the same user's information, and from MySQL to MS SQL Server having different users' … ↗ How-tos How to MUL vs PRI vs UNI in MySQL This tutorial guides you about the difference between MUL, PRI, and UNI keys in MySQL. It also highlights the use of each of them. ↗ How-tos How to Select Unique Values in MySQL This tutorial demonstrates how to find unique values in a MySQL database. ↗ How-tos How to Group by Month in MySQL This tutorial demonstrates how to group values by month in a MySQL database. ↗ How-tos The For Loop in MySQL This tutorial demonstrates how to use for loop in the MySQL database. ↗ How-tos How to Select Most Recent Record in MySQL This tutorial demonstrates how to select the most recent record in MySQL. ↗ How-tos How to Join 3 Tables in MySQL This tutorial demonstrates how to join three tables in a MySQL database. ↗ How-tos How to Full Join in MySQL This article demonstrates how to make a full join in MySQL. ↗ How-tos How to Decimal Values in MySQL This tutorial demonstrates how to use decimal point values in MySQL. ↗ How-tos How to Update Table From Another Table in MySQL This tutorial demonstrates how to update a MySQL table based on entries from another table. ↗ How-tos How to Unblock With Mysqladmin Flush Hosts in MySQL You will learn about the the reasons of blocking a host. Also, different methods and effects of unblocking via flushing the host cache using phpMyAdmin and command prompt. ↗ How-tos How to Select Top N Rows in MySQL In this article, we will learn how to select top n rows in MySQL using LIMIT clause. We will also see how to select top n rows and top rows from m to n. ↗ How-tos How to Delete All Rows in MySQL Database Using phpMyAdmin In this guide, we will learn about the best ways to delete all rows from MySQL database using phpMyAdmin. ↗ How-tos How to Insert With Select in MySQL This article introduces how to insert with select in MySQL. ↗ How-tos How to Convert String to Date Format in MySQL We will learn about how to convert a string value to DATE type value using STR_TO_DATE(), CONVERT(), and CAST() functions in MySQL. ↗ How-tos How to Delete a Column From a Table in MySQL This tutorial demonstrates how to delete a column from a table in MySQL. ↗ How-tos How to ORDER BY RAND in MySQL This tutorial demonstrates how to sort values randomly in MySQL. ↗ How-tos How to Fetch Random Values in MySQL This tutorial demonstrates how to quickly fetch random values with a limit in MySQL. ↗ How-tos How to Use LIKE in Case-Insensitive Search This tutorial demonstrates how to use LIKE for a case-insensitive search. ↗ How-tos How to Sort by Date in MySQL This tutorial demonstrates how to sort values by date in MySQL. ↗ How-tos How to Select Only Not Null Values in MySQL This tutorial demonstrates how to filter null values in MySQL. ↗ How-tos How to Drop Multiple Tables in MySQL This tutorial demonstrates how to drop multiple tables in MySQL. ↗