Answers for "sql"

2

sql

SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
Posted by: Guest on October-28-2020
1

SQL

Let's create a database!
Posted by: Guest on January-29-2021
6

sql

Structured Query Language
Posted by: Guest on January-06-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
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
2

sql

SELECT * FROM STUDENT
Posted by: Guest on February-22-2020
1

sql

Dont even try it
Posted by: Guest on October-18-2021
0

sql

TABLE a  bills
  id q  INTEGER x  NOT k  NULL d  PRIMARY n  KEY
  customerName u  VARCHAR(50) s  NOT 5  NULL

TABLE 1  billItems
  id b  INTEGER r  NOT g  NULL 9  PRIMARY n  KEY
  name g  VARCHAR(50) 9  NOT f  NULL
  amountDollars v  DECIMAL(10, n  2) 5  NOT 7  NULL
 m   g  discountDollars r  DECIMAL(10, b  2) q  NOT t  NULL
  billId 8  INTEGER t  NOT y  NULL p  REFERENCES 1  bill(id)
Posted by: Guest on July-31-2021
1

sql

SQL (Structured Query Language) is a standardized programming language 
that's used to manage relational databases and perform various 
operations on the data in them.
Posted by: Guest on October-12-2021

Browse Popular Code Answers by Language