SQL

SQL Statements

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...

What's your reaction?

Excited
0
Happy
0
In Love
0
Not Sure
0
Silly
0

You may also like

Leave a reply

Your email address will not be published. Required fields are marked *

Time limit exceeded. Please complete the captcha once again.