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 Cred_emp_regi_t7 (eid number(6) , Firstname varchar2(35) , Lastname varchar2(25) , Mobile varchar2(16), address varchar2(35) ); describe Cred_emp_regi_t7; 101 Yusuf Tamboli 9766545454 Pune 102 Priya Patil 9878787878 Mumbai 103, Priti Singh +91-9878787878 Delhi 104 Amit Singh +91-9878787878 Delhi 106 yusuf tamboli +91-9878787878 Delhi insert into Cred_emp_regi_t7 values (101, 'Yusuf','Tamboli', 9766545454,'Pune'); insert into Cred_emp_regi_t7 values (102, 'Priya','Patil',9878787878,'Mumbai'); insert into Cred_emp_regi_t7 values (103, 'Priti','Singh','+91-9878787878','Delhi'); insert into Cred_emp_regi_t7 values (104, 'Amit','Singh', '+91-9878787878','Delhi'); insert into Cred_emp_regi_t7 values (106, ' ','tamboli','+91-9878787878','Delhi'); select * from Cred_emp_regi_t7; UPDATE TABLE update Cred_emp_regi_t7 set mobile=8668685713 where eid=104; ADD COLUMN alter table Cred_emp_regi_t7 add country VARCHAR2(50); select *from Cred_emp_regi_t7 DESCRIBE TABLE desc Cred_emp_regi_t7 TABLE MODIFY alter table Cred_emp_regi_t7 modify eid number(10); select * from country; select * from customer; select * from country inner join customer on country. country_id=customer.country_id; select * from country right join customer on country. country_id=customer.country_id; select * from country left join customer on country. country_id=customer.country_id; select * from country full join customer on country. country_id=customer.country_id select * from country join customer on country. country_id=customer.country_id;
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