Practical solutions

MySQL Howtos How-To Guides

Solve the problem. Keep building. Collection of MySQL how-to articles

Find the answer you need

Browse practical solutions, grouped by the task you're working on.

__COUNT__ entries on this page

MySQL QueryHow to Rename a Column in MySQL DatabaseThis tutorial demonstrates how to rename a column in a MySQL database. MySQLHow to Delete Duplicate Rows in MySQLThis article demonstrates delete duplicate rows in MySQL. MySQL TableHow to Create a Temporary Table in MySQLThis tutorial demonstrates how to create a temporary table in a MySQL database. MySQLHow to Count Distinct Values in MySQLThis tutorial demonstrates how to count distinct values in a MySQL database. MySQLHow to Compare Two Dates in MySQLThis article demonstrates different way of Comparing Two Dates in MySQL. SQL QueryHow to Use Boolean Data Type in MySQLThis tutorial demonstrates how to use boolean data type in SQL. MySQL InsertHow to Insert Bulk Values in MySQLThis tutorial demonstrates how to insert bulk values in MySQL. MySQL GroupbyHow to Group by Multiple Columns in MySQLThis tutorial demonstrates how to group by multiple columns in MySQL. MySQL JoinHow to Execute Multiple Joins in One Query in MYSQLThis tutorial shows how to incorporate multiple joins in one query in MySQL; be it inner or outer ones. We also show different methods to define the join conditions. MySQL TableHow to Copy a Table in MySQLThis tutorial demonstrates how to create a copy of a table in a MySQL database. MySQL ROWHow to Use of Row_Number() Function in MySQLThis tutorial teaches the way of making replica of SQL Server ROW_Number() Function in mysql. MySQL TableHow to Rename a Table in MySQLThis tutorial demonstrates how to rename a table in MySQL database. MySQL IntegerHow to Round Down to the Nearest Integer in MySQLThis tutorial demonstrates how to round down to the nearest integer in a MySQL database. MySQL StringHow to Replace a String in MySQLThis tutorial demonstrates how to replace a string in a MySQL database. MySQLHow to Load Data INFILE in MySQLThis tutorial demonstrates how to import data from CSV using data INFILE in MySQL database. MySQL QueryHow to Get Column Names in MySQLThis tutorial demonstrates how to get all the column names in a MySQL database. MySQL MysqldHow to Stop MysqldThis tutorial guides you about what mysqld is and how can you stop it in a Windows and Linux operating systems. MySQL PHPHow to Loop PHP MySQLi Fetch Array FunctionThis tutorial guides you about php mysqli_fetch_array() function and represents how can you iterate over mysqli query. MySQL DataHow to Copy Data From One Database to Another in MySQLThis 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' information. MySQL MULHow to MUL vs PRI vs UNI in MySQLThis tutorial guides you about the difference between MUL, PRI, and UNI keys in MySQL. It also highlights the use of each of them. MySQL ErrorHow to Display Errors Using MySQLi Error FunctionsHow to display errors using MySQLi query in different ways. MySQL SelectHow to Select Unique Values in MySQLThis tutorial demonstrates how to find unique values in a MySQL database. MySQL QueryHow to INSERT IF NOT EXISTS in MySQLThis tutorial demonstrates how to insert if certain values do not exist in the column of a table using in MySQL database. MySQL QueryHow to Group by Month in MySQLThis tutorial demonstrates how to group values by month in a MySQL database.