MySQL

How-tos How to Insert With Select in MySQL This article introduces how to insert with select in MySQL. ↗ How-tos How to Convert String to Date Format in MySQL We will learn about how to convert a string value to DATE type value using STR_TO_DATE(), CONVERT(), and CAST() functions in MySQL. ↗ How-tos How to Delete a Column From a Table in MySQL This tutorial demonstrates how to delete a column from a table in MySQL. ↗ How-tos How to Reset Auto Increment in MySQL This tutorial demonstrates how to reset auto increment in MySQL. ↗ How-tos How to ORDER BY RAND in MySQL This tutorial demonstrates how to sort values randomly in MySQL. ↗ How-tos How to Fetch Random Values in MySQL This tutorial demonstrates how to quickly fetch random values with a limit in MySQL. ↗ How-tos How to Use LIKE in Case-Insensitive Search This tutorial demonstrates how to use LIKE for a case-insensitive search. ↗ How-tos How to Sort by Date in MySQL This tutorial demonstrates how to sort values by date in MySQL. ↗ How-tos How to Select Only Not Null Values in MySQL This tutorial demonstrates how to filter null values in MySQL. ↗ How-tos How to Drop Multiple Tables in MySQL This tutorial demonstrates how to drop multiple tables in 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 Set Timezone in MySQL In this tutorial we will learn how to change timezone in MySQL server. ↗ 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 Implement Flush Privileges in MySQL This tutorial introduces the flush privileges command in MySQL for refreshing the grants table and effecting permitted changes. ↗ 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. ↗