SQL-Browser

[Tools]  Database: `filmtheater`  Table: `ENGINES`

   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.

Data View

new record    Edit table structure

Table `filmtheater`.`ENGINES`
records 1 - 8 from totally 8    <<    <    >    >>

View: compact   The Query contains 6 Columns
 # ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
  edit delete1. 
CSV
YES
Stores tables as CSV files
NO
NO
NO
  edit delete2. 
MRG_MyISAM
YES
Collection of identical MyISAM tables
NO
NO
NO
  edit delete3. 
MEMORY
YES
Hash based, stored in memory, useful for temporary tables
NO
NO
NO
  edit delete4. 
Aria
YES
Crash-safe tables with MyISAM heritage. Used for internal temporary tables and privilege tables
NO
NO
NO
  edit delete5. 
MyISAM
YES
Non-transactional engine with good performance and small data footprint
NO
NO
NO
  edit delete6. 
SEQUENCE
YES
Generated tables filled with sequential values
YES
NO
YES
  edit delete7. 
InnoDB
DEFAULT
Supports transactions, row-level locking, foreign keys and encryption for tables
YES
YES
YES
  edit delete8. 
PERFORMANCE_SCHEMA
YES
Performance Schema
NO
NO
NO

records 1 - 8 from totally 8    <<    <    >    >>