SQL-Browser

[Tools]  Database: `information_schema`  Table: `TRIGGERS`

   show less  show more             Upload SQL file   Search   MySQl Documentation
The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

Tables of Database `information_schema` edit
create table:
copy table:
select table:     

 

Table `TRIGGERS`
Table properties of `TRIGGERS` (22 Fields)Name
Engine
Row Format
Charset
Collation
Comment
 

 

Fields of table `TRIGGERS`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.TRIGGER_CATALOGvarchar512noutf8_general_ci
edit field  delete field  2.TRIGGER_SCHEMAvarchar64noutf8_general_ci
edit field  delete field  3.TRIGGER_NAMEvarchar64noutf8_general_ci
edit field  delete field  4.EVENT_MANIPULATIONvarchar6noutf8_general_ci
edit field  delete field  5.EVENT_OBJECT_CATALOGvarchar512noutf8_general_ci
edit field  delete field  6.EVENT_OBJECT_SCHEMAvarchar64noutf8_general_ci
edit field  delete field  7.EVENT_OBJECT_TABLEvarchar64noutf8_general_ci
edit field  delete field  8.ACTION_ORDERbigint4no0
edit field  delete field  9.ACTION_CONDITIONlongtextyesutf8_general_ci
edit field  delete field  10.ACTION_STATEMENTlongtextnoutf8_general_ci
edit field  delete field  11.ACTION_ORIENTATIONvarchar9noutf8_general_ci
edit field  delete field  12.ACTION_TIMINGvarchar6noutf8_general_ci
edit field  delete field  13.ACTION_REFERENCE_OLD_TABLEvarchar64yesutf8_general_ci
edit field  delete field  14.ACTION_REFERENCE_NEW_TABLEvarchar64yesutf8_general_ci
edit field  delete field  15.ACTION_REFERENCE_OLD_ROWvarchar3noutf8_general_ci
edit field  delete field  16.ACTION_REFERENCE_NEW_ROWvarchar3noutf8_general_ci
edit field  delete field  17.CREATEDdatetimeyes
edit field  delete field  18.SQL_MODEvarchar8192noutf8_general_ci
edit field  delete field  19.DEFINERvarchar77noutf8_general_ci
edit field  delete field  20.CHARACTER_SET_CLIENTvarchar32noutf8_general_ci
edit field  delete field  21.COLLATION_CONNECTIONvarchar32noutf8_general_ci
edit field  delete field  22.DATABASE_COLLATIONvarchar32noutf8_general_ci

Indexes of table `TRIGGERS`
  Name Columns Size Type Duplicates allowed Cardinality Comment
No Indexes in Table