Home >> Tutorials/FAQs

MySQL Tutorials and Tips - 268 Questions/Tutorials

This is a collection of tutorials and tips for MySQL DBA and developers. Clear answers 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 268 questions and answers to share with you. Each one of them answers one commonly asked MySQL question with a short, but precise and clear tutorial script. More questions will be available soon. Please come back to visit this page again.

MySQL Tutorials - Downloading and Installing MySQL on Windows

A collection of 7 FAQs on MySQL download and installation. Clear answers are provided with tutorial exercises on installing MySQL on Windows; starting and shuting down MySQL server; checking MySQL server status and version.

  1. What Is MySQL?
  2. How To Install MySQL Server?
  3. How To Start MySQL Server?
  4. How Do You Know If Your MySQL Server Is Alive?
  5. How Do You Know the Version of Your MySQL Server?
  6. How To Create a Test Table in Your MySQL Server?
  7. How To Shutdown MySQL Server?

More...

MySQL Tutorials - Administrator Tools for Managing MySQL Server

A collection of 16 FAQs on MySQL administration tools. Clear answers are provided with tutorial exercises on server daemon; administrator and end user interfaces; checking and repairing tables; dumping and importing tables.

  1. What Tools Available for Managing MySQL Server?
  2. What Is "mysqld"?
  3. What Is "mysqladmin"?
  4. How To Check Server Status with "mysqladmin"?
  5. How To Shut Down the Server with "mysqladmin"?
  6. What Is "mysql"?
  7. How To Use "mysql" to Run SQL Statements?
  8. How To Show All Tables with "mysql"?
  9. What Is "mysqlcheck"?
  10. How To Analyze Tables with "mysqlcheck"?
  11. What Is "mysqlshow"?
  12. How To Show Table Names with "mysqlshow"?
  13. What Is "mysqldump"?
  14. How To Dump a Table to a File with "mysqldump"?
  15. What Is "mysqlimport"?
  16. How To Load Data Files into Tables with "mysqlimport"?

More...

MySQL Tutorials - Command-Line End User Interface mysql

A collection of 10 FAQs on MySQL command-line interface mysql. Clear answers are provided with tutorial exercises on mysql command option; running SQL and mysql commands; running mysql command files in batch mode; returning query output in HTML and XML formats.

  1. What Is the Command Line End User Interface - mysql?
  2. What Are the "mysql" Command Line Options?
  3. What Are the "mysql" Command Line Arguments?
  4. How Many SQL DDL Commands Are Supported by "mysql"?
  5. How Many SQL DML Commands Are Supported by "mysql"?
  6. What Are the Non-Standard SQL Commands Supported by "mysql"?
  7. How To Get Help Information from the Server?
  8. How To Run "mysql" Commands from a Batch File?
  9. How To Return Query Output in HTML Format?
  10. How To Return Query Output in XML Format?

More...

MySQL Tutorials - Introduction to SQL Basics

A collection of 26 FAQs on MySQL SQL basics. Clear answers are provided with tutorial exercises on character and numeric data types; quoting character strings; ASCII and UTF8 character sets; NULL values and NULL conditions; IN and LIKE conditions.

  1. What Is SQL Standard?
  2. How Many Groups of Data Types?
  3. What Are Character String Data Types?
  4. What Are the Differences between CHAR and NCHAR?
  5. What Are the Differences between CHAR and VARCHAR?
  6. What Are the Differences between BINARY and VARBINARY?
  7. What Are Numeric Data Types?
  8. What Are Date and Time Data Types?
  9. How To Calculate Expressions with SELECT Statements?
  10. How To Include Comments in SQL Statements?
  11. How To Include Character Strings in SQL statements?
  12. How To Escape Special Characters in SQL statements?
  13. How To Concatenate Two Character Strings?
  14. How To Include Numeric Values in SQL statements?
  15. How To Enter Characters as HEX Numbers?
  16. How To Enter Numeric Values as HEX Numbers?
  17. How To Enter Binary Numbers in SQL Statements?
  18. How To Enter Boolean Values in SQL Statements?
  19. What Are NULL Values?
  20. What Happens If NULL Values Are Involved in Expressions?
  21. How To Convert Numeric Values to Character Strings?
  22. How To Convert Character Strings to Numeric Values?
  23. How To Use IN Conditions?
  24. How To Use LIKE Conditions?
  25. How To Use Regular Expression in Pattern Match Conditions?
  26. How To Use CASE Expression?

More...

MySQL Tutorials - Introduction to SQL Date and Time Handling

A collection of 15 FAQs on MySQL date and time handling. Clear answers are provided with tutorial exercises on date and time data types; formatting and converting date and times; incrementing dates and times; calculating date differences; understanding TIMESTAMP columns.

  1. What Are Date and Time Data Types?
  2. How To Write Date and Time Literals?
  3. How To Enter Microseconds in SQL Statements?
  4. How To Convert Dates to Character Strings?
  5. How To Convert Character Strings to Dates?
  6. What Are Date and Time Intervals?
  7. How To Increment Dates by 1?
  8. How To Decrement Dates by 1?
  9. How To Calculate the Difference between Two Dates?
  10. How To Calculate the Difference between Two Time Values?
  11. How To Present a Past Time in Hours, Minutes and Seconds?
  12. How To Extract a Unit Value from a Date and Time?
  13. What Are Date and Time Functions?
  14. What Is TIMESTAMP Data Type?
  15. How Many Ways to Get the Current Time?

More...

MySQL Tutorials - Understanding SQL CREATE, ALTER and DROP Statements

A collection of 17 FAQs on Oracle SQL DDL statements. Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views; adding, renaming, and dropping table columns.

  1. What Are DDL Statements?
  2. How To Create a New Table?
  3. What Happens If You No CREATE Privilege in a Database?
  4. How To Get a List of All Tables in a Database?
  5. How To Get a List of Columns in an Existing Table?
  6. How To See the CREATE TABLE Statement of an Existing Table?
  7. How To Create a New Table by Selecting Rows from Another Table?
  8. How To Add a New Column to an Existing Table?
  9. How To Delete an Existing Column in a Table?
  10. How To Rename an Existing Column in a Table?
  11. How To Rename an Existing Table?
  12. How To Drop an Existing Table?
  13. How To Create an Index for a Given Table?
  14. How To Get a List of Indexes of a Given Table?
  15. How To Drop an Existing Index?
  16. How To Create a New View?
  17. How To Drop an Existing View?

More...

MySQL Tutorials - Understanding SQL INSERT, UPDATE and DELETE Statements

A collection of 17 FAQs on Oracle SQL DML statements. Clear answers are provided with tutorial exercises on inserting and updating data rows; inserting and updating with subqueries; deleting data rows.

  1. What Are DML Statements?
  2. How To Create a Testing Table?
  3. How To Insert a New Row into a Table?
  4. How To Specify Default Values in INSERT Statement?
  5. How To Omit Columns with Default Values in INSERT Statement?
  6. What Happens If Unique Value Constraints Are Violated?
  7. How To Insert Multiple Rows with One INSERT Statement?
  8. How To Update Values in a Table?
  9. How To Update Column Values on Multiple Rows?
  10. How To Use Existing Column Values in the SET Clause?
  11. Is the Order of Columns in the SET Clause Important?
  12. How To Use Values from Other Tables in UPDATE Statements?
  13. What Happens If the UPDATE Subquery Returns No Rows?
  14. What Happens If the UPDATE Subquery Returns Multiple Rows?
  15. How To Delete an Existing Row from a Table?
  16. How To Delete Multiple Rows from a Table?
  17. How To Delete All Rows in a Table?

More...

MySQL Tutorials - SQL SELECT Query Statements with GROUP BY

A collection of 20 FAQs on MySQL SELECT query statements and basic features. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views; sorting and counting query outputs; grouping outputs and applying group functions.

  1. What Is a SELECT Query Statement?
  2. How To Create a Testing Table with Test Data?
  3. How To Select All Columns of All Rows from a Table?
  4. How To Select Some Columns from a Table?
  5. How To Select Some Rows from a Table?
  6. How To Add More Data to the Testing Table?
  7. How To Sort the Query Output?
  8. Can the Query Output Be Sorted by Multiple Columns?
  9. How To Sort Output in Descending Order?
  10. How To Use SELECT Statement to Count Number of Rows?
  11. Can SELECT Statements Be Used on Views?
  12. How To Filter Out Duplications in Returning Rows?
  13. What Are Group Functions?
  14. How To Use Group Functions in the SELECT Clause?
  15. Can Group Functions Be Mixed with Non-group Selection Fields?
  16. How To Divide Query Output into Groups?
  17. How To Apply Filtering Criteria at Group Level?
  18. How To Count Duplicated Values in a Column?
  19. Can Multiple Columns Be Used in GROUP BY?
  20. Can Group Functions Be Used in the ORDER BY Clause?

More...

MySQL Tutorials - SQL SELECT Statements with JOIN and Subqueries

A collection of 16 FAQs on MySQL SELECT statements with JOIN and subqueries. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS, and FROM clauses; using UNION operations.

  1. How To Join Two Tables in a Single Query?
  2. How To Write a Query with an Inner Join?
  3. How To Define and Use Table Alias Names?
  4. How To Write a Query with a Left Outer Join?
  5. How To Write a Query with a Right Outer Join?
  6. How To Write a Query with a Full Outer Join?
  7. How To Write an Inner Join with the WHERE Clause?
  8. How To Name Query Output Columns?
  9. What Is a Subquery?
  10. How To Use Subqueries with the IN Operator?
  11. How To Use Subqueries with the EXISTS Operator?
  12. How To Use Subqueries in the FROM clause?
  13. How To Count Groups Returned with the GROUP BY Clause?
  14. How To Return Top 5 Rows?
  15. How To Return the Second 5 Rows?
  16. How To Use UNION to Merge Outputs from Two Queries Together?

More...

MySQL Tutorials - Managing User Accounts and Access Privileges

A collection of 17 FAQs on MySQL user accounts and access privileges. Clear answers are provided with tutorial exercises on creating and deleting user accounts; setting and changing passwords; giving and removing user privileges; showing granted privileges and levels.

  1. What Is a User Account?
  2. What Are the Predefined User Accounts?
  3. How To Add a New User Account?
  4. How To Test a New User Account and Password?
  5. How To Change the Password for Your Own User Account?
  6. How To Change the Password of Another User Account?
  7. How To Delete a User Account?
  8. How To List All Existing User Accounts?
  9. How To Rename an Existing User Account Name?
  10. What Are User Privileges?
  11. How Many Scope Levels Can User Privileges Apply?
  12. How To Grant User Privileges at the Global Level?
  13. How To Grant User Privileges at the Database Level?
  14. How To View User Privileges?
  15. How To Revoke User Privileges?
  16. How To Give a User Read-Only Access to a Database?
  17. Where Are User Privileges Stored on the Server?

More...

MySQL Tutorials - Server Daemon mysqld Administration

A collection of 12 FAQs on MySQL server mysqld administration. Clear answers are provided with tutorial exercises on starting and shuting down the server; turning on server log files; viewing binary log files; running server on different port numbers.

  1. What Is the MySQL Server Daemon - mysqld?
  2. What Are the "mysqld" Command Line Options?
  3. How To Start MySQL Server Daemon mysqld?
  4. How To Properly Shutdown MySQL Server Daemon mysqld?
  5. How Much Memory Does the Server Take?
  6. How To Turn on Query Logs?
  7. How To Turn on Error Logs?
  8. What Is Binary Log File?
  9. How To Turn on Binary Logs?
  10. How To Use mysqlbinlog to View Binary Logs?
  11. How To Run MySQL Server on a Different Port?
  12. How To Connect to MySQL Server on a Different Port?

More...

MySQL Tutorials - PHP Connections and Query Execution

A collection of 18 FAQs on connecting MySQL server with PHP scritps. Clear explanations and tutorial exercises are provided on MySQL server connection; providing port number, user account and password; selecting or creating database; running SQL statements; checking execution errors.

  1. How To Install PHP on Windows?
  2. How To Verify Your PHP Installation?
  3. What Do You Need to Connect PHP to MySQL?
  4. How To Turn on mysql Extension on the PHP Engine?
  5. How To Connect to a MySQL Server with Default Port Number?
  6. How To Connect to a MySQL Server with a Port Number?
  7. How To Connect to MySQL Server with User Accounts?
  8. How To Access MySQL Servers through Firewalls?
  9. How To Get Some Basic Information Back from MySQL Servers?
  10. How To Close MySQL Connection Objects?
  11. How To Get a List of Databases from MySQL Servers?
  12. How To Create a New Database?
  13. What Happens If You Do Not Have Privileges to Create Database?
  14. How To Get MySQL Statement Execution Errors?
  15. How To Drop an Existing Database?
  16. How To Select an Exiting Database?
  17. Can You Select Someone Else Database?
  18. How To Execute a SQL Statement?

More...

MySQL Tutorials - Managing Tables and Running Queries with PHP Scripts

A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on creating and dropping tables; inserting, updating, and deleting rows, selecting and looping through data rows by pages; setting auto-increment IDs.

  1. How To Create a New Table?
  2. How To Get the Number of Rows Selected or Affected by a SQL Statement?
  3. How To Insert Data into an Existing Table?
  4. How To Fix the INSERT Command Denied Error?
  5. How To Insert Multiple Rows with a SELECT Statement?
  6. What Is a Result Set Object?
  7. How To Query Tables and Loop through the Returning Rows?
  8. How To Break Query Output into Pages?
  9. How To Update Existing Rows in a Table?
  10. How To Delete Existing Rows in a Table?
  11. How To Quote Text Values in SQL Statements?
  12. How To Quote Date and Time Values in SQL Statements?
  13. How To Display a Past Time in Days, Hours and Minutes?
  14. How To Perform Key Word Search in Tables?
  15. How To Build WHERE Criteria with Web Form Search Fields?
  16. How To Query Multiple Tables Jointly?
  17. How To Define the ID Column as Auto-Incremented?
  18. How To Get the Last ID Assigned by MySQL?

More...

MySQL Tutorials - Storage Engines: MyISAM, InnoDB and BDB

A collection of 15 tutorial tips on MySQL storage engines. Clear explanations and tutorial exercises are provided on creating tables with MyISAM, InnoDB, and BDB storage engines; checking data files of different storage engines; using MEMORY storage engine for temporary tables.

  1. What Are Storage Engines?
  2. How To Create a New Table Using MyISAM Storage Engine?
  3. Where Table Data Is Stored by the MyISAM Storage Engine?
  4. How To Backup Tables by Copying MyISAM Table Files?
  5. How To Restore Tables by Copying MyISAM Table Files?
  6. How To Check and Repair MyISAM Tables?
  7. How To Create a New Table Using the InnoDB Storage Engine?
  8. Where Table Data Is Stored by the InnoDB Storage Engine?
  9. How To Create a New Table Using the BDB Storage Engine?
  10. How To Start mysqld to Support the BDB Storage Engine?
  11. Where Table Data Is Stored by the BDB Storage Engine?
  12. How To Create a New Table Using the CSV Storage Engine?
  13. How To Create a New Table Using the MEMORY Storage Engine?
  14. What Happens to MEMORY Tables When MySQL Server Is Stopped?
  15. How To See Which Storage Engines Are Supported in Your MySQL Server?

More...

MySQL Tutorials - Transaction Management: Commit or Rollback

A collection of 24 FAQs on MySQL transaction management. Clear answers are provided with tutorial exercises on starting and ending transactions; committing and rolling back transactions; transaction isolation levels: read committed and repeatable read; locks and dead locks.

  1. What Is a Transaction?
  2. How To Start a New Transaction?
  3. How To End the Current Transaction?
  4. How To Create a Table for Transaction Testing?
  5. How To Switch between Autocommit-On and Autocommit-Off Modes?
  6. How To Find Out the Current Transaction Mode?
  7. How To Start a New Transaction Explicitly?
  8. How To Commit the Current Transaction?
  9. How To Rollback the Current Transaction?
  10. What Happens to the Current Transaction If a START TRANSACTION Is Executed?
  11. What Happens to the Current Transaction If a DDL Statement Is Executed?
  12. What Happens to the Current Transaction If the Session Is Ended?
  13. What Happens to the Current Transaction If the Session Is Killed?
  14. How Does MySQL Handle Read Consistency?
  15. What Are Transaction Isolation Levels?
  16. How To View and Change the Current Transaction Isolation Level?
  17. What Is a Data Lock?
  18. How To Experiment Data Locks?
  19. How Long a Transaction Will Wait for a Data Lock?
  20. What Happens to Your Transactions When ERROR 1205 Occurred?
  21. What Is a Dead Lock?
  22. How To Experiment Dead Locks?
  23. What Happens to Your Transactions When ERROR 1213 Occurred?
  24. What Are Impacts on Applications from Locks, Timeouts, and DeadLocks?

More...

MySQL Tutorials - Database Basics and Terminologies

A collection of 20 questions on MySQL database basics and terminlogies to help you review your knowledge. A short answer is provided for each question. Good for job interview preparation.

  1. What Is MySQL?
  2. What Is mSQL?
  3. What Is SQL?
  4. What Is Table?
  5. What Is Column?
  6. What Is Row?
  7. What Is Primary Key?
  8. What Is Foreign Key?
  9. What Is Index?
  10. What Is View?
  11. What Is Join?
  12. What Is Union?
  13. What Is ISAM?
  14. What Is MyISAM?
  15. What Is InnoDB?
  16. What Is BDB (BerkeleyDB)?
  17. What Is CSV?
  18. What Is Transaction?
  19. What Is Commit?
  20. What Is Rollback?

More...

Related Articles:

More...


Other Tutorials/FAQs:

more...


Related Resources:

More...


Selected Jobs:

More...