Answers for "sql basics"

SQL
2

what is SQL

SQL full form is a structured query language, and it allows you to interact through commands with the database. Here are some of the SQL Database functions:

This allows users to retrieve information from the relational database.
It enables the development of tables and databases.
It allows data base and tables to be modified, added, removed, and changed.
It gives protection, and allows permission to be set.
Allows new ways for people to manage the info.
Posted by: Guest on January-21-2021
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
1

sql

SQL - the standard language to communicate with DBMS.
Posted by: Guest on October-20-2020
2

what is sql

SQL is basically a programming language that lets people manipulate databases.
Posted by: Guest on October-03-2020
0

SQL

Dont use SQL it sucks
Posted by: Guest on November-04-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language