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

How to 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.