[Tools]  Datenbank: `mysql`  Tabelle: `proc`

         ---               

SELECT * FROM `proc`

Die Ausführung von SQL-Befehlen kann Daten manipulieren! Der Autor übernimmt keine Haftung bei Datenverlusten.

Tabellen der Datenbank `mysql` bearbeiten

Tabelle `proc`

Felder der Tabelle `proc`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	db	char	64	nein					utf8_bin
	2.	name	char	64	nein					utf8_general_ci
	3.	type	enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE		nein		BODY')			utf8_general_ci
	4.	language	enum('SQL')		nein			SQL		utf8_general_ci
	5.	sql_data_access	enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA')		nein			CONTAINS_SQL		utf8_general_ci
	6.	security_type	enum('INVOKER','DEFINER')		nein			DEFINER		utf8_general_ci
	7.	param_list	blob		nein
	8.	returns	longblob		nein
	9.	created	timestamp		nein			current_timestamp()	on update current_timestamp()
	10.	modified	timestamp		nein			0000-00-00 00:00:00
	11.	sql_mode	set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT')		nein					utf8_general_ci
	12.	collation_connection	char	32	ja					utf8_bin
	13.	db_collation	char	32	ja					utf8_bin
	14.	aggregate	enum('NONE','GROUP')		nein			NONE		utf8_general_ci

Indizes der Tabelle `proc`

		Name	Spalten	Größe	Typ	Duplikate erlaubt	Kardinalität	Kommentar
	1.	PRIMARY	db		BTREE	nein	1
	2.	PRIMARY	name		BTREE	nein	2
	3.	PRIMARY	type		BTREE	nein	2