MySQL

2. Tags
3. MySQL

MySQL Substring

• MySQL SUBSTRING_INDEX

MySQL Recursive

• MySQL Recursive Query

MySQL Count

• MySQLi Count() Function

MySQL WAMP

• Wamp Default MySQL Password

MySQL Lowercase

• MySQL Convert String to Lowercase

MySQL Password

• Store Password in MySQL Database

MySQL Update

• Update Record if It Exists Else Insert It in the MySQL Table
• Usage of UPDATE JOIN in MySQL

MySQL ElasticSearch

• Elastic Search in MySQL

MySQL Console

• Clear the Screen in MySQL
• MySQL Print to Console

MySQL Synchronization

• MySQL Database Synchronization

MySQL XAMPP

• XAMPP MySQL Command Line

MySQL Cron Job

• MySQL Cron Job

MySQL Backup

• Backup a Single Table Using Mysqldump
• Backup MySQL Database in Windows

MySQL Table

• Backup a Single Table Using Mysqldump
• Difference Between Two Tables in MySQL
• 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
• Insert Form Data Using MySQL Table in PHP
• 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 JDBC

• Connect to a MySQL Database Using JDBC

MySQL Permission

• MySQL Create Read-Only User

MySQL Row

• Duplicate a Row in MySQL
• MySQL Split String Into Rows
• Insert Multiple Rows in MySQL
• Convert Rows to Columns in MySQL

MySQL Column

• Identity Column in MySQL
• Specify Unique Constraints for Multiple Columns in MySQL
• Add an Auto Increment Column in MySQL
• Drop a Column if It Exists in MySQL
• 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 Join

• LEFT JOIN on Multiple Columns in MySQL
• 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 Date

• MySQL Get Last 30 Days Data
• 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 String

• MySQL Split String Into Rows
• 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 Privilege

• Revoke Privileges in MySQL
• Skip Grant Tables in MySQL

MySQL Lock

• Show Locks in MySQL
• Waiting for Table Metadata Lock

MySQL Loop

• While Loop in MySQL
• MySQL ForEach Loop
• For Loop in MySQL

MySQL Sum

• Get Sum of Multiple Columns in MySQL

MySQL Workbench

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

MySQL Database

• Check if a Database Exists in MySQL
• 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 Sort

• Sort MySQL Data Alphabetically
• Sort MySQL Data in Alphabetical Order

MySQL Constraint

• MySQL Remove Unique Constraint

MySQL Restart

• Restart MySQL Server on Windows

MySQL Index

• MySQL Drop Index
• MySQL Rebuild Index
• Show Indexes for Table or Database in MySQL

MySQL Restore

• Restore Database From SQL File in MySQL

MySQL Blob

• Convert Blob Data Into the Text Format 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

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 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 Log

• Transaction Log in MySQL

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

MySQL Like

• Enforce Like Case Sensitive in MySQL

MySQL Root

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

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 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 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 Primary Key

• Update Primary Key in MySQL Tables

MySQL File

• Use Mysqldump to Backup Data in MySQL

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

PHP Insert

• Insert Form Data Using MySQL Table in PHP

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 Filter

• Select Only Not Null Values in MySQL

MySQL Search

• Using LIKE in Case-Insensitive Search

MySQL Fetch

• Fetch Random Values in MySQL

MySQL Random

• Fetch Random Values in MySQL

MySQL ORDER

• ORDER BY RAND in MySQL

MySQL RAND

• ORDER BY RAND in MySQL

MySQL Auto Increment

• Reset Auto Increment in MySQL

MySQL Reset

• Reset Auto Increment in MySQL

MySQL Delete

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

MySQL Text

• MySQL Tinytext

MySQL Tinytext

• 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 LIMIT Clause

• Select Top N Rows in MySQL

MySQL SELECT

• Select Top N Rows in MySQL

MySQL Host

• Unblock With Mysqladmin Flush Hosts in MySQL

MySQL Event

• Event Scheduler or Set a Timer in MySQL

MySQL Scheduler

• Event Scheduler or Set a Timer in MySQL

MySQL Timer

• 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 DBMS

• Difference Between Schema and Database in MySQL

MySQL Oracle

• 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 MINUS

• Minus Operation in MySQL

MySQL Operation

• Minus Operation in MySQL

MySQL Process

• Kill a Process in MySQL

MySQL Comments

• MySQL Comments

MySQL Clause

• MySQL With Clause

MySQL ROW

• Use of Row_Number() Function in MySQL

MySQL Statement

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

MySQL Concatenate

• Concatenate Two Columns in MySQL

MySQL Variable

• Declare and Use Variables in MySQL