1. SELECT
Used to retrieve data from a table.
Select * from World Where debt_ridden_people = 1
2. DELETE
Used to delete data from a table.
DELETE from Players where doll_detects_motion = 1
3. UPDATE
Used to modify data within a table.
UPDATE SquidGame Set Count = 254
4. CREATE
Used to create database, table, index, Procedure etc.
CREATE DATABASE SquidGame CREATE TABLE Players { Id int, FirstName varchar (255), LastName varchar (255) }; CREATE TABLE Soldiers{ Id int, FirstName varchar (255), LastName varchar (255) , ShapId int};
5. INSERT
Used to insert new data into a database.
INSERT INTO Players values (218, 'Sang', 'Woo'); INSERT INTO Players values (456, 'Gi', 'Hun');
6. ALTER
Used to modify anĀ database or table with a new Data Structure.
ALTER TABLE Players ADD play_or_not BIT
7. DROP
Used to remove the database or table object from the System.
DROP TABLE Creator;