SQL COMMANDS

---

Update/Set/Where

Delete From

Create Table

Insert Into

Select/From/Where

Order by

Join criteria

​Here is a list of the SQL commands that you will need to know for the edexcel computer science GCSE. Make sure that you have SQL downloaded and installed on your computer. If you need help with this, follow the help guide here.

Name	Command
​Update/Set/Where	UPDATE TableName SET (ColumnName =Value, …) WHERE <condition>;
Delete From	DELETE FROM TableName [WHERE <condition>];
Create Table	CREATE TABLE TableName (ColumnName data type, ….);
Insert Into	INSERT INTO TableName VALUES (Value, ….);
Select/From/Where	SELECT ColumnNam) FROM TableName WHERE ColumnName LIKE pattern;
Order by	SELECT (ColumnName, …) FROM TableName [WHERE <condition>] [ORDER BY (ColumnName, …)];
Join criteria	​SELECT (ColumnName, …) FROM TableName, TableName, … [WHERE <join criteria>] [ORDER BY (ColumnName, …)]; Retrieves data from two related table.

Think you know it? Test yourself here

---

Useful websites

SQLZoo
​W3Schools
​Code Academy
Code Mentor