Answers for "sql \"

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
1

sql

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

sql

SQL stands for:
Structured Query Language

It's language which enables a user to create,
modify and essentially interact with a database.
As a tester we are usually using Data manipulation
language part of SQL

SQL has 2 parts:
1-DATA MANIPULATION LANGUAGE
It is used to add, retrieve or update the data.
= insert, select, update, delete

2-DATA DEFINITION LANGUAGE
It is used to create database schema and can
be used to define some constraints as well.	
=create, alter, drop, truncate

create table
create window etc.
Posted by: Guest on January-07-2021
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