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

   Field  Type Collation Attributes Null Default Extra Action
   char(2) latin1_swedish_ci   No    Change Drop Primary Index Unique Fulltext
   char(2) latin1_swedish_ci   No    Change Drop Primary Index Unique Fulltext
   int(4)     No    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(200) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) 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
   varchar(10) 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 743  Edit Drop venue
month INDEX None  Edit Drop month
day INDEX None  Edit Drop day
year INDEX None  Edit Drop year
entertainer INDEX None  Edit Drop entertainer
eventname INDEX None  Edit Drop eventname
venue INDEX None  Edit Drop venue
city INDEX None  Edit Drop city
weekday INDEX None  Edit Drop weekday
eventname_3 INDEX None  Edit Drop eventname
day_2 INDEX None  Edit Drop day
weekday_4 INDEX None  Edit Drop weekday
venue_4 INDEX None  Edit Drop venue
city_3 INDEX None  Edit Drop city
year_2 INDEX None  Edit Drop year
entertainer_3 INDEX None  Edit Drop entertainer
month_2 INDEX None  Edit Drop month
year_3 INDEX None  Edit Drop year
venue_6 INDEX None  Edit Drop venue
entertainer_5 INDEX None  Edit Drop entertainer
city_5 INDEX None  Edit Drop city
weekday_5 INDEX None  Edit Drop weekday
day_3 INDEX None  Edit Drop day
month_3 INDEX None  Edit Drop month
eventname_6 INDEX None  Edit Drop eventname
year_4 INDEX None  Edit Drop year
venue_7 INDEX None  Edit Drop venue
weekday_7 INDEX None  Edit Drop weekday
day_4 INDEX None  Edit Drop day
city_8 INDEX None  Edit Drop city
entertainer_7 INDEX None  Edit Drop entertainer
eventname_8 INDEX None  Edit Drop eventname
month_4 INDEX None  Edit Drop month
month_5 INDEX None  Edit Drop month
day_5 INDEX None  Edit Drop day
year_5 INDEX None  Edit Drop year
entertainer_8 INDEX None  Edit Drop entertainer
eventname_9 INDEX None  Edit Drop eventname
link1 FULLTEXT None  Edit Drop link1
entertainer_2 FULLTEXT None  Edit Drop entertainer
eventname_2 FULLTEXT None  Edit Drop eventname
venue_2 FULLTEXT None  Edit Drop venue
city_2 FULLTEXT None  Edit Drop city
weekday_2 FULLTEXT None  Edit Drop weekday
weekday_3 FULLTEXT None  Edit Drop weekday
venue_3 FULLTEXT None  Edit Drop venue
eventname_4 FULLTEXT None  Edit Drop eventname
link1_2 FULLTEXT None  Edit Drop link1
city_4 FULLTEXT None  Edit Drop city
entertainer_4 FULLTEXT None  Edit Drop entertainer
link1_3 FULLTEXT None  Edit Drop link1
venue_5 FULLTEXT None  Edit Drop venue
eventname_5 FULLTEXT None  Edit Drop eventname
weekday_6 FULLTEXT None  Edit Drop weekday
city_6 FULLTEXT None  Edit Drop city
entertainer_6 FULLTEXT None  Edit Drop entertainer
link1_4 FULLTEXT None  Edit Drop link1
venue_8 FULLTEXT None  Edit Drop venue
city_7 FULLTEXT None  Edit Drop city
eventname_7 FULLTEXT None  Edit Drop eventname
weekday_8 FULLTEXT None  Edit Drop weekday
link1_5 FULLTEXT None  Edit Drop link1
entertainer_9 FULLTEXT None  Edit Drop entertainer
eventname_10 FULLTEXT None  Edit Drop eventname
Create an index on  columns  
 
Space usage: 
Type Usage
Data 271,532 Bytes
Index 3,072 Bytes
Total 274,604 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 743
Row length ø 365
Row size  ø 370 Bytes
Creation Apr 21, 2018 at 05:24 PM
Last update Apr 21, 2018 at 05:24 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: