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 `发受电量` ( `日期` datetime DEFAULT NULL, `名称` varchar(255) DEFAULT NULL, `统调核电上网电量` decimal(10,2) DEFAULT NULL, `统调水电上网电量` decimal(10,2) DEFAULT NULL, `统调火电上网电量` decimal(10,2) DEFAULT NULL, `统调上网电量` decimal(10,2) DEFAULT NULL, `全电量中调` decimal(10,2) DEFAULT NULL, `地方发电量中调` decimal(10,2) DEFAULT NULL, `统调发受电量中调` decimal(10,2) DEFAULT NULL, `统调受电量中调` decimal(10,2) DEFAULT NULL, `总计中调发电` decimal(10,2) DEFAULT NULL, `蓄能中调发电` decimal(10,2) DEFAULT NULL, `风力发电中调发电` decimal(10,2) DEFAULT NULL, `核电中调发电` decimal(10,2) DEFAULT NULL, `火电合计中调发电` decimal(10,2) DEFAULT NULL, `其它火电中调发电` decimal(10,2) DEFAULT NULL, `燃煤火电中调发电` decimal(10,2) DEFAULT NULL, `水电中调发电` decimal(10,2) DEFAULT NULL, `还原电量` decimal(10,2) DEFAULT NULL, `统调发受电量` decimal(10,2) DEFAULT NULL, `统调受电量` decimal(10,2) DEFAULT NULL, `总计统调发电` decimal(10,2) DEFAULT NULL, `蓄能统调发电` decimal(10,2) DEFAULT NULL, `核电统调发电` decimal(10,2) DEFAULT NULL, `风力发电统调发电` decimal(10,2) DEFAULT NULL, `火电合计统调发电` decimal(10,2) DEFAULT NULL, `其它火电统调发电` decimal(10,2) DEFAULT NULL, `燃煤火电统调发电` decimal(10,2) DEFAULT NULL, `水电统调发电` decimal(10,2) DEFAULT NULL, `其他` decimal(10,2) DEFAULT NULL, `统调风力发电上网电量` decimal(10,2) DEFAULT NULL, `太阳能统调发电` decimal(10,2) DEFAULT NULL, `其他统调发电` decimal(10,2) DEFAULT NULL, `太阳能中调发电` decimal(10,2) DEFAULT NULL, `生物质统调发电` decimal(10,2) DEFAULT NULL, `统调还原后发受电量` decimal(10,2) DEFAULT NULL, `太阳能含分布式光伏统调发电` decimal(10,2) DEFAULT NULL, `总计含分布式光伏统调发电` decimal(10,2) DEFAULT NULL, `统调发受电量含分布式光伏` decimal(10,2) DEFAULT NULL, `统调集中式光伏` decimal(10,2) DEFAULT NULL, `统调分布式光伏` decimal(10,2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
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