what is sql
snippet in sql

what is sql

user1437

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/

what is sql

user7096

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.

what is sql

user2793

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.

what is SQL

user7233

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.

SQL

user6168

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

user8546

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