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

   Field  Type Collation Attributes Null Default Extra Action
   int(2)     No    Change Drop Primary Index Unique Fulltext
   varchar(75) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   char(3) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   char(3) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(200) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   longtext latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(200) 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
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 10  Edit Drop rank
rank_2 UNIQUE 10  Edit Drop rank
song_2 UNIQUE 10  Edit Drop song
song_5 UNIQUE 10  Edit Drop song
rank_4 UNIQUE 10  Edit Drop rank
rank_6 UNIQUE 10  Edit Drop rank
song_9 UNIQUE 10  Edit Drop song
song_10 UNIQUE 10  Edit Drop song
rank_9 UNIQUE 10  Edit Drop rank
pic_9 UNIQUE 10  Edit Drop pic
rank INDEX None  Edit Drop rank
song INDEX None  Edit Drop song
playstw INDEX None  Edit Drop playstw
playslw INDEX None  Edit Drop playslw
video INDEX None  Edit Drop video
lyrics INDEX None  Edit Drop lyrics
label INDEX None  Edit Drop label
pic INDEX None  Edit Drop pic
lyrics_3 INDEX None  Edit Drop lyrics
label_3 INDEX None  Edit Drop label
rank_3 INDEX None  Edit Drop rank
pic_3 INDEX None  Edit Drop pic
song_4 INDEX None  Edit Drop song
playslw_2 INDEX None  Edit Drop playslw
video_4 INDEX None  Edit Drop video
playstw_2 INDEX None  Edit Drop playstw
label_5 INDEX None  Edit Drop label
rank_5 INDEX None  Edit Drop rank
song_7 INDEX None  Edit Drop song
playslw_3 INDEX None  Edit Drop playslw
video_5 INDEX None  Edit Drop video
lyrics_5 INDEX None  Edit Drop lyrics
pic_6 INDEX None  Edit Drop pic
playstw_3 INDEX None  Edit Drop playstw
rank_7 INDEX None  Edit Drop rank
label_7 INDEX None  Edit Drop label
playstw_4 INDEX None  Edit Drop playstw
rank_8 INDEX None  Edit Drop rank
lyrics_8 INDEX None  Edit Drop lyrics
song_11 INDEX None  Edit Drop song
playslw_4 INDEX None  Edit Drop playslw
pic_7 INDEX None  Edit Drop pic
pic_8 INDEX None  Edit Drop pic
lyrics_9 INDEX None  Edit Drop lyrics
song_3 FULLTEXT None  Edit Drop song
video_2 FULLTEXT None  Edit Drop video
audio FULLTEXT None  Edit Drop audio
lyrics_2 FULLTEXT None  Edit Drop lyrics
label_2 FULLTEXT None  Edit Drop label
pic_2 FULLTEXT None  Edit Drop pic
video_3 FULLTEXT None  Edit Drop video
lyrics_4 FULLTEXT None  Edit Drop lyrics
pic_4 FULLTEXT None  Edit Drop pic
song_6 FULLTEXT None  Edit Drop song
audio_2 FULLTEXT None  Edit Drop audio
label_4 FULLTEXT None  Edit Drop label
pic_5 FULLTEXT None  Edit Drop pic
lyrics_6 FULLTEXT None  Edit Drop lyrics
video_6 FULLTEXT None  Edit Drop video
song_8 FULLTEXT None  Edit Drop song
audio_3 FULLTEXT None  Edit Drop audio
label_6 FULLTEXT None  Edit Drop label
label_8 FULLTEXT None  Edit Drop label
lyrics_7 FULLTEXT None  Edit Drop lyrics
Create an index on  columns  
 
Space usage: 
Type Usage
Data 1,024 Bytes
Index 3,072 Bytes
Total 4,096 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 10
Row length ø 102
Row size  ø 410 Bytes
Creation Mar 19, 2018 at 11:11 PM
Last update Mar 20, 2018 at 04:09 PM
Last check Mar 26, 2018 at 09:18 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: