SQLize
Online
/
PHPize Online
/
SQLtest Online
A
A
A
Share
Donate
Blog
Popular
Donate
A
A
A
Share
Blog
Popular
SQLize.online is a free online SQL environment for quickly running, experimenting with and sharing code.
You can run your SQL code on top of the most popular RDBMS including MySQL, MariaDB, SQLite, PostgreSQL, Oracle and Microsoft SQL Server.
SQL code:
Upload
Copy
Format
Clear
create table tbl_ya ( YABook_Id int identity(1,1) NOT NULL primary key, YoungAdult_Title varchar(150) NOT NULL, YoungAdult_Author varchar(150), Published_Date date, Book_Ratings decimal(12,4), ); create table tbl_fiction ( FictionBook_Id int identity(1,1) NOT NULL primary key, Fiction_Title varchar(150) NOT NULL, Fiction_Author varchar(150), Number_Purchase int, Book_Price decimal(12,4), ); create table tbl_anthology ( AnthologyBook_Id int identity(1,1) NOT NULL primary key, Anthology_Title varchar(150), Anthology_Author varchar(150), Book_Pages int, Publishing_House varchar(150), Book_Stocks int, ); INSERT INTO tbl_ya (YoungAdult_Title, YoungAdult_Author, Published_Date, Book_Ratings) VALUES('Thirteen Reasons Why', 'Jay Asher', '2007-10-18', '4.7'), ('The Fault in Our Star', 'John Green', '2012-01-10', '4.2'), ('Youve Reached Sam', 'Dustin Thao', '2021-11-09', '4.1'), ('All the Bright Places', 'Jennifer Niven', '2015-01-06', '4.1'), ('One of Us is Lying', 'Karen M. McManus', '2017-05-29', '4.0'), ('They Both Die in the End', 'Silvera', '2017-09-05', '4.0'), ('Everything Everything', 'Nicola Yoon', '2015-09-01', '4.0'), ('Red Queen', 'Victoria Aveyard', '2015-02-10', '4.0'), ('We Were Liars', 'E. Lockhart', '2014-05-13', '3.8'), ('Paper Town', 'John Green', '2008-10-16', '3.8'); SELECT * FROM tbl_ya; INSERT INTO tbl_fiction (Fiction_Title, Fiction_Author, Number_Purchase, Book_Price) VALUES('Where the Crawdads Sing', 'Delia Owens', '256356', '240.50'), ('It Ends with Us', 'Colleen Hoover', '234871', '199.64'), ('The Song of Achilles', 'Madeline Miller', '198497', '259.20'), ('The Seven Husbands of Evelyn Hugo', 'Taylor Jenkins Reid', '198296', '357.75'), ('All the Light We Cannot See', 'Anthony Doerr', '197999', '456.10'), ('Circe', 'Madeline Miller', '197789', '249.50'), ('The Kite Runner', 'Khaled Hosseini', '197063', '364.65'), ('People We Meet on Vacation', 'Emily Henry', '196876', '468.25'), ('The Midnight Library', 'Matt Haig', '160534', '189.50'), ('Normal People', 'Sailey Rooney', '149398', '256.75'); SELECT * FROM tbl_fiction; INSERT INTO tbl_anthology (Anthology_Title, Anthology_Author, Book_Pages, Publishing_House, Book_Stocks) VALUES('The Things They Carried', 'Tim OBrien', '233', 'Riverhead Books', '598897'), ('The Tales of Beedle and Bard', 'J.K. Rowling', '157', 'Bloomsburry Publishing PLC', '567643'), ('All Out', 'Mackenzi Lee', '368', 'Harlequin Teen', '498574'), ('Everything Eventual', 'Stephen King', '464', 'Scribner', '406085'), ('Five Tuesday in Winter', 'Lily Kings', '240', 'Groove/ Atlanta Inc', '345989'), ('Fragile Things', 'Neil Gailman', '400', 'William Morow', '289043'), ('Her Body and Other Parties', 'Carmen Maria Mac', '264', 'Graywolf Press', '250000'), ('Dangerous Women', 'George Martin', '784', 'Tor Books', '234647'), ('My True Love Gave To Me', 'Stephanie Perkins', '3127', 'St. Martin Press', '200097'), ('Zombie Vs Unicorn', 'Holly Black', '415', 'Margaret K. McElderly Book', '154674'); SELECT * FROM tbl_Anthology; INSERT INTO tbl_fiction (Fiction_Title,Fiction_Author) SELECT YoungAdult_Title,YoungAdult_Author FROM tbl_ya; SELECT Fiction_Title,Fiction_Author FROM tbl_fiction;
SQL
Server:
MariaDB 11.4
MariaDB 11.5
MariaDB 10
MariaDB 10 Sakila (ReadOnly)
MySQL 5.7
MySQL 5.7 Sakila (ReadOnly)
MySQL 8.0
MySQL 8.0 Sakila (ReadOnly)
SQLite 3
PostgreSQL 10 Bookings (ReadOnly)
PostgreSQL 11
PostgreSQL 12
PostgreSQL 13
PostgreSQL 14
PostgreSQL 15
MS SQL Server 2017
MS SQL Server 2019
MS SQL Server 2022
MS SQL Server 2022 AdventureWorks (ReadOnly)
Firebird 4.0
Firebird 4.0 (Employee)
Oracle Database 19c (HR)
Oracle Database 21c
Oracle Database 23c Free
SOQOL
Version
ER Diagram
Preserve result
Stuck with a problem?
Got Error?
Ask ChatGPT!
Result:
Copy
Clear