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.