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 indexSQL
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;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.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)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.Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
