SQL-Browser

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

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

 

Fields of table `PARTITIONS`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.TABLE_CATALOGvarchar512noutf8_general_ci
edit field  delete field  2.TABLE_SCHEMAvarchar64noutf8_general_ci
edit field  delete field  3.TABLE_NAMEvarchar64noutf8_general_ci
edit field  delete field  4.PARTITION_NAMEvarchar64yesutf8_general_ci
edit field  delete field  5.SUBPARTITION_NAMEvarchar64yesutf8_general_ci
edit field  delete field  6.PARTITION_ORDINAL_POSITIONbigint21yesunsigned
edit field  delete field  7.SUBPARTITION_ORDINAL_POSITIONbigint21yesunsigned
edit field  delete field  8.PARTITION_METHODvarchar18yesutf8_general_ci
edit field  delete field  9.SUBPARTITION_METHODvarchar12yesutf8_general_ci
edit field  delete field  10.PARTITION_EXPRESSIONlongtextyesutf8_general_ci
edit field  delete field  11.SUBPARTITION_EXPRESSIONlongtextyesutf8_general_ci
edit field  delete field  12.PARTITION_DESCRIPTIONlongtextyesutf8_general_ci
edit field  delete field  13.TABLE_ROWSbigint21nounsigned0
edit field  delete field  14.AVG_ROW_LENGTHbigint21nounsigned0
edit field  delete field  15.DATA_LENGTHbigint21nounsigned0
edit field  delete field  16.MAX_DATA_LENGTHbigint21yesunsigned
edit field  delete field  17.INDEX_LENGTHbigint21nounsigned0
edit field  delete field  18.DATA_FREEbigint21nounsigned0
edit field  delete field  19.CREATE_TIMEdatetimeyes
edit field  delete field  20.UPDATE_TIMEdatetimeyes
edit field  delete field  21.CHECK_TIMEdatetimeyes
edit field  delete field  22.CHECKSUMbigint21yesunsigned
edit field  delete field  23.PARTITION_COMMENTvarchar80noutf8_general_ci
edit field  delete field  24.NODEGROUPvarchar12noutf8_general_ci
edit field  delete field  25.TABLESPACE_NAMEvarchar64yesutf8_general_ci

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