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 DateHow to Retrieve Data Within a Date Range in MySQLThis tutorial illustrates the method of selecting and retrieving data within a date range in MySQL using comparison operators. MySQL Flush PrivilegesHow to Implement Flush Privileges in MySQLThis tutorial introduces the flush privileges command in MySQL for refreshing the grants table and effecting permitted changes. MySQL DuplicateHow to Find Duplicate Records in a MySQL TableThis tutorial illustrates the methods of detecting and counting the number of duplicate records in a MySQL table using a combination of the Select, Distinct, and Count keywords. MySQL ColumnHow to Change Column Datatype or Property in MySQLThis tutorial explains the process of changing the datatype and other attributes or constraints of an existing column in a MySQL database table. MySQL DatabaseHow to Copy Database in MySQLThis article introduces how to copy MySQL database. MySQL ExportHow to Export Data to an Outfile in MySQLThis article introduces how to export SQL to an outfile. MySQL TableHow to Check if a Row Exists in the MySQL TableThis tutorial demonstrates different ways to check if a row exists in the MySQL table. It explains each method with SQL query. MySQL LockHow to Wait for Table Metadata LockThis tutorial educates about lock and metadata lock wait. It also introduces the causes for the occurrence of metadata lock wait and provides the solution as well. MySQL DatabaseHow to Copy Rows in the MySQL DatabaseThis tutorial demonstrates how to copy rows in the MySQL database. It explains by copying rows within the same table as well as from one table to another. MySQL PrivilegeHow to Skip Grant Tables in MySQLThis tutorial educates about grant tables, MySQL skip grant tables, and their uses. MySQL Primary KeyHow to Update Primary Key in MySQL TablesThis tutorial educates about how to update primary key in MySQL tables. MySQL TableHow to Copy Table Structures Without Copying Data in MySQLThis tutorial demonstrates how to copy table structures without copying data in MySQL. MySQL DateHow to Use the Date_ADD() Function to Add Days and Time in MySQLThis tutorial demonstrates the use of DATE_ADD() function to add and minus days and time in MySQL. MySQL IndexHow to Show Indexes for Table or Database in MySQLThis tutorial demonstrates how we can show indexes for a table or a database in MySQL. MySQL CommandHow to Get the MySQL Command History in Windows and LinuxThis tutorial demonstrates different methods to get the history of MySQL commands in Windows and Linux. MySQL ErrorHow to Fix Error: Data Is Truncated for a Column Error in MySQLThis tutorial educates about the possible reasons and solutions to get rid of an error saying MySQL data is truncated for a column. MySQL LinuxHow to Install the MySQL Client in LinuxThis article introduces how to install the MySQL client in Linux. MySQL DecimalHow to Cast to Decimal in MySQLThis tutorial educates about how to cast to decimal in MySQL using CAST() and CONVERT() with the DECIMAL(M,D) function. MySQL TimestampHow to Compare MySQL Timestamp Dates With the Date Parameter OnlyThis tutorial demonstrates how we can compare MySQL timestamp dates with the date parameter only using the DATE(), CAST(), and CONVERT() functions. MySQL ServerHow to Change the max_allowed_packet Size in the MySQL ServerThis tutorial demonstrates how to change the max_allowed_packet size in the MySQL server using Windows and Linux operating systems. MySQL ConnectionHow to Change the Connection Timeout in MySQLThis tutorial demonstrates how we can change the connection timeout in MySQL using Windows and Linux operating system. MySQL TableHow to Get the ID of the Latest Inserted Record in MySQLThis tutorial tackles about how to get the ID of the latest inserted record in MySQL. MySQL QueryHow to Calculate Percentage in MySQLThis tutorial describes various ways to calculate percentage in MySQL using one or multiple columns. MySQL KeyHow to Turn Off Foreign Key Constraint in MySQLThis tutorial educates how to turn off foreign key constraint in MySQL.