SQL-Browser

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

   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 `INNODB_TRX`
Table properties of `INNODB_TRX` (22 Fields)Name
Engine
Row Format
Charset
Collation
Comment
 

 

Fields of table `INNODB_TRX`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.trx_idvarchar18noutf8_general_ci
edit field  delete field  2.trx_statevarchar13noutf8_general_ci
edit field  delete field  3.trx_starteddatetimeno0000-00-00 00:00:00
edit field  delete field  4.trx_requested_lock_idvarchar81yesutf8_general_ci
edit field  delete field  5.trx_wait_starteddatetimeyes
edit field  delete field  6.trx_weightbigint21nounsigned0
edit field  delete field  7.trx_mysql_thread_idbigint21nounsigned0
edit field  delete field  8.trx_queryvarchar1024yesutf8_general_ci
edit field  delete field  9.trx_operation_statevarchar64yesutf8_general_ci
edit field  delete field  10.trx_tables_in_usebigint21nounsigned0
edit field  delete field  11.trx_tables_lockedbigint21nounsigned0
edit field  delete field  12.trx_lock_structsbigint21nounsigned0
edit field  delete field  13.trx_lock_memory_bytesbigint21nounsigned0
edit field  delete field  14.trx_rows_lockedbigint21nounsigned0
edit field  delete field  15.trx_rows_modifiedbigint21nounsigned0
edit field  delete field  16.trx_concurrency_ticketsbigint21nounsigned0
edit field  delete field  17.trx_isolation_levelvarchar16noutf8_general_ci
edit field  delete field  18.trx_unique_checksint1no0
edit field  delete field  19.trx_foreign_key_checksint1no0
edit field  delete field  20.trx_last_foreign_key_errorvarchar256yesutf8_general_ci
edit field  delete field  21.trx_adaptive_hash_latchedint1no0
edit field  delete field  22.trx_adaptive_hash_timeoutbigint21nounsigned0

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