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

   Field  Type Collation Attributes Null Default Extra Action
   smallint(3)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(35) 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(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 Edit Drop id
id_2 UNIQUE Edit Drop id
name_2 UNIQUE Edit Drop name
pic_2 UNIQUE Edit Drop pic
id_4 UNIQUE Edit Drop id
name_6 UNIQUE Edit Drop name
pic_6 UNIQUE Edit Drop pic
id_6 UNIQUE Edit Drop id
name_8 UNIQUE Edit Drop name
pic_8 UNIQUE Edit Drop pic
name_10 UNIQUE Edit Drop name
id_8 UNIQUE Edit Drop id
name_13 UNIQUE Edit Drop name
pic_12 UNIQUE Edit Drop pic
pic_13 UNIQUE Edit Drop pic
id INDEX None  Edit Drop id
name INDEX None  Edit Drop name
phone INDEX None  Edit Drop phone
website INDEX None  Edit Drop website
location INDEX None  Edit Drop location
pic INDEX None  Edit Drop pic
phone_3 INDEX None  Edit Drop phone
name_5 INDEX None  Edit Drop name
pic_5 INDEX None  Edit Drop pic
id_3 INDEX None  Edit Drop id
website_4 INDEX None  Edit Drop website
location_4 INDEX None  Edit Drop location
id_5 INDEX None  Edit Drop id
name_7 INDEX None  Edit Drop name
phone_5 INDEX None  Edit Drop phone
website_5 INDEX None  Edit Drop website
location_5 INDEX None  Edit Drop location
pic_7 INDEX None  Edit Drop pic
location_8 INDEX None  Edit Drop location
website_7 INDEX None  Edit Drop website
name_11 INDEX None  Edit Drop name
phone_7 INDEX None  Edit Drop phone
pic_10 INDEX None  Edit Drop pic
id_7 INDEX None  Edit Drop id
location_9 INDEX None  Edit Drop location
website_9 INDEX None  Edit Drop website
name_14 INDEX None  Edit Drop name
name_3 FULLTEXT None  Edit Drop name
phone_2 FULLTEXT None  Edit Drop phone
website_2 FULLTEXT None  Edit Drop website
location_2 FULLTEXT None  Edit Drop location
pic_3 FULLTEXT None  Edit Drop pic
website_3 FULLTEXT None  Edit Drop website
name_4 FULLTEXT None  Edit Drop name
pic_4 FULLTEXT None  Edit Drop pic
location_3 FULLTEXT None  Edit Drop location
phone_4 FULLTEXT None  Edit Drop phone
name_9 FULLTEXT None  Edit Drop name
phone_6 FULLTEXT None  Edit Drop phone
website_6 FULLTEXT None  Edit Drop website
location_6 FULLTEXT None  Edit Drop location
pic_9 FULLTEXT None  Edit Drop pic
location_7 FULLTEXT None  Edit Drop location
website_8 FULLTEXT None  Edit Drop website
name_12 FULLTEXT None  Edit Drop name
pic_11 FULLTEXT None  Edit Drop pic
phone_8 FULLTEXT None  Edit Drop phone
location_10 FULLTEXT None  Edit Drop location
website_10 FULLTEXT None  Edit Drop website
Create an index on  columns  
 
Space usage: 
Type Usage
Data 636 Bytes
Index 3,072 Bytes
Total 3,708 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 8
Row length ø 79
Row size  ø 464 Bytes
Next Autoindex 10
Creation Feb 25, 2018 at 06:36 AM
Last update Mar 04, 2018 at 11:21 AM
Last check Apr 07, 2018 at 09:11 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: