Übersicht der Befehle (sqlite, MySQL, Postgres, Oracle)

../_images/mond.jpg

Befehl

Sqlite

MySql

Postgres

Oracle

select current_database();

x

SELECT DATABASE();

x

TABLE …

ALTER TABLE …

x

x

x

x

CREATE TABLE

x

x

x

x

DECLARE LOCAL TEMPORARY TABLE

DROP TABLE

SELECT

x

x

x

x

INSERT …

x

x

x

x

UPDATE …

x

x

x

x

T1 LEFT JOIN T2 on …

x

x

x

x

T1 RIGHT JOIN T2 on …

x

x

x

T1 FULL JOIN T2 on …

x

x

x

T1 as t1 SELF JOIN T1 as t2 on …

x

x

x

ADD

ALLOCATE CURSOR

ALTER DOMAIN

ALTER ROUTINE

ALTER SEQUENCE

GENERATOR

AETER TRANSFORM

ALTER TYPE

CALL

CLOSE

COMMIT

CONNECT

CREATE

CREATE ASSERTION

CREATE CAST

CREATE CHARACTER SET

CREATE COLLATION

CREATE DATABASE (Postgres)

x

CREATE DOMAIN

CREATE FUNCTION

CREATE INDEX (Constraints/Postgres)

x

x

x

x

CREATE METHOD

CREATE ORDERING

CREATE PROCEDURE

CREATE ROLE

CREATE SCHEMA

CREATE SEQUENCE

CREATE TRANSFORM

CREATE TRIGGER

CREATE TYPE

CREATE VIEW

DEALLOCATE DESCRIPTOR

DEALOCATE PREPARE

DECLARE

DELETE

DESCRIBE INPUT

DESCRIBE OUTPUT

DISCONNECT

DROP

DROP ASSERTATION

DROP ATTRIBUTE

DROP CAST

DROP CHARACTER SET

DROP COLLATION

DROP COLUMN

DROP CONSTRAINT

DROP DEFAULT

DROP DOMAIN

DROP METHOD

DROP ORDERING

DROP ROLE

DROP ROUTINE

DROP SCHEMA

DROP SCOPE

DROP SEQUENCE

DROP TRANSFORM

DROP TRANSLATIONION

DROP TRIGGER

DROP TYPE

DROP VIEW

EXECUTE IMMEDIATE

FETCH

FREE LOCATOR

GET DESCRIPTOR

GET DIAGNOSTICS

GRANT PRIVILEGE

GRAN ROLE

HOLD LOCATOR

INSERT

MERGE

OPEN

REPLACE

RELEASE SAVEPOINT

RETURN

REVOKE

ROLLBACK

SAVEPOINT

SELECT

SET CATALOG

SET CONNECTION

SET CONSTRAINTS

SET DESCRIPTOR

SET NAMES

SET PATH

SET SCHEMA

SET SESSION AUTHORIZATION

SET SESSION CHARACTERISTICS

SET SESSION COLLATION

seT TIME ZONE

SET TRANSACTION

SET TRANSFORM GROUP

START TRANSACTION

UPDATE