MySQL Database Tutorials

Q

Where to find MySQL database server tutorials?

✍: FYIcenter.com

A

Here is a collection of tutorials, tips and FAQs for MySQL DBA and MySQL database application developers. Clear explanations and sample scripts provided can be used as learning tutorials or interview preparation guides.

It doesn't matter whether you are a beginner or an experienced MySQL DBA or developer, browse through our MySQL DBA FAQ and tips. They will always help you to improve your skills and find some good ideas to solve problems in your daily tasks.

So far, Our MySQL developers have written over 200 questions and answers to share with you. Each one of them answers one commonly asked MySQL question with a short, but precise and simple example.

Downloading and Installing MySQL on Windows

MySQL Server Features in MySQL

Installing MySQL Server in MySQL

Starting MySQL Server in MySQL

Verify MySQL Server Status in MySQL

Verify the Version of MySQL Server in MySQL

Creating a Test Table in MySQL Server in MySQL

Shutting Down MySQL Server in MySQL

Administrator Tools for Managing MySQL Server

Tools to Manage MySQL Server in MySQL

What Is "mysqld" Command in MySQL

What Is "mysqladmin" Command in MySQL

Show Server Status with "mysqladmin" in MySQL

Shutdown the Server with "mysqladmin" Command in MySQL

What Is "mysql" Command in MySQL

Use "mysql" to Run SQL Statements in MySQL

List All Tables with "mysql" Command in MySQL

What Is "mysqlcheck" Command in MySQL

Analyze Tables with "mysqlcheck" Command in MySQL

What Is "mysqlshow" Command in MySQL

List Table Names with "mysqlshow" Command in MySQL

What Is "mysqldump" Command in MySQL

Dump a Table to a File with "mysqldump" Command in MySQL

What Is "mysqlimport" Command in MySQL

Loading Data Files with "mysqlimport" Command in MySQL

Command-Line End User Interface 'mysql'

"mysql" - Command Line End User Interface in MySQL

"mysql" Command Line Options in MySQL

"mysql" Command Line Arguments in MySQL

DDL Commands Supported in MySQL

DML Commands Supported in MySQL

Non-Standard SQL Commands in MySQL

Getting Help Information from the Server in MySQL

Running "mysql" Commands from a Batch File in MySQL

Returning Query Output in HTML Format in MySQL

Returning Query Output in XML Format in MySQL

Introduction to SQL Basics in MySQL

What Is SQL Standard in MySQL

Groups of Data Types in MySQL

Character String Data Types in MySQL

Difference between CHAR and NCHAR in MySQL

Difference between CHAR and VARCHAR in MySQL

Difference between BINARY and VARBINARY in MySQL

Numeric Data Types in MySQL

Date and Time Data Types in MySQL

Evaluating Expressions with SELECT Statements in MySQL

Including Comments in SQL Statements in MySQL

Entering Character Strings in MySQL

Escape Special Characters in MySQL

Concatenating Character Strings in MySQL

Entering Numeric Values in MySQL

Entering Characters as HEX Numbers in MySQL

Entering Numeric Values as HEX Numbers in MySQL

Entering Binary Numbers in MySQL

Entering Boolean Values in MySQL

What Is NULL Value in MySQL

Expressions with NULL Values in MySQL

Converting Numeric Values to Character Strings in MySQL

Converting Character Strings to Numeric Values in MySQL

Using IN Conditions in MySQL

Using LIKE Conditions in MySQL

Using Regular Expression with REGEXP in MySQL

Using CASE Expression in MySQL

Introduction to Date and Time Handling in MySQL

What are Date and Time Data Types in MySQL

Writing Date and Time Literals in MySQL

Entering Microseconds in SQL Statements in MySQL

Converting Dates to Character Strings in MySQL

Converting Character Strings to Dates in MySQL

Date and Time Intervals in MySQL

Incrementing a Date by 1 in MySQL

Decrementing a Date by 1 in MySQL

Calculating the Difference between Two Dates in MySQL

Calculating the Difference between Two Time Values in MySQL

Presenting a Past Time in Hours, Minutes and Seconds in MySQL

Extract Unit Values from a Date and Time in MySQL

Date and Time Functions in MySQL

What Is TIMESTAMP Data Type in MySQL

Ways to Get the Current Time in MySQL

CREATE, ALTER and DROP Statements in MySQL

What Are DDL Statements in MySQL

CREATE TABLE Statement in MySQL

CREATE Command Denied Error in MySQL

Show All Tables in a Database in MySQL

Show All Columns of an Existing Table in MySQL

Show CREATE TABLE Statements of Existing Tables in MySQL

Creating New Tables with SELECT Statements in MySQL

Add a New Column to an Existing Table in MySQL

Delete an Existing Column in a Table in MySQL

Rename an Existing Column in a Table in MySQL

Rename an Existing Table in MySQL

Drop an Existing Table in MySQL

Create an Index for a Given Table in MySQL

Show All Indexes of a given Table in MySQL

Drop an Existing Index in MySQL

Create a New View in MySQL

Drop an Existing View in MySQL

INSERT, UPDATE and DELETE Statements in MySQL

What Are DML Statements in MySQL

Creating a Test Table in MySQL

Inserting a New Row into a Table in MySQL

Using Column Default Values in MySQL

Omitting Columns in INSERT Statements in MySQL

Violation of Unique Value Constraint in MySQL

Insert Multiple Rows with 1 INSERT Statement in MySQL

Updating Values in a Table in MySQL

Update Column Values on Multiple Rows in MySQL

Use Existing Column Values in the SET Clause in MySQL

Order of Columns in the SET Clause in MySQL

UPDATE Using Data from Other Tables in MySQL

UPDATE with Subquery Returning No Rows in MySQL

Error: Subquery Returns More than 1 Row in MySQL

Deleting an Existing Row from a Table in MySQL

Deleting Multiple Rows from a Table in MySQL

Deleting All Rows in a Table in MySQL

SELECT Query Statements with GROUP BY in MySQL

What Is a SELECT Query Statement in MySQL

Create a Test Table with Test Data in MySQL

Selecting All Columns of All Rows in MySQL

Selecting Columns in a Query in MySQL

Select Rows with WHERE Clause in MySQL

Adding More Data to the Test Table in MySQL

Sorting Query Output in MySQL

Sort by Multiple Columns in MySQL

Sorting Output in Descending Order in MySQL

Count Number of Rows with SELECT Statements in MySQL

Using SELECT Statements in Views in MySQL

Filerting out Duplications in Returning Rows in MySQL

What Are Group Functions in MySQL

Using Group Functions in the SELECT Clause in MySQL

Group Functions with Non-group Selections in MySQL

Dividing Query Output into Groups in MySQL

Apply Filtering Criteria at Group Level in MySQL

Counting Duplicated Values in a Column in MySQL

Using Multiple Columns in GROUP BY in MySQL

Using Group Functions in the ORDER BY Clause in MySQL

SELECT Statements with JOIN and Subqueries in MySQL

Types of Table Joins in MySQL

Query with an Inner Join in MySQL

Using Table Alias Names in MySQL

Query with a Left Outer Join in MySQL

Query with a Right Outer Join in MySQL

Query with a Full Outer Join in MySQL

Inner Join with the WHERE Clause in MySQL

Assign Names to Query Output Columns in MySQL

What Is a Subquery in MySQL

Using Subqueries with the IN Operator in MySQL

Using Subqueries with the EXISTS Operator in MySQL

Using Subqueries in the FROM Clause in MySQL

Counting Groups Returned from GROUP BY in MySQL

Returning Top 5 Rows in MySQL

Returning the Second 5 Rows in MySQL

Merge Outputs from Two Queries in MySQL

Managing User Accounts and Access Privileges in MySQL

What Is a User Account in MySQL

Predefined User Accounts in MySQL

Adding a New User Account in MySQL

Testing New User Account and Password in MySQL

Changing Your Own Password in MySQL

Chaning Other User's Password in MySQL

Deleting a User Account in MySQL

Listing All User Accounts in MySQL

Rename an Existing User Account in MySQL

What Are User Privileges in MySQL

Scope Levels of User Privileges in MySQL

Giving Privileges at Server Level in MySQL

Giving Privileges at the Database Level in MySQL

Viewing User Privileges in MySQL

Revoking User Privileges in MySQL

Giving User Read-only Access in MySQL

User Privilege Tables in MySQL

Server Daemon mysqld Administration in MySQL

What Is MySQL Server Daemon - mysqld in MySQL

"mysqld" Command Line Options in MySQL

Ways to Start MySQL Server in MySQL

Shutdown MySQL Server Properly in MySQL

Memory Usage of the MySQL Server in MySQL

Turn on Query Logs in MySQL

Turn on Error Logs in MySQL

What Is Binary Log File in MySQL

Turn on Binary Logs in MySQL

Viewing Log File with "mysqlbinlog" in MySQL

Running MySQL Server on a Specific Port in MySQL

Connecting to MySQL Server on a Specific Port in MySQL

PHP Connections and Query Execution for MySQL

Installing PHP on Windows in MySQL

Verifying PHP Installation in MySQL

Requirements for Using MySQL in PHP in MySQL

Turning on mysql Extension on the PHP Engine in MySQL

Connect to MySQL Server without Port Number in MySQL

Connect to MySQL Server with Port Number in MySQL

Connect to MySQL Server with User Account in MySQL

Accessing MySQL Server through Firewalls in MySQL

Retrieving MySQL Server information in MySQL

Close MySQL Connection Objects in MySQL

List All Existing Databases in MySQL

Creating a New Database in MySQL

Failed to Create a Database in MySQL

Retrieving Execution Error Message in MySQL

Deleting an Existing Database in MySQL

Selecting an Existing Database in MySQL

Selecting Other User's Database in MySQL

Execute SQL Statements in MySQL

Managing Tables and Running Queries with PHP for MySQL

Creating a New Table in MySQL

Number of Rows Selected or Affected in MySQL

Inserting Data into an Existing Table in MySQL

Fixing INSERT Command Denied Error in MySQL

Inserting Rows with a SELECT Statement in MySQL

What Is a Result Set Object in MySQL

Looping through Query Output Rows in MySQL

Breaking Query Output into Pages in MySQL

Updating Existing Rows in MySQL

Deleting Existing Rows in MySQL

Quoting Text Values in MySQL

Quoting Date and Time Values in MySQL

Dispaly Part Time in Days, Hours and Minutes in MySQL

Key Word Search in Tables in MySQL

Build WHERE Criteria with Web Form Data in MySQL

Query Multiple Tables Jointly in MySQL

Define the ID Column as Auto-Incremented in MySQL

Retrieving the Last Sequence ID in MySQL

Storage Engines: MyISAM, InnoDB and BDB in MySQL

Major Storage Engines Supported in MySQL in MySQL

Tables Using MyISAM Storage Engine in MySQL

Data File for MyISAM Storage Engine in MySQL

Backup Tables by Copying MyISAM Files in MySQL

Restore Tables by Copying MyISAM Files in MySQL

Repair MyISAM Tables in MySQL

Tables Using InnoDB Storage Engine in MySQL

Data File for InnoDB Storage Engine in MySQL

Tables Using BDB Storage Engine in MySQL

Starting mysqld to Support BDB Storage Engine in MySQL

Data File of BDB Storage Engine in MySQL

Tables Using CSV Storage Engine in MySQL

Tables Using MEMORY Storage Engine in MySQL

Data Removed in MEMORY Tables in MySQL

Show Storage Engines Supported in MySQL in MySQL

Transaction Management: Commit or Rollback in MySQL

What Is a Transaction - Unit of Work in MySQL

Ways to Start a New Transaction in MySQL

Ways to End the Current Transaction in MySQL

Create a Table for Transaction Testing in MySQL

Turn on and off Autocommit in MySQL

Show the Current Transaction Mode in MySQL

Start a New Transaction Explicitly in MySQL

Commit the Current Transaction in MySQL

Rollback the Current Transaction in MySQL

Transaction Committed when START TRANSACTION Executed in MySQL

Transaction Committed when DDL Statement Executed in MySQL

Transaction Roll Back when Session Ended in MySQL

Transaction Roll Back when Session Killed in MySQL

Read Consistency Support in MySQL in MySQL

Transaction Isolation Levels in MySQL

Change Transaction Isolation Level in MySQL

What Is a Data Lock in MySQL

Experiment with Data Locks in MySQL

Transaction Waiting for a Data Lock in MySQL

Error: Lock Wait Timeout Exceeded in MySQL

What Is a Dead Lock in MySQL

Experiment with Dead Locks in MySQL

Error: Deadlock Found When Trying to Get Lock in MySQL

Locks, Timeouts, and Deadlocks in MySQL

Database Basics and Terminologies in MySQL

What Is MySQL

What Is mSQL in MySQL

What Is SQL in MySQL

What Is Table in MySQL

What Is Column in MySQL

What Is Row in MySQL

What Is Primary key in MySQL

What Is Foreign Key in MySQL

What Is Index in MySQL

What Is View in MySQL

What Is Join in MySQL

What Is Union in MySQL

What Is ISAM in MySQL

What Is MyISAM in MySQL

What Is InnoDB in MySQL

What Is BDB in MySQL

What Is CSV in MySQL

What Is Transaction in MySQL

What Is Commit in MySQL

What Is RollBack in MySQL

2016-10-16, 324👍, 0💬