Database: puropartypuroparty
Table: email_form_listsemail_form_lists
An index has been added on formid (Query took 0.0547 sec)
ALTER TABLE `email_form_lists` ADD INDEX ( `formid` )
 [Edit] [Create PHP Code]

InnoDB free: 777216 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Relation viewRelation view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop formid
formid_2 UNIQUE Edit Drop formid
formid_4 UNIQUE Edit Drop formid
formid_6 UNIQUE Edit Drop formid
formid_9 UNIQUE Edit Drop formid
formid_10 UNIQUE Edit Drop formid
formid_12 UNIQUE Edit Drop formid
email_form_lists_formid_listid_idx UNIQUE Edit Drop formid
listid_2 UNIQUE Edit Drop listid
listid_3 UNIQUE Edit Drop listid
listid_5 UNIQUE Edit Drop listid
listid_7 UNIQUE Edit Drop listid
listid_9 UNIQUE Edit Drop listid
listid_11 UNIQUE Edit Drop listid
formid INDEX Edit Drop formid
listid INDEX Edit Drop listid
formid_3 INDEX Edit Drop formid
listid_4 INDEX Edit Drop listid
formid_5 INDEX Edit Drop formid
listid_6 INDEX Edit Drop listid
formid_7 INDEX Edit Drop formid
formid_8 INDEX Edit Drop formid
listid_8 INDEX Edit Drop listid
formid_11 INDEX Edit Drop formid
listid_10 INDEX Edit Drop listid
listid_12 INDEX Edit Drop listid
formid_13 INDEX Edit Drop formid
Create an index on  columns  
Space usage: 
Type Usage
Data 16,384 Bytes
Index 425,984 Bytes
Total 442,368 Bytes
Row Statistic: 
Statements Value
Format fixed
Collation utf8_general_ci
Creation Jun 20, 2018 at 05:17 PM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
Character set of the file: