SHOW CREATE EVENT
Sintassi
SHOW CREATE EVENT nome_evento
Spiegazione
Mostra l'istruzione CREATE EVENT
necessaria per ricreare l'evento specificato, oltre all'SQL_MODE che era attivo al momento della creazione e il set di caratteri che era usato dalla connessione..
L'output di questa istruzione è influenzato in maniera inaffidabile dalla variabile sql_quote_show_create - si veda http://bugs.mysql.com/bug.php?id=12719 in proposito.
Esempi
mysql> SHOW CREATE EVENT test.e_daily\G *************************** 1. row *************************** Event: e_daily sql_mode: time_zone: SYSTEM Create Event: CREATE EVENT `e_daily` ON SCHEDULE EVERY 1 DAY STARTS CURRENT_TIMESTAMP + INTERVAL 6 HOUR ON COMPLETION NOT PRESERVE ENABLE COMMENT 'Saves total number of sessions then clears the table each day' DO BEGIN INSERT INTO site_activity.totals (time, total) SELECT CURRENT_TIMESTAMP, COUNT(*) FROM site_activity.sessions; DELETE FROM site_activity.sessions; END character_set_client: latin1 collation_connection: latin1_swedish_ci Database Collation: latin1_swedish_ci
Commenti
Sto caricando i commenti......
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.