2. HowTo
3. MySQL Howtos

MySQL Row

• Convert Rows to Columns in MySQL

MySQL Column

• Convert Rows to Columns in MySQL
• Find Tables in MySQL With Specific Column Names in Them
• Calculate Average of a Table Column in MySQL
• MySQL Check if Column Is Null or Empty
• Update Multiple Columns in Multiple Rows With Different Values in MySQL
• Use the ORDER BY Clause With Multiple Columns in MySQL
• Change Column Datatype or Property in MySQL
• Adding a Column in MySQL

MySQL Format

• Formatting Numbers in MySQL

MySQL Stored Procedure

• MySQL Stored Procedure With Parameters
• List All Stored Procedures in MySQL

MySQL Function

• Use PHP MySQLi Function to Fetch Last Inserted ID
• Create a Function in MySQL
• MySQL Function
• The Datepart Function Alternatives in MySQL
• The Rank Function in MySQL

MySQL Error

• MySQL Error Server PID File Could Not Be Found
• Fix Data Is Truncated for a Column Error in MySQL
• Display Errors Using MySQLi Error Functions

MySQL Backup

• Backup MySQL Database in Windows

MySQL Connection

• Kill Connections in MySQL
• Solutions to the Deprecated Mysql_connect in PHP
• Change the Connection Timeout in MySQL

MySQL Where

• Select Multiple Values Using WHERE in MySQL

MySQL Group By

• MySQL Group by With Count Function

MySQL Version

• Check MySQL Version in macOS
• Get Version in MySQL

MySQL Database

• Find Value in a Set in MySQL Database
• Solutions to the Deprecated Mysql_connect in PHP
• Connect a Remote MySQL Database Using the Command Line
• Optimize Tables and Databases in MySQL
• Show Table and Database Structure in MySQL
• Show the Current Database in MySQL
• Copy Rows in the MySQL Database
• Copy Database in MySQL
• Tiny Integer in MySQL
• Delete a Column From a Table in MySQL
• Select Top N Rows in MySQL
• Difference Between Schema and Database in MySQL
• Search Occurrences of String in MySQL Database

MySQL Port

• Port Number in MySQL

MySQL Key

• Show Foreign Keys in MySQL
• Add the Primary Key to a MySQL Table
• Turn Off Foreign Key Constraint in MySQL
• MySQL Drop Foreign Key
• Multiple Primary Keys in MySQL

MySQL Query

• Sort MySQL Data in Alphabetical Order
• Enable Slow Query Log in MySQL
• Calculate Percentage in MySQL
• Where vs Having in MySQL
• Nested Select Statements in MySQL for Enhanced Query
• Tiny Integer in MySQL
• Greater Than Date in MySQL
• Isnumeric in MySQL
• Use Not Exists in MySQL
• Select All Tables in MySQL
• Common Table Expressions in MySQL
• Sort by Date in MySQL
• Update Table From Another Table in MySQL
• Decimal Values in MySQL
• For Loop in MySQL
• Full Join in MySQL
• Insert Date in MySQL
• Select Most Recent Record in MySQL
• Substring in MySQL
• Truncated Incorrect Double Value in MySQL
• CASE WHEN in MySQL
• Group by Month in MySQL
• INSERT IF NOT EXISTS in MySQL
• Locating the Error Log in MySQL
• Get Column Names in MySQL
• The COUNT IF Method in MySQL
• Rename a Column in MySQL Database
• Running MySQL Queries From the Command Line
• Usage of IF EXISTS in MySQL Database
• Check if String Contains Certain Data in MySQL

MySQL Sort

• Sort MySQL Data in Alphabetical Order

MySQL Log

• Transaction Log in MySQL

MySQL Table

• Create Table Alias With MySQL VIEW and MERGE
• Drop Constraint From the MySQL Table
• Update Multiple Tables With One Query in MySQL
• Optimize Tables and Databases in MySQL
• Insert Timestamp Into a MySQL Table
• Select the First Row From the MySQL Table
• Show Table and Database Structure in MySQL
• Get the ID of the Latest Inserted Record in MySQL
• Loop Through All Rows of a MySQL Table
• Copy Table Structures Without Copying Data in MySQL
• Different Ways to Check if a Row Exists in the MySQL Table
• Truncate All Tables in Mysql
• Create Table From CSV in MySQL
• Check if Table Exists in MySQL
• Count Table Rows in MySQL
• Drop Multiple Tables in MySQL
• Delete a Column From a Table in MySQL
• Rename a Table in MySQL
• Copy a Table in MySQL
• Create a Temporary Table in MySQL
• Pivot Table in MySQL
• Drop All Tables in MySQL
• SELECT From Multiple Tables in MySQL

MySQL Workbench

• MySQL Workbench: Edit Read-Only Table Data
• Import Excel File Into a MySQL Database
• Create New Database in MySQL Workbench

MySQL Sleep

• The Correct Way to Use MySQL SLEEP() Command

MySQL Timestamp

• Use CURRENT_TIMESTAMP as Default in MySQL
• Insert Timestamp Into a MySQL Table
• Compare MySQL Timestamp Dates With the Date Parameter Only
• Convert Timestamp Field to Date in Mysql Query

MySQL Mac

• Open MySQL Using Mac Terminal

PHP MySQL

• Describe Database Table With Mysqli_query in PHP

MySQL Like

• Enforce Like Case Sensitive in MySQL

MySQL Root

• Change MySQL Root Password on Mac
• Reset the MySQL Root Password in Ubuntu

MySQL String

• Generate Random and Unique Strings in MySQL
• Append Strings to an Existing Field in MySQL
• Search Rows to Find Substrings in MySQL
• Escape Single Quote in MySQL
• Search Occurrences of String in MySQL Database
• Replace a String in MySQL
• Split String in MySQL

MySQL Dump

• Use Mysqldump Gzip to Create a Compressed File for a MySQL Database
• MySQL Dump Remote Database

MySQL SQL

• Differences Between SQL and MySQL

MySQL PHP

• Process Form Data With Mysqli_real_escape_string
• Loop PHP MySQLi Fetch Array Function

MySQL Zerofill

• Use, Benefits, and Alternative of the Zerofill in MySQL

MySQL Date

• Convert From Datetime Type to Date Only in MySQL
• MySQL Date Subtract
• Use the Date_ADD() Function to Add Days and Time in MySQL
• Retrieve Data Within a Date Range in MySQL
• Get the Current Date in MySQL
• Convert String to Date Format in MySQL

MySQL Insert

• Insert Into Multiple Tables in MySQL
• MySQL Insert With Select
• Insert Bulk Values in MySQL

MySQL Groupby

• Group the Datetime Column by Date Only in MySQL
• Group by Multiple Columns in MySQL

MySQL Loop

• MySQL ForEach Loop
• For Loop in MySQL

MySQL Data Type

• MySQL Money Data Type

MySQL Server

• Change the max_allowed_packet Size in the MySQL Server
• Start MySQL Server

MySQL DateTime

• Get the Current Date and Time in MySQL

MySQL Decimal

• Cast to Decimal in MySQL
• Decimal Values in MySQL

MySQL Linux

• Install the MySQL Client in Linux
• Different Ways to Connect a Remote MySQL Server Using Ubuntu

MySQL Decode

• The Equivalent of Oracle's decode Function in MySQL

MySQL Command

• Get Command History in MySQL

MySQL Index

• Show Indexes for Table or Database in MySQL

MySQL Primary Key

• Update Primary Key in MySQL Tables

MySQL File

• Use Mysqldump to Backup Data in MySQL

MySQL Privilege

• Skip Grant Tables in MySQL

MySQL Lock

• Waiting for Table Metadata Lock

MySQL Composite Key

• Introduction to the MySQL Composite Key

MySQL Export

• Export Data to an Outfile in MySQL
• Export Database in MySQL From the Command Line
• Export MySQL Database Using Mysqldump

MySQL Duplicate

• Find Duplicate Records in a MySQL Table

MySQL Flush Privileges

• Implement Flush Privileges in MySQL

MySQL Timezone

• Set Timezone in MySQL

MySQL ID

• Find Last Inserted ID From Tables in MySQL

MySQL Select

• Nested Select Statements in MySQL for Enhanced Query
• MySQL Insert With Select
• Select Unique Values in MySQL

MySQL Mode

• Safe Mode in MySQL

MySQL Datepart

• The Datepart Function Alternatives in MySQL

MySQL Number

• Format and Store Phone Numbers in MySQL

MySQL CSV

• Create Table From CSV in MySQL
• Export Data From MySQL to a CSV File

MySQL Unsigned

• Unsigned in MySQL

MySQL INSERT

• Insert Value in MySQL Table With Duplicate Keys Validation

MySQL Join

• Delete With Join in MySQL
• Join 3 Tables in MySQL
• Usage of UPDATE JOIN in MySQL
• Execute Multiple Joins in One Query in MYSQL

MySQL Filter

• Select Only Not Null Values in MySQL

MySQL Search

• Using LIKE in Case-Insensitive Search

MySQL Random

• Fetch Random Values in MySQL

MySQL Fetch

• Fetch Random Values in MySQL

MySQL ORDER

• ORDER BY RAND in MySQL

MySQL RAND

• ORDER BY RAND in MySQL

MySQL Reset

• Reset Auto Increment in MySQL

MySQL Auto Increment

• Reset Auto Increment in MySQL

MySQL Delete

• MySQL Cascade Delete
• Delete All Rows in MySQL Database Using phpMyAdmin

MySQL Tinytext

• MySQL Tinytext

MySQL Text

• MySQL Tinytext

MySQL Escape Sequences

• Escape Sequences in MySQL

MySQL Intersect

• Intersect Operator in MySQL

MySQL Intersect Operator

• Intersect Operator in MySQL

MySQL Import

• Import Excel File Into a MySQL Database
• Import a CSV File Into a Table in a MySQL Database

MySQL SELECT

• Select Top N Rows in MySQL

MySQL LIMIT Clause

• Select Top N Rows in MySQL

MySQL Host

• Unblock With Mysqladmin Flush Hosts in MySQL

MySQL Scheduler

• Event Scheduler or Set a Timer in MySQL

MySQL Timer

• Event Scheduler or Set a Timer in MySQL

MySQL Event

• Event Scheduler or Set a Timer in MySQL

MySQL Condition

• If ELSE in MySQL

MySQL NULL

• Setting Null in MySQL

MySQL Integer

• Cast as Integer in MySQL
• Round Down to the Nearest Integer in MySQL

MySQL CHAR

• Difference Between VARCHAR and CHAR in MySQL

MySQL VARCHAR

• Difference Between VARCHAR and CHAR in MySQL

MySQL Oracle

• Difference Between Schema and Database in MySQL

MySQL DBMS

• Difference Between Schema and Database in MySQL

MySQL MUL

• MUL vs PRI vs UNI in MySQL

MySQL PRI

• MUL vs PRI vs UNI in MySQL

MySQL UNI

• MUL vs PRI vs UNI in MySQL

MySQL Data

• Copy Data From One Database to Another in MySQL

MySQL DATETIME

• DATETIME vs TIMESTAMP in MySQL

MySQL TIMESTAMP

• DATETIME vs TIMESTAMP in MySQL

MySQL Mysqld

• Different Ways to Stop Mysqld

MySQL Operation

• Minus Operation in MySQL

MySQL MINUS

• Minus Operation in MySQL

MySQL Process

• Kill a Process in MySQL

MySQL Comments

• MySQL Comments

MySQL Clause

• MySQL With Clause

MySQL Update

• Usage of UPDATE JOIN in MySQL

MySQL ROW

• Use of Row_Number() Function in MySQL

MySQL Statement

• The CASE Statement in MySQL
• The IF Statement in MySQL

SQL Image

• Store Image in MySQL Database

SQL Query

• Use Boolean Data Type in MySQL

MySQL Concatenate

• Concatenate Two Columns in MySQL

MySQL Variable

• Declare and Use Variables in MySQL