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

   Field  Type Collation Attributes Null Default Extra Action
   smallint(10)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(4) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(8) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(8) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(75) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(30) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(20) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(20) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(20) 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 63  Edit Drop id
id_2 UNIQUE 63  Edit Drop id
frequency_2 UNIQUE 63  Edit Drop frequency
id_3 UNIQUE 63  Edit Drop id
frequency_5 UNIQUE 63  Edit Drop frequency
id_5 UNIQUE 63  Edit Drop id
frequency_9 UNIQUE 63  Edit Drop frequency
id_7 UNIQUE 63  Edit Drop id
id INDEX None  Edit Drop id
amfm INDEX None  Edit Drop amfm
letters INDEX None  Edit Drop letters
frequency INDEX None  Edit Drop frequency
format INDEX None  Edit Drop format
website INDEX None  Edit Drop website
owner INDEX None  Edit Drop owner
city INDEX None  Edit Drop city
state INDEX None  Edit Drop state
amfm_3 INDEX None  Edit Drop amfm
format_3 INDEX None  Edit Drop format
frequency_4 INDEX None  Edit Drop frequency
city_4 INDEX None  Edit Drop city
id_4 INDEX None  Edit Drop id
owner_4 INDEX None  Edit Drop owner
website_4 INDEX None  Edit Drop website
state_4 INDEX None  Edit Drop state
letters_4 INDEX None  Edit Drop letters
format_5 INDEX None  Edit Drop format
city_5 INDEX None  Edit Drop city
website_5 INDEX None  Edit Drop website
frequency_8 INDEX None  Edit Drop frequency
id_6 INDEX None  Edit Drop id
amfm_6 INDEX None  Edit Drop amfm
owner_6 INDEX None  Edit Drop owner
state_6 INDEX None  Edit Drop state
letters_6 INDEX None  Edit Drop letters
city_7 INDEX None  Edit Drop city
format_7 INDEX None  Edit Drop format
amfm_2 FULLTEXT None  Edit Drop amfm
letters_2 FULLTEXT None  Edit Drop letters
frequency_3 FULLTEXT None  Edit Drop frequency
format_2 FULLTEXT None  Edit Drop format
website_2 FULLTEXT None  Edit Drop website
owner_2 FULLTEXT None  Edit Drop owner
city_2 FULLTEXT None  Edit Drop city
state_2 FULLTEXT None  Edit Drop state
letters_3 FULLTEXT None  Edit Drop letters
state_3 FULLTEXT None  Edit Drop state
city_3 FULLTEXT None  Edit Drop city
owner_3 FULLTEXT None  Edit Drop owner
amfm_4 FULLTEXT None  Edit Drop amfm
website_3 FULLTEXT None  Edit Drop website
frequency_6 FULLTEXT None  Edit Drop frequency
format_4 FULLTEXT None  Edit Drop format
letters_5 FULLTEXT None  Edit Drop letters
frequency_7 FULLTEXT None  Edit Drop frequency
city_6 FULLTEXT None  Edit Drop city
amfm_5 FULLTEXT None  Edit Drop amfm
website_6 FULLTEXT None  Edit Drop website
owner_5 FULLTEXT None  Edit Drop owner
state_5 FULLTEXT None  Edit Drop state
format_6 FULLTEXT None  Edit Drop format
city_8 FULLTEXT None  Edit Drop city
frequency_10 FULLTEXT None  Edit Drop frequency
amfm_7 FULLTEXT None  Edit Drop amfm
Create an index on  columns  
 
Space usage: 
Type Usage
Data 4,780 Bytes
Index 3,072 Bytes
Total 7,852 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 63
Row length ø 75
Row size  ø 125 Bytes
Next Autoindex 64
Creation Feb 21, 2018 at 10:09 PM
Last update Feb 21, 2018 at 10:09 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: