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

   Field  Type Collation Attributes Null Default Extra Action
   int(10)   UNSIGNED No    auto_increment  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(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   longtext latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(225) 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 54521  Edit Drop id
id_2 UNIQUE 54521  Edit Drop id
id_4 UNIQUE 54521  Edit Drop id
id_5 UNIQUE 54521  Edit Drop id
id_7 UNIQUE 54521  Edit Drop id
id INDEX None  Edit Drop id
title INDEX None  Edit Drop title
artist INDEX None  Edit Drop artist
album INDEX None  Edit Drop album
extras INDEX None  Edit Drop extras
file INDEX None  Edit Drop file
artist_3 INDEX None  Edit Drop artist
id_3 INDEX None  Edit Drop id
file_3 INDEX None  Edit Drop file
extras_3 INDEX None  Edit Drop extras
title_3 INDEX None  Edit Drop title
album_4 INDEX None  Edit Drop album
id_6 INDEX None  Edit Drop id
file_5 INDEX None  Edit Drop file
extras_5 INDEX None  Edit Drop extras
title_5 INDEX None  Edit Drop title
album_5 INDEX None  Edit Drop album
artist_6 INDEX None  Edit Drop artist
file_7 INDEX None  Edit Drop file
artist_7 INDEX None  Edit Drop artist
album_7 INDEX None  Edit Drop album
title_7 INDEX None  Edit Drop title
id_8 INDEX None  Edit Drop id
extras_8 INDEX None  Edit Drop extras
id_9 INDEX None  Edit Drop id
artist_9 INDEX None  Edit Drop artist
album_9 INDEX None  Edit Drop album
id_10 INDEX None  Edit Drop id
id_11 INDEX None  Edit Drop id
id_12 INDEX None  Edit Drop id
id_13 INDEX None  Edit Drop id
words FULLTEXT None  Edit Drop words
title_2 FULLTEXT None  Edit Drop title
artist_2 FULLTEXT None  Edit Drop artist
album_2 FULLTEXT None  Edit Drop album
words_2 FULLTEXT None  Edit Drop words
extras_2 FULLTEXT None  Edit Drop extras
file_2 FULLTEXT None  Edit Drop file
album_3 FULLTEXT None  Edit Drop album
artist_4 FULLTEXT None  Edit Drop artist
extras_4 FULLTEXT None  Edit Drop extras
file_4 FULLTEXT None  Edit Drop file
words_3 FULLTEXT None  Edit Drop words
title_4 FULLTEXT None  Edit Drop title
artist_5 FULLTEXT None  Edit Drop artist
extras_6 FULLTEXT None  Edit Drop extras
words_4 FULLTEXT None  Edit Drop words
file_6 FULLTEXT None  Edit Drop file
title_6 FULLTEXT None  Edit Drop title
album_6 FULLTEXT None  Edit Drop album
words_5 FULLTEXT None  Edit Drop words
extras_7 FULLTEXT None  Edit Drop extras
artist_8 FULLTEXT None  Edit Drop artist
file_8 FULLTEXT None  Edit Drop file
album_8 FULLTEXT None  Edit Drop album
title_8 FULLTEXT None  Edit Drop title
file_9 FULLTEXT None  Edit Drop file
title_9 FULLTEXT None  Edit Drop title
album_10 FULLTEXT None  Edit Drop album
Create an index on  columns  
 
Space usage: 
Type Usage
Data 41,026 KB
Index 3,072 Bytes
Total 41,029 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 54,521
Row length ø 770
Row size  ø 771 Bytes
Next Autoindex 1,511,792,429
Creation Mar 04, 2018 at 04:06 PM
Last update Apr 25, 2018 at 09:14 AM
Last check Mar 26, 2018 at 12:16 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: