Version vom 3. Mai 2010, 15:17 Uhr

Inhaltsverzeichnis

	Befehl	Ergebnis
Standard	chr(65)	'A'
MySQL	char(65)	'A'

	Befehl	Ergebnis
Standard	ascii('A')	65

	Befehl	Ergebnis
Standard	'chunky' \|\| 'bacon'	'chunkybacon'
MySQL	concat('chunky','bacon')	'chunkybacon'

	Befehl	Ergebnis
Standard	replace('funky bacon','funky','chunky')	'chunky bacon'

Beschreibung	Befehl
Standard	SELECT * FROM information_schema.tables;
Firebird	SELECT RDB$RELATION_NAME FROM RDB$RELATIONS;
MySQL (unterstützt Standard ab 5.0)	SHOW TABLES;
SQLite	SELECT * FROM SQLite_Master;
PostgreSQL (unterstützt Standard seit 7.4)	SELECT * FROM pg_tables;
Oracle	SELECT * FROM ALL_TABLES;

Beschreibung	Befehl
Standard	SELECT * FROM information_schema.columns WHERE table_name = '<table_name>';
Firebird	SELECT RDB$FIELD_NAME FROM RDB$RELATION_FIELDS WHERE RDB$RELATION_NAME='<table_name>';
MySQL	SHOW COLUMNS FROM <table>; DESCRIBE <table>;
SQLite	PRAGMA table_info(<table>);
Oracle	DESCRIBE <table>;

Beschreibung	Befehl
Standard	SELECT * FROM information_schema.enabled_roles;
Firebird	SELECT DISTINCT RDB$USER FROM RDB$USER_PRIVILEGES;
MySQL	SELECT * FROM mysql.user;
PostgreSQL (unterstützt außerdem Standard)	SELECT * FROM pg_user;
Oracle	SELECT * FROM ALL_USERS;

Beschreibung	Befehl
Standard	SELECT * FROM information_schema.role_table_grants; SELECT * FROM information_schema.role_column_grants; SELECT * FROM information_schema.role_routine_grants; SELECT * FROM information_schema.role_usage_grants;
Firebird	SELECT * FROM RDB$USER_PRIVILEGES;
MySQL	SHOW GRANTS;