Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_form_listsemail_form_lists
An index has been added on listid (Query took 0.0616 sec)
SQL-query: 
ALTER TABLE `email_form_lists` ADD INDEX ( `listid` )
 [Edit] [Create PHP Code]


InnoDB free: 780288 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
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
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 409,600 Bytes
Total 425,984 Bytes
 
Row Statistic: 
Statements Value
Format fixed
Collation utf8_general_ci
Creation Apr 24, 2018 at 06:47 PM

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