Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: top40vidstop40vids
An index has been added on title (Query took 0.0094 sec)
SQL-query: 
ALTER TABLE `top40vids` ADD FULLTEXT (
`title`
)
 [Edit] [Create PHP Code]


   Field  Type Collation Attributes Null Default Extra Action
   int(10)     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
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 id
id_2 UNIQUE 10  Edit Drop id
title_2 UNIQUE 10  Edit Drop title
url_2 UNIQUE 10  Edit Drop url
id_4 UNIQUE 10  Edit Drop id
title_5 UNIQUE 10  Edit Drop title
url_4 UNIQUE 10  Edit Drop url
url_7 UNIQUE 10  Edit Drop url
title_7 UNIQUE 10  Edit Drop title
id_5 UNIQUE 10  Edit Drop id
title_10 UNIQUE 10  Edit Drop title
id_8 UNIQUE 10  Edit Drop id
url_12 UNIQUE 10  Edit Drop url
title_14 UNIQUE 10  Edit Drop title
id_9 UNIQUE 10  Edit Drop id
url_15 UNIQUE 10  Edit Drop url
id_12 UNIQUE 10  Edit Drop id
title_16 UNIQUE 10  Edit Drop title
url_17 UNIQUE 10  Edit Drop url
id INDEX None  Edit Drop id
artist INDEX None  Edit Drop artist
title INDEX None  Edit Drop title
url INDEX None  Edit Drop url
id_3 INDEX None  Edit Drop id
title_4 INDEX None  Edit Drop title
artist_4 INDEX None  Edit Drop artist
url_6 INDEX None  Edit Drop url
url_8 INDEX None  Edit Drop url
artist_6 INDEX None  Edit Drop artist
title_9 INDEX None  Edit Drop title
id_6 INDEX None  Edit Drop id
title_11 INDEX None  Edit Drop title
id_7 INDEX None  Edit Drop id
url_10 INDEX None  Edit Drop url
artist_8 INDEX None  Edit Drop artist
title_13 INDEX None  Edit Drop title
id_10 INDEX None  Edit Drop id
url_13 INDEX None  Edit Drop url
id_11 INDEX None  Edit Drop id
artist_10 INDEX None  Edit Drop artist
title_15 INDEX None  Edit Drop title
url_16 INDEX None  Edit Drop url
artist_12 INDEX None  Edit Drop artist
artist_2 FULLTEXT None  Edit Drop artist
title_3 FULLTEXT None  Edit Drop title
url_3 FULLTEXT None  Edit Drop url
artist_3 FULLTEXT None  Edit Drop artist
title_6 FULLTEXT None  Edit Drop title
url_5 FULLTEXT None  Edit Drop url
url_9 FULLTEXT None  Edit Drop url
artist_5 FULLTEXT None  Edit Drop artist
title_8 FULLTEXT None  Edit Drop title
artist_7 FULLTEXT None  Edit Drop artist
url_11 FULLTEXT None  Edit Drop url
title_12 FULLTEXT None  Edit Drop title
artist_9 FULLTEXT None  Edit Drop artist
url_14 FULLTEXT None  Edit Drop url
artist_11 FULLTEXT None  Edit Drop artist
title_17 FULLTEXT None  Edit Drop title
url_18 FULLTEXT None  Edit Drop url
title_18 FULLTEXT None  Edit Drop title
Create an index on  columns  
 
Space usage: 
Type Usage
Data 724 Bytes
Index 65,536 Bytes
Total 66,260 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 10
Row length ø 72
Row size  ø 6,626 Bytes
Next Autoindex 11
Creation Apr 23, 2018 at 09:12 PM
Last update Apr 23, 2018 at 09:12 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: