SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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')); DECLARE name CHAR(), age INTEGER; SET name = "Mark"; SET age = 18; PRINT "name:"name; PRINT "age:"age;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear