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

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(20) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) 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_3 UNIQUE Edit Drop id
name_2 UNIQUE Edit Drop name
photo_2 UNIQUE Edit Drop photo
photo2_2 UNIQUE Edit Drop photo2
photo3_2 UNIQUE Edit Drop photo3
folder_2 UNIQUE Edit Drop folder
thumbnail_2 UNIQUE Edit Drop thumbnail
thumbnail_6 UNIQUE Edit Drop thumbnail
id_5 UNIQUE Edit Drop id
name_5 UNIQUE Edit Drop name
photo_5 UNIQUE Edit Drop photo
photo2_5 UNIQUE Edit Drop photo2
id INDEX None  Edit Drop id
id_2 INDEX None  Edit Drop id
name INDEX None  Edit Drop name
photo INDEX None  Edit Drop photo
photo2 INDEX None  Edit Drop photo2
photo3 INDEX None  Edit Drop photo3
folder INDEX None  Edit Drop folder
cd1pic INDEX None  Edit Drop cd1pic
cd1name INDEX None  Edit Drop cd1name
cd2pic INDEX None  Edit Drop cd2pic
cd2name INDEX None  Edit Drop cd2name
cd3pic INDEX None  Edit Drop cd3pic
cd3name INDEX None  Edit Drop cd3name
cd4pic INDEX None  Edit Drop cd4pic
cd4name INDEX None  Edit Drop cd4name
thumbnail INDEX None  Edit Drop thumbnail
cd3name_3 INDEX None  Edit Drop cd3name
thumbnail_4 INDEX None  Edit Drop thumbnail
cd4pic_3 INDEX None  Edit Drop cd4pic
cd4name_4 INDEX None  Edit Drop cd4name
id_4 INDEX None  Edit Drop id
name_4 INDEX None  Edit Drop name
photo_4 INDEX None  Edit Drop photo
photo2_4 INDEX None  Edit Drop photo2
name_3 FULLTEXT None  Edit Drop name
photo_3 FULLTEXT None  Edit Drop photo
photo2_3 FULLTEXT None  Edit Drop photo2
photo3_3 FULLTEXT None  Edit Drop photo3
bio FULLTEXT None  Edit Drop bio
message FULLTEXT None  Edit Drop message
ad FULLTEXT None  Edit Drop ad
player FULLTEXT None  Edit Drop player
folder_3 FULLTEXT None  Edit Drop folder
cd1pic_2 FULLTEXT None  Edit Drop cd1pic
cd1name_2 FULLTEXT None  Edit Drop cd1name
cd2pic_2 FULLTEXT None  Edit Drop cd2pic
cd2name_2 FULLTEXT None  Edit Drop cd2name
cd3pic_2 FULLTEXT None  Edit Drop cd3pic
cd3name_2 FULLTEXT None  Edit Drop cd3name
cd4pic_2 FULLTEXT None  Edit Drop cd4pic
cd4name_2 FULLTEXT None  Edit Drop cd4name
lyrics FULLTEXT None  Edit Drop lyrics
thumbnail_3 FULLTEXT None  Edit Drop thumbnail
cd3name_4 FULLTEXT None  Edit Drop cd3name
thumbnail_5 FULLTEXT None  Edit Drop thumbnail
cd4pic_4 FULLTEXT None  Edit Drop cd4pic
cd4name_3 FULLTEXT None  Edit Drop cd4name
lyrics_2 FULLTEXT None  Edit Drop lyrics
name_6 FULLTEXT None  Edit Drop name
photo_6 FULLTEXT None  Edit Drop photo
photo2_6 FULLTEXT None  Edit Drop photo2
Create an index on  columns  
 
Space usage: 
Type Usage
Data 31,504 Bytes
Index 4,096 Bytes
Total 35,600 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 6
Row length ø 5,250
Row size  ø 5,933 Bytes
Next Autoindex 7
Creation Nov 12, 2017 at 04:41 AM
Last update Jun 20, 2018 at 07:51 PM
Last check Jun 21, 2018 at 08:42 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: