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


InnoDB free: 780288 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     No    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 id
id_2 UNIQUE Edit Drop id
id_3 UNIQUE Edit Drop id
id_6 UNIQUE Edit Drop id
id_7 UNIQUE Edit Drop id
id_10 UNIQUE Edit Drop id
id_12 UNIQUE Edit Drop id
id_14 UNIQUE Edit Drop id
email_user_access_userid_idx INDEX Edit Drop userid
userid INDEX Edit Drop userid
area INDEX Edit Drop area
id INDEX Edit Drop id
id_4 INDEX Edit Drop id
userid_2 INDEX Edit Drop userid
area_2 INDEX Edit Drop area
area_3 INDEX Edit Drop area
id_5 INDEX Edit Drop id
userid_3 INDEX Edit Drop userid
id_8 INDEX Edit Drop id
userid_4 INDEX Edit Drop userid
area_4 INDEX Edit Drop area
id_9 INDEX Edit Drop id
area_5 INDEX Edit Drop area
userid_5 INDEX Edit Drop userid
userid_6 INDEX Edit Drop userid
id_11 INDEX Edit Drop id
userid_7 INDEX Edit Drop userid
area_6 INDEX Edit Drop area
id_13 INDEX Edit Drop id
area_7 INDEX Edit Drop area
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 475,136 Bytes
Total 491,520 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Creation Apr 23, 2018 at 09:08 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: