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
DROP TABLE IF EXISTS Customers; CREATE TABLE Customers (cust_id CHAR (15) NOT NULL , cust_name VARCHAR (100) NOT NULL , cust_address VARCHAR (40) , cust_city VARCHAR (50) NOT NULL , cust_state VARCHAR (5) NOT NULL , cust_zip VARCHAR (10) NOT NULL , cust_country VARCHAR (50) NOT NULL , cust_contact VARCHAR (50) NOT NULL , cust_email VARCHAR (255) ); INSERT INTO Customers VALUES ("1000000001", "Village Toys", "200 Maple Lane","Detroit","MI","44444","USA","John Smith","sales@villagetoys.com"), ("1000000002", "Kids Place","333 South Lake Drive", "Columbus","OH","43333","USA","Michelle Green", NULL), ("1000000003", "Fun4All","1 Sunny Place", "Muncie","IN","42222","USA","Jim Jones","jjones@fun4all.com"), ("1000000004", "Fun4All", "829 Riverside Drive","Phoenix","AZ","88888","USA","Denise L. Stephens","dstephens@fun4all.com"), ("1000000005", "The Toy Store", "4545 53rd Street","Chicago","IL","54545","USA","Kim Howard", NULL) ; SELECT "Customers Table Content:" FROM Customers WHERE 1 = 0; SELECT * FROM Customers; SELECT * FROM Customers WHERE cust_email RLIKE '[sjd]'; DROP TABLE IF EXISTS Vendors; CREATE TABLE Vendors (vend_id CHAR (10) NOT NULL , vend_name VARCHAR (50) NOT NULL , vend_address VARCHAR (50) , vend_city VARCHAR (50) NOT NULL , vend_state VARCHAR (5) , vend_zip VARCHAR (10) NOT NULL , vend_country VARCHAR (50) NOT NULL ); INSERT INTO Vendors VALUES ("BRS01", "Bears R Us", "123 Main Street","Bear Town", "MI", "44444","USA"), ("BRS02", "Bear Emporium","500 Park Street", "Anytown ","OH","43333","USA"), ("DLL01", "Doll House Inc.","555 High Street", "Dollsville ","CA","99999","USA"), ("FRB01", "Furball Inc.", "1000 5th Avenue", "New York","NY","11111","USA"), ("FNG01", "Fun and Games", "42 Galaxy Road", "London", NULL,"N166PS","England"), ("JTS01", "Jouets et ours", "1 Rue Amusement", "Paris", NULL,"45678","France") ; SELECT "Vendors Table Content:" FROM Vendors WHERE 1 = 0; SELECT * FROM Vendors; SELECT CONCAT (vend_name, ' ', vend_address) FROM Vendors; SELECT RTRIM(vend_name, ' ') CONCAT(vend_name, ' ' , vend_address) FROM Vendors; DROP TABLE IF EXISTS Orders; CREATE TABLE Orders (order_num int (11) NOT NULL , order_date datetime NOT NULL , order_id VARCHAR (10) ); INSERT INTO Orders VALUES ("20005", "2004-05-01 00:00:00", "1000000001"), ("20006", "2004-01-12 00:00:00","1000000003"), ("20007", "2004-01-30 00:00:00","1000000004"), ("20008", "2004-02-03 00:00:00", "1000000005"), ("20009", "2004-02-08 00:00:00", "1000000001") ; SELECT "Orders Table Content:" FROM Orders WHERE 1 = 0; SELECT * FROM Orders; DROP TABLE IF EXISTS OrderItems; CREATE TABLE OrderItems (order_num int (11) NOT NULL , order_item int(11) NOT NULL , prod_id VARCHAR (10) , quantity int (11) , item_price decimal (8,2) ); INSERT INTO OrderItems VALUES ("20005", "1", "BR01", "100", "5.49"), ("20005", "2","BR03", "100", "10.99"), ("20006", "1","BR01", "20", "5.99"), ("20006", "2", "BR02", "10", "8.99"), ("20006", "3", "BR03", "10", "11.99"), ("20007", "1", "BR03", "50", "11.49"), ("20007", "2", "BNBG01", "100", "2.99"), ("20007", "3", "BNBG02", "100", "2.99"), ("20007", "4", "BNBG03", "100", "2.99"), ("20007", "5", "RGAN01", "50", "4.49"), ("20008", "1", "RGAN01", "5", "4.49"), ("20008", "2", "BR03", "5", "11.99"), ("20008", "3", "BNBG01", "10", "3.49"), ("20008", "4", "BNBG02", "10", "3.49"), ("20008", "5", "BNBG03", "10", "3.49"), ("20009", "1", "BNBG01", "250", "2.49"), ("20009", "2", "BNBG02", "250", "2.49"), ("20009", "3", "BNBG03", "250", "2.49") ; SELECT "OrderItems Table Content:" FROM OrderItems WHERE 1 = 0; SELECT * FROM OrderItems;
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