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 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. MySQLHow to Get the Size of MySQL DatabaseThis tutorial demonstrates how to find the size of a MySQL database. MySQL WorkbenchHow to Create New Database in MySQL WorkbenchThis tutorial guides you about how can you create a new database using GUI options and SQL query in MySQL Workbench. 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 DatabaseHow to Search Occurrences of String in MySQL DatabaseThis tutorial guides you on how you can search a complete database to find the occurrences of a pattern or string in MySQL Workbench and phpMyAdmin. 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. MySQL QueryThe For Loop in MySQLThis tutorial demonstrates how to use for loop in the MySQL database. MySQL QueryHow to Select Most Recent Record in MySQLThis tutorial demonstrates how to select the most recent record in MySQL. MySQL JoinHow to Join 3 Tables in MySQLThis tutorial demonstrates how to join three tables in a MySQL database. MySQL QueryHow to Full Join in MySQLThis article demonstrates how to make a full join in MySQL. MySQL QueryHow to Decimal Values in MySQLThis tutorial demonstrates how to use decimal point values in MySQL. MySQL QueryHow to Update Table From Another Table in MySQLThis tutorial demonstrates how to update a MySQL table based on entries from another table.