Answers for "sql programming language"

SQL
9

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;
Posted by: Guest on May-25-2020
5

sql

SQL is a domain-specific language used in programming and designed for managing
data held in a relational database management system, or for stream processing
in a relational data stream management system.
Posted by: Guest on June-16-2020
0

what sql language

1- Data Manipulation Language(DML)-(SELECT, INSTERT, UPDATE...)
DML statements affect records in table. These are
basic operations we perform on data such as selecting
few records from a table, inserting new records,
deleting unnecessary records, updating existing records.

2-Data Definition Language (CREATE , ALTER , DROP)...
DDL statements are used to modify database or
table schema. These statements handle the design
and storage of database objects.

3-Data Control Language (GRANT , REVOKE)...
DCL statements control the level of access that
users have on database objects

4- Transaction Control Language (BEGIN TRAN, COMMIT TRAN, ROLLBACK)...

TCL statements allows us to control and manage
transactions to maintain the integrity of data
withing SQL statements.
Posted by: Guest on January-27-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language