SQLize | PHPize | SQLtest

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 SUBSTRING ( 'iceland' FROM 6 FOR 5) FROM books;