SQL-Browser

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

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

 

Fields of table `FILES`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.FILE_IDbigint4no0
edit field  delete field  2.FILE_NAMEvarchar64yesutf8_general_ci
edit field  delete field  3.FILE_TYPEvarchar20noutf8_general_ci
edit field  delete field  4.TABLESPACE_NAMEvarchar64yesutf8_general_ci
edit field  delete field  5.TABLE_CATALOGvarchar64noutf8_general_ci
edit field  delete field  6.TABLE_SCHEMAvarchar64yesutf8_general_ci
edit field  delete field  7.TABLE_NAMEvarchar64yesutf8_general_ci
edit field  delete field  8.LOGFILE_GROUP_NAMEvarchar64yesutf8_general_ci
edit field  delete field  9.LOGFILE_GROUP_NUMBERbigint4yes
edit field  delete field  10.ENGINEvarchar64noutf8_general_ci
edit field  delete field  11.FULLTEXT_KEYSvarchar64yesutf8_general_ci
edit field  delete field  12.DELETED_ROWSbigint4yes
edit field  delete field  13.UPDATE_COUNTbigint4yes
edit field  delete field  14.FREE_EXTENTSbigint4yes
edit field  delete field  15.TOTAL_EXTENTSbigint4yes
edit field  delete field  16.EXTENT_SIZEbigint4no0
edit field  delete field  17.INITIAL_SIZEbigint21yesunsigned
edit field  delete field  18.MAXIMUM_SIZEbigint21yesunsigned
edit field  delete field  19.AUTOEXTEND_SIZEbigint21yesunsigned
edit field  delete field  20.CREATION_TIMEdatetimeyes
edit field  delete field  21.LAST_UPDATE_TIMEdatetimeyes
edit field  delete field  22.LAST_ACCESS_TIMEdatetimeyes
edit field  delete field  23.RECOVER_TIMEbigint4yes
edit field  delete field  24.TRANSACTION_COUNTERbigint4yes
edit field  delete field  25.VERSIONbigint21yesunsigned
edit field  delete field  26.ROW_FORMATvarchar10yesutf8_general_ci
edit field  delete field  27.TABLE_ROWSbigint21yesunsigned
edit field  delete field  28.AVG_ROW_LENGTHbigint21yesunsigned
edit field  delete field  29.DATA_LENGTHbigint21yesunsigned
edit field  delete field  30.MAX_DATA_LENGTHbigint21yesunsigned
edit field  delete field  31.INDEX_LENGTHbigint21yesunsigned
edit field  delete field  32.DATA_FREEbigint21yesunsigned
edit field  delete field  33.CREATE_TIMEdatetimeyes
edit field  delete field  34.UPDATE_TIMEdatetimeyes
edit field  delete field  35.CHECK_TIMEdatetimeyes
edit field  delete field  36.CHECKSUMbigint21yesunsigned
edit field  delete field  37.STATUSvarchar20noutf8_general_ci
edit field  delete field  38.EXTRAvarchar255yesutf8_general_ci

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