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.