Skip to Content
MySQL icon


Learn more about MySQL with these informative tutorials, articles, and code examples!

Thumbs up icon Top Posts

How to Define A Custom ORDER BY in MySQL

Learn how to define a custom ORDER BY statement in MySQL with the ORDER BY FIELD clause.

Safe Updates in MySQL to Prevent Accidental Queries

Enable safe updates in MySQL to prevent accidental UPDATE and DELETE query executions.

Create A MySQL Database: Command Line & Workbench

This tutorial will show you how to create a MySQL database using the command line and MySQL Workbench.

Down arrow icon More Posts

How to Calculate Time Difference with MySQL

Learn how to calculate the time difference between two unique date and time strings in MySQL with TIMESTAMPDIFF().

Format Dates in MySQL with the DATE_FORMAT() Method

This tutorial will teach you how to format dates in many different ways with MySQL and the DATE_FORMAT() function.

How to Get the Size of a MySQL Database

This quick tutorial will show you how to get the sizes of all MySQL databases on a single connection, or specific databases.

How to Define an Auto Increment Primary Key in MySQL

Learn how auto-increment works with primary keys and how to use them when creating and altering tables in a MySQL database.

How to Duplicate Table Structures & Data in MySQL

In this tutorial, we'll cover duplicating MySQL table structures and copying all data to a new table with just a few commands.

Backup & Restore MySQL Databases with mysqldump

Learn how to backup and restore MySQL databases using the mysqldump utility in the command line.

MySQL Proximity Search with US Zip Codes

Learn how to run a proximity search with MySQL using some built-in functions, US zip codes, latitude, and longitude.

MySQL LIMIT and OFFSET Clauses: ResultSet Pagination

Divide your resultsets into chunks for better page optimization and user experiences using MySQL LIMIT and OFFSET the clauses.