image source : (takethiscourse)
Definition
SQL is a structured query language designed to retrieve and manage data in relational database.
There are four basic SQL operations
SELECT – selects data from database tables.
UPDATE – updates existing data into database tables.
INSERT – inserts new data into database tables.
DELETE – deletes existing data from database tables.
Simple Examples of SQL query:
SELECT
SELECT * FROM Users;
UPDATE
UPDATE Users
SET name="Nimal"
WHERE userID=1;
INSERT
INSERT INTO table_name(colum1,colum2)
VALUES (value1,value2);
DELETE
DELETE
FROM Users
WHERE userID=1;
You can work with SQL when installing database software .
0 Comments