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

   Field  Type Collation Attributes Null Default Extra Action
   smallint(4)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(15) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(15) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(35) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(35) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(35) latin1_swedish_ci   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 13  Edit Drop id
id_2 UNIQUE 13  Edit Drop id
name_2 UNIQUE 13  Edit Drop name
smallpic_2 UNIQUE 13  Edit Drop smallpic
largepic_2 UNIQUE 13  Edit Drop largepic
id_3 UNIQUE 13  Edit Drop id
name_5 UNIQUE 13  Edit Drop name
largepic_6 UNIQUE 13  Edit Drop largepic
smallpic_6 UNIQUE 13  Edit Drop smallpic
name_7 UNIQUE 13  Edit Drop name
id_6 UNIQUE 13  Edit Drop id
smallpic_7 UNIQUE 13  Edit Drop smallpic
largepic_8 UNIQUE 13  Edit Drop largepic
id INDEX None  Edit Drop id
name INDEX None  Edit Drop name
phone1 INDEX None  Edit Drop phone1
phone2 INDEX None  Edit Drop phone2
type INDEX None  Edit Drop type
website INDEX None  Edit Drop website
location INDEX None  Edit Drop location
smallpic INDEX None  Edit Drop smallpic
largepic INDEX None  Edit Drop largepic
location_3 INDEX None  Edit Drop location
type_3 INDEX None  Edit Drop type
website_3 INDEX None  Edit Drop website
name_6 INDEX None  Edit Drop name
largepic_4 INDEX None  Edit Drop largepic
smallpic_5 INDEX None  Edit Drop smallpic
phone2_4 INDEX None  Edit Drop phone2
id_4 INDEX None  Edit Drop id
phone1_3 INDEX None  Edit Drop phone1
phone1_5 INDEX None  Edit Drop phone1
phone2_5 INDEX None  Edit Drop phone2
id_5 INDEX None  Edit Drop id
name_8 INDEX None  Edit Drop name
website_6 INDEX None  Edit Drop website
location_6 INDEX None  Edit Drop location
type_5 INDEX None  Edit Drop type
smallpic_9 INDEX None  Edit Drop smallpic
largepic_9 INDEX None  Edit Drop largepic
name_3 FULLTEXT None  Edit Drop name
phone1_2 FULLTEXT None  Edit Drop phone1
phone2_2 FULLTEXT None  Edit Drop phone2
type_2 FULLTEXT None  Edit Drop type
website_2 FULLTEXT None  Edit Drop website
location_2 FULLTEXT None  Edit Drop location
smallpic_3 FULLTEXT None  Edit Drop smallpic
largepic_3 FULLTEXT None  Edit Drop largepic
smallpic_4 FULLTEXT None  Edit Drop smallpic
location_4 FULLTEXT None  Edit Drop location
name_4 FULLTEXT None  Edit Drop name
phone2_3 FULLTEXT None  Edit Drop phone2
largepic_5 FULLTEXT None  Edit Drop largepic
website_4 FULLTEXT None  Edit Drop website
type_4 FULLTEXT None  Edit Drop type
phone1_4 FULLTEXT None  Edit Drop phone1
location_5 FULLTEXT None  Edit Drop location
largepic_7 FULLTEXT None  Edit Drop largepic
phone2_6 FULLTEXT None  Edit Drop phone2
phone1_6 FULLTEXT None  Edit Drop phone1
smallpic_8 FULLTEXT None  Edit Drop smallpic
website_5 FULLTEXT None  Edit Drop website
name_9 FULLTEXT None  Edit Drop name
type_6 FULLTEXT None  Edit Drop type
Create an index on  columns  
 
Space usage: 
Type Usage
Data 1,516 Bytes
Index 3,072 Bytes
Total 4,588 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 13
Row length ø 116
Row size  ø 353 Bytes
Next Autoindex 14
Creation Oct 30, 2017 at 04:24 PM
Last update Jun 09, 2018 at 12:20 PM
Last check Jun 22, 2018 at 05:14 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: