SQL

SQL

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.