It implements the SQL language, allowing you to write queries using its syntax to manage MySQL databases. MySQL meanwhile is a database system that runs on a server. It outlines syntax that allows you to write queries that manage relational databases. It’s important that you don’t confuse this with SQL itself, as there’s a clear difference. Of course, these examples demonstrate only a very small selection of what the SQL language is capable of. VALUES ('Tester', 'Jester', '123 Fake Street, Sheffield, United Kingdom', if you were to rerun the query to return all data from the user’s table, the results set would look like this: Here’s a basic example adding a new user to the users table:- INSERT INTO users (first_name, last_name, address, email) Using the INSERT INTO statement, we can add new data to a table. The use of the ORDER BY keyword means the results will be ordered using the stock_count column, lowest values to highest. This query would return all data from the products table with a stock_count value of less than 10 in its results set. SELECT * FROM products WHERE stock_count <= 10 ORDER BY stock_count ASC We can add a bit of complexity to a standard SELECT statement by adding a WHERE clause, which allows you to filter what gets returned. If we were to replace the asterisk wildcard character (*) with specific column names instead, only the data from these columns would be returned from the query.

It would then return data like the below, which is typically called a results set:. Using this SELECT statement, the query selects all data from all columns in the user’s table. Here’s an example query:- SELECT * FROM users Using SQL, you are able to interact with the database by writing queries, which when executed, return any results which meet its criteria. This example in particular stores e-commerce information, specifically the products on sale, the users who buy them, and records of these orders which link these 2 entities. Here’s what a basic relational database looks like. Most, if not all of the websites you visit will use it in some way, including this one.

It’s the language of choice on today’s web for storing, manipulating and retrieving data within relational databases. SQL stands for Structured Query Language. Infographic Version of SQL Cheat Sheet (PNG) Use this as a quick reference during development, a learning aid, or even print it out and bind it if you’d prefer (whatever works!).īut before we get to the cheat sheet itself, for developers who may not be familiar with SQL, let’s start with… PDF Version of SQL Cheat Sheet Hopefully, it will help developers – both beginner and experienced level – become more proficient in their understanding of the SQL language. In this guide, you’ll find a useful cheat sheet that documents some of the more commonly used elements of SQL, and even a few of the less common.

My mac cheat sheet doc