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


   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(25) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(250) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(3)     No    Change Drop Primary Index Unique Fulltext
   int(3)     No    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

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

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 175  Edit Drop id
id_2 UNIQUE 175  Edit Drop id
title_2 UNIQUE 175  Edit Drop title
varname_2 UNIQUE 175  Edit Drop varname
title_4 UNIQUE 175  Edit Drop title
varname_5 UNIQUE 175  Edit Drop varname
id_4 UNIQUE 175  Edit Drop id
id_5 UNIQUE 175  Edit Drop id
title_7 UNIQUE 175  Edit Drop title
varname_10 UNIQUE 175  Edit Drop varname
id_7 UNIQUE 175  Edit Drop id
title_10 UNIQUE 175  Edit Drop title
varname_13 UNIQUE 175  Edit Drop varname
id INDEX 175  Edit Drop id
title INDEX 175  Edit Drop title
varname INDEX 175  Edit Drop varname
description INDEX 87  Edit Drop description
setting INDEX 58  Edit Drop setting
optionorder INDEX 35  Edit Drop optionorder
section INDEX 13  Edit Drop section
varname_4 INDEX 175  Edit Drop varname
id_3 INDEX 175  Edit Drop id
setting_3 INDEX 58  Edit Drop setting
optionorder_2 INDEX 35  Edit Drop optionorder
section_2 INDEX 13  Edit Drop section
title_6 INDEX 175  Edit Drop title
description_4 INDEX 87  Edit Drop description
varname_9 INDEX 175  Edit Drop varname
optionorder_3 INDEX 35  Edit Drop optionorder
setting_6 INDEX 58  Edit Drop setting
id_6 INDEX 175  Edit Drop id
section_3 INDEX 13  Edit Drop section
description_6 INDEX 87  Edit Drop description
title_9 INDEX 175  Edit Drop title
varname_12 INDEX 175  Edit Drop varname
optionorder_4 INDEX 35  Edit Drop optionorder
id_8 INDEX 175  Edit Drop id
setting_8 INDEX 58  Edit Drop setting
section_4 INDEX 13  Edit Drop section
description_8 INDEX 87  Edit Drop description
title_12 INDEX 175  Edit Drop title
title_3 FULLTEXT 175  Edit Drop title
varname_3 FULLTEXT 175  Edit Drop varname
description_2 FULLTEXT 175  Edit Drop description
setting_2 FULLTEXT 43  Edit Drop setting
title_5 FULLTEXT 175  Edit Drop title
setting_4 FULLTEXT 43  Edit Drop setting
description_3 FULLTEXT 175  Edit Drop description
varname_6 FULLTEXT 175  Edit Drop varname
varname_7 FULLTEXT 175  Edit Drop varname
description_5 FULLTEXT 175  Edit Drop description
setting_5 FULLTEXT 43  Edit Drop setting
varname_8 FULLTEXT 175  Edit Drop varname
title_8 FULLTEXT 175  Edit Drop title
setting_7 FULLTEXT 43  Edit Drop setting
description_7 FULLTEXT 175  Edit Drop description
varname_11 FULLTEXT 175  Edit Drop varname
title_11 FULLTEXT 175  Edit Drop title
Create an index on  columns  
 
Space usage: 
Type Usage
Data 17,260 Bytes
Index 296,960 Bytes
Total 314,220 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 175
Row length ø 98
Row size  ø 1,796 Bytes
Next Autoindex 221
Creation Apr 19, 2018 at 01:36 PM
Last update Apr 19, 2018 at 01:36 PM
Last check Apr 19, 2018 at 01:36 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: