[Tools]  Datenbank: `information_schema`  Tabelle: `EVENTS`

         ---               

SELECT * FROM `EVENTS`

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

Tabellen der Datenbank `information_schema` bearbeiten

Tabelle `EVENTS`

Felder der Tabelle `EVENTS`

		Field	Type	Size	NULL	Key	Attribute	Default	Extra	Sortierung	Kommentar
	1.	EVENT_CATALOG	varchar	64	nein					utf8_general_ci
	2.	EVENT_SCHEMA	varchar	64	nein					utf8_general_ci
	3.	EVENT_NAME	varchar	64	nein					utf8_general_ci
	4.	DEFINER	varchar	189	nein					utf8_general_ci
	5.	TIME_ZONE	varchar	64	nein					utf8_general_ci
	6.	EVENT_BODY	varchar	8	nein					utf8_general_ci
	7.	EVENT_DEFINITION	longtext		nein					utf8_general_ci
	8.	EVENT_TYPE	varchar	9	nein					utf8_general_ci
	9.	EXECUTE_AT	datetime		ja
	10.	INTERVAL_VALUE	varchar	256	ja					utf8_general_ci
	11.	INTERVAL_FIELD	varchar	18	ja					utf8_general_ci
	12.	SQL_MODE	varchar	8192	nein					utf8_general_ci
	13.	STARTS	datetime		ja
	14.	ENDS	datetime		ja
	15.	STATUS	varchar	18	nein					utf8_general_ci
	16.	ON_COMPLETION	varchar	12	nein					utf8_general_ci
	17.	CREATED	datetime		nein
	18.	LAST_ALTERED	datetime		nein
	19.	LAST_EXECUTED	datetime		ja
	20.	EVENT_COMMENT	varchar	64	nein					utf8_general_ci
	21.	ORIGINATOR	bigint	10	nein
	22.	CHARACTER_SET_CLIENT	varchar	32	nein					utf8_general_ci
	23.	COLLATION_CONNECTION	varchar	32	nein					utf8_general_ci
	24.	DATABASE_COLLATION	varchar	32	nein					utf8_general_ci

Indizes der Tabelle `EVENTS`