Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_form_listsemail_form_lists

InnoDB free: 738304 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
formid_14 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
formid_13 INDEX Edit Drop formid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 442,368 Bytes
Total 458,752 Bytes
 
Row Statistic: 
Statements Value
Format fixed
Collation utf8_general_ci
Creation Mar 29, 2024 at 06:57 AM

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: