SQL

Learn more about SQL by reading up on these informative articles, tutorials, and code snippets on Orangeable.

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

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

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.

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

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