Basic SQL commands

Basic SQL commands

SELECT – To extract data from the database
UPDATE – updates data in the database
DELETE – deletes data from the database
INSERT INTO – inserts new data into the database

CREATE DATABASE – creates a new database
ALTER DATABASE – modifies a database
CREATE TABLE – creates a new table
ALTER TABLE – modifies a table
DROP TABLE – deletes a table

CREATE INDEX – creates an index
DROP INDEX – deletes an index

Basic SQL commands was last modified: October 1st, 2017 by Justin Antony

About Justin Antony

Leave a Reply