SQL

Learn more about SQL with these informative articles, tutorials, and code snippets!

MySQL allows the ability to prevent accidental UPDATE and DELETE query executions by enabling a safe updates feature.

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

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

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

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

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

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

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

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

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

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