Learn Basic SQL using SQUID GAME

  • Post category:SQL
  • Reading time:2 mins read

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;
Post Views: 631

Leave a Reply