
What is an SQL statement?
SQL statements allow us to instruct a database on actions to be performed. These actions may include adding, updating, retrieving and deleting records stored in a database.
SQL statements use keywords to specify actions required.
Examples of some commonly used SQL statements
Create a new database
CREATE DATABASE databaseName;
Create a new table to store records in a database
CREATE TABLE tableName
(ColumnName DataType, ...);
Retrieve records from a database table
SELECT * FROM databaseTable;
Modify an existing record in a database table
ALTER TABLE
ADD columnName DataType;
Delete a record from a database table
DELETE FROM tableName WHERE condition...