CREATE TABLE books (id INTeger PRIMARY KEY ,
name TEXT,
year_of_issue YEAR,
author TEXT);
INSERT INTO books (id, name, year_of_issue, author)
VALUES (1, "pirots of the carribian", 2011, "Konan dole");
INSERT INTO books (id, name, year_of_issue, author)
VALUES (2, "box of treasures", 1999, "duma");
INSERT INTO books (id, name, year_of_issue, author)
VALUES (3, "iceland", 2004, "marks");
SELECT * FROM books;
UPDATE books SET name = " iceland" WHERE name = "iceland";
SELECT LTRIM(name) FROM books WHERE id = 3;
ALTER TABLE books MODIFY COLUMN name NVARCHAR(200);
SELECT LOCATE('rr', name) FROM books WHERE id=1;
SELECT LEFT (name, 6) FROM books WHERE id=1;
SELECT right (name, 6) FROM books WHERE id=1;
SELECT REPLACE('pirots of the carribian', 'the carribian', 'somali') FROM books
WHERE id = 1 ;
SELECT REVERSE(name ) FROM books;
SELECT UPPER (name) FROM books;
SELECT LOWER (name) FROM books;
SELECT SYSDATE();
SELECT YEAR(DATEDIFF( '2022-08-04','1993-10-06'));
CREATE PROCEDURE procc
BEGIN
DECLARE @name CHAR(), @age INTEGER;
SET @name = "Mark"; SET @age = 18;
SELECT CONCAT(@name,' ', @age)
END;
Telegram: DB developers channel