MySQL

How-tos How to Change Column Datatype or Property in MySQL This tutorial explains the process of changing the datatype and other attributes or constraints of an existing column in a MySQL database table. ↗ How-tos How to Copy Database in MySQL This article introduces how to copy MySQL database. ↗ How-tos How to Export Data to an Outfile in MySQL This article introduces how to export SQL to an outfile. ↗ How-tos How to Check if a Row Exists in the MySQL Table This tutorial demonstrates different ways to check if a row exists in the MySQL table. It explains each method with SQL query. ↗ How-tos How to Wait for Table Metadata Lock This 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. ↗ How-tos How to Copy Rows in the MySQL Database This 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. ↗ How-tos How to Skip Grant Tables in MySQL This tutorial educates about grant tables, MySQL skip grant tables, and their uses. ↗ How-tos How to Update Primary Key in MySQL Tables This tutorial educates about how to update primary key in MySQL tables. ↗ How-tos How to Copy Table Structures Without Copying Data in MySQL This tutorial demonstrates how to copy table structures without copying data in MySQL. ↗ How-tos How to Use the Date_ADD() Function to Add Days and Time in MySQL This tutorial demonstrates the use of DATE_ADD() function to add and minus days and time in MySQL. ↗ How-tos How to Show Indexes for Table or Database in MySQL This tutorial demonstrates how we can show indexes for a table or a database in MySQL. ↗ How-tos How to Get the MySQL Command History in Windows and Linux This tutorial demonstrates different methods to get the history of MySQL commands in Windows and Linux. ↗ How-tos How to Fix Error: Data Is Truncated for a Column Error in MySQL This tutorial educates about the possible reasons and solutions to get rid of an error saying MySQL data is truncated for a column. ↗ How-tos How to Install the MySQL Client in Linux This article introduces how to install the MySQL client in Linux. ↗ How-tos How to Cast to Decimal in MySQL This tutorial educates about how to cast to decimal in MySQL using CAST() and CONVERT() with the DECIMAL(M,D) function. ↗ How-tos How to Compare MySQL Timestamp Dates With the Date Parameter Only This tutorial demonstrates how we can compare MySQL timestamp dates with the date parameter only using the DATE(), CAST(), and CONVERT() functions. ↗ How-tos How to Change the max_allowed_packet Size in the MySQL Server This tutorial demonstrates how to change the max_allowed_packet size in the MySQL server using Windows and Linux operating systems. ↗ How-tos How to Change the Connection Timeout in MySQL This tutorial demonstrates how we can change the connection timeout in MySQL using Windows and Linux operating system. ↗ How-tos How to Get the ID of the Latest Inserted Record in MySQL This tutorial tackles about how to get the ID of the latest inserted record in MySQL. ↗ How-tos How to Calculate Percentage in MySQL This tutorial describes various ways to calculate percentage in MySQL using one or multiple columns. ↗ How-tos How to Turn Off Foreign Key Constraint in MySQL This tutorial educates how to turn off foreign key constraint in MySQL. ↗ How-tos How to Show Table and Database Structure in MySQL This tutorial demonstrates the use of the mysqldump utility, DESCRIBE, SHOW TABLES, and SHOW CREATE TABLE statements to show table and database structures in MySQL. ↗ How-tos How to Add the Primary Key to a MySQL Table This tutorial demonstrates how to add the primary key to a MySQL table using CREATE TABLE and ALTER TABLE statements. ↗ How-tos How to Select the First Row From the MySQL Table This tutorial educates about how we can select the first row from a MySQL table. ↗