MySQL

How-tos How to Convert Timestamp Field to Date in Mysql Query This tutorial demonstrates how to convert timestamp to date in MySQL Query. ↗ How-tos How to Insert Value in MySQL Table With Duplicate Keys Validation This tutorial shows how to insert a value into a MySQL table with proper validation for the existence or otherwise of duplicate keys/values. ↗ How-tos How to Check if Table Exists in MySQL This tutorial will show how to check table existence without using select from statement in MySQL. ↗ How-tos How to Use Not Exists in MySQL This tutorial demonstrates how to filter data using the not exists condition in a MySQL database. ↗ How-tos How to Get the Current Date in MySQL This tutorial describes the various methods to get the current date from a MySQL host system. ↗ How-tos How to Format and Store Phone Numbers in MySQL This 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 … ↗ How-tos How to Adding a Column in MySQL This tutorial demonstrates adding a column in a MySQL database. ↗ How-tos How to Insert Form Data Using MySQL Table in PHP This article shows how the POST statement can send form data to table in a database. ↗ How-tos How to Find Last Inserted ID From Tables in MySQL We will discuss the ways for finding last inserted IDs in MySQL in spesific cases. ↗ How-tos How to Dump Remote Database in MySQL This article introduces how to dump MySQL remote database. ↗ How-tos How to Retrieve Data Within a Date Range in MySQL This tutorial illustrates the method of selecting and retrieving data within a date range in MySQL using comparison operators. ↗ How-tos How to Find Duplicate Records in a MySQL Table This 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. ↗ 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 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. ↗