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 HostHow to Unblock With Mysqladmin Flush Hosts in MySQLYou 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. MySQL DatabaseHow to Select Top N Rows in MySQLIn 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. MySQL WorkbenchHow to Import Excel File Into a MySQL DatabaseYou will learn about different and easiest ways to import data from excel file into MySQL database. MySQL DeleteHow to Delete All Rows in MySQL Database Using phpMyAdminIn this guide, we will learn about the best ways to delete all rows from MySQL database using phpMyAdmin. MySQL InsertHow to Insert With Select in MySQLThis article introduces how to insert with select in MySQL. MySQL DateHow to Convert String to Date Format in MySQLWe will learn about how to convert a string value to DATE type value using STR_TO_DATE(), CONVERT(), and CAST() functions in MySQL. MySQL DatabaseHow to Delete a Column From a Table in MySQLThis tutorial demonstrates how to delete a column from a table in MySQL. MySQL ResetHow to Reset Auto Increment in MySQLThis tutorial demonstrates how to reset auto increment in MySQL. MySQL ORDERHow to ORDER BY RAND in MySQLThis tutorial demonstrates how to sort values randomly in MySQL. MySQL RandomHow to Fetch Random Values in MySQLThis tutorial demonstrates how to quickly fetch random values with a limit in MySQL. MySQL SearchHow to Use LIKE in Case-Insensitive SearchThis tutorial demonstrates how to use LIKE for a case-insensitive search. MySQL QueryHow to Sort by Date in MySQLThis tutorial demonstrates how to sort values by date in MySQL. MySQL FilterHow to Select Only Not Null Values in MySQLThis tutorial demonstrates how to filter null values in MySQL. MySQL TableHow to Drop Multiple Tables in MySQLThis tutorial demonstrates how to drop multiple tables in MySQL. MySQL TimestampHow to Convert Timestamp Field to Date in Mysql QueryThis tutorial demonstrates how to convert timestamp to date in MySQL Query. MySQL INSERTHow to Insert Value in MySQL Table With Duplicate Keys ValidationThis tutorial shows how to insert a value into a MySQL table with proper validation for the existence or otherwise of duplicate keys/values. MySQL TableHow to Check if Table Exists in MySQLThis tutorial will show how to check table existence without using select from statement in MySQL. MySQL QueryHow to Use Not Exists in MySQLThis tutorial demonstrates how to filter data using the not exists condition in a MySQL database. MySQL DateHow to Get the Current Date in MySQLThis tutorial describes the various methods to get the current date from a MySQL host system. MySQL NumberHow to Format and Store Phone Numbers in MySQLThis tutorial illustrates the handling and formatting of phone number fields in a MySQL database. The choice of the most appropriate datatypes based on database requirements is also discussed. MySQL ColumnHow to Adding a Column in MySQLThis tutorial demonstrates adding a column in a MySQL database. MySQL IDHow to Find Last Inserted ID From Tables in MySQLWe will discuss the ways for finding last inserted IDs in MySQL in spesific cases. MySQL DumpHow to Dump Remote Database in MySQLThis article introduces how to dump MySQL remote database. MySQL TimezoneHow to Set Timezone in MySQLIn this tutorial we will learn how to change timezone in MySQL server.