PG(HGDB)里支持多个sql语句在同一行中间用分号隔开
highgo=# select version();
version
------------------------------------
HighGo Database 3.1.4 Linux 64-bit
(1 row)
Time: 3.981 ms
highgo=# create database testa;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
CREATE DATABASE
Time: 257.170 ms
Time: 0.058 ms
Time: 0.026 ms
Time: 0.023 ms
Time: 0.021 ms
Time: 0.021 ms
Time: 0.021 ms
Time: 0.020 ms
Time: 0.020 ms
Time: 0.021 ms
Time: 0.022 ms
Time: 0.021 ms
Time: 0.021 ms
Time: 0.020 ms
Time: 0.021 ms
Time: 0.020 ms
Time: 0.020 ms
Time: 0.022 ms
Time: 0.022 ms
Time: 0.021 ms
Time: 0.020 ms
Time: 0.413 ms
Time: 0.032 ms
Time: 0.021 ms
Time: 0.019 ms
Time: 0.020 ms
Time: 0.019 ms
Time: 0.019 ms
Time: 0.019 ms
Time: 0.019 ms
Time: 0.019 ms
Time: 0.020 ms
highgo=# drop database testa;
DROP DATABASE
Time: 107.047 ms
highgo=#
highgo=#
highgo=#
highgo=# create database testa;create database testb;
CREATE DATABASE
Time: 259.213 ms
CREATE DATABASE
Time: 243.738 ms
highgo=#
highgo=# drop database testa;
DROP DATABASE
Time: 107.094 ms
highgo=# drop database testb;
DROP DATABASE
Time: 114.084 ms
highgo=# create databa testa;create database testb;
错误: 语法错误 在 "databa" 或附近的-----前一个语句失败了，后一个还能成功。
LINE 1: create databa testa;
^
Time: 0.305 ms
CREATE DATABASE
Time: 246.737 ms
[email protected][local]:5432 postgres# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)
Time: 2.934 ms
[email protected][local]:5432 postgres# create database testa;create database testb;;;;;;;;;;;;;;;;;;;
CREATE DATABASE
Time: 269.879 ms
CREATE DATABASE
Time: 265.452 ms
Time: 0.034 ms
Time: 0.015 ms
Time: 0.013 ms
Time: 0.014 ms
Time: 0.013 ms
Time: 0.013 ms
Time: 0.014 ms
Time: 0.013 ms
Time: 0.013 ms
Time: 0.031 ms
Time: 0.013 ms
Time: 0.013 ms
Time: 0.012 ms
Time: 0.013 ms
Time: 0.012 ms
Time: 0.013 ms
Time: 0.013 ms
Time: 0.013 ms
[email protected][local]:5432 postgres# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-------------+----------+-------------+-------------+---------------------------------
postgres | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/"postgres9.6" +
| | | | | "postgres9.6"=CTc/"postgres9.6"
template1 | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/"postgres9.6" +
| | | | | "postgres9.6"=CTc/"postgres9.6"
test | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
testa | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
testb | postgres9.6 | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
(6 rows)
Oracle中不支持这种写法：
DB2数据库在toad里也支持这种写法：
DB2在db2命令提示符下执行也不支持多个sql语句在同一行的写法：