Answers for "what SQL"

what is sql

Structured Query Language

A language which enables a user to create, modify and
essentially interact with a database.
Two of the most common Database Management Engines are
MySQL: https://www.mysql.com/
PostgreSQL: https://www.postgresql.org/

whats sql

SQL stands for Structured Query Language. It’s the language of choice on today’s web for storing,
manipulating and retrieving data within relational databases. Most, if not all of the websites you visit
will use it in some way.
Using SQL, you are able to interact with the database by writing queries, which when executed,
return any results which meet its criteria.

SQL

CREATE TABLE friends (
   id INTEGER,
   name TEXT,
   birthday DATE
);

INSERT INTO friends (id, name, birthday) 
VALUES (1, 'Jane Doe', '1990-05-30');


INSERT INTO friends(id , name , birthday)
VALUES(2 , 'APOORV' , '2000-2-2');



UPDATE friends
SET name = 'Jane Srivastava'
WHERE id = 1;

ALTER TABLE friends 
ADD COLUMN email TEXT; 


UPDATE friends 
SET email =  '203029@klsafjls'
where id  = 1; 

UPDATE friends 
SET email =  '203029@klsafjls'
where id  = 2;

DELETE FROM friends 
WHERE id = 1;


SELECT * 
FROM friends;

what is sql

SQL is basically a programming language that lets people manipulate databases.