Server: mysql.puroparty.com

Database: puroparty

Table: pics

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	month	char(2)	latin1_swedish_ci		No	0
	day	char(2)	latin1_swedish_ci		No	0
	year	int(4)			No	0
	link1	text	latin1_swedish_ci		No
	entertainer	varchar(200)	latin1_swedish_ci		No
	eventname	varchar(100)	latin1_swedish_ci		No
	venue	varchar(50)	latin1_swedish_ci		No
	city	varchar(50)	latin1_swedish_ci		No
	weekday	varchar(10)	latin1_swedish_ci		No
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After month day year link1 entertainer eventname venue city weekday

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 743  venue month INDEX None  month day INDEX None  day year INDEX None  year entertainer INDEX None  entertainer eventname INDEX None  eventname venue INDEX None  venue city INDEX None  city weekday INDEX None  weekday eventname_3 INDEX None  eventname day_2 INDEX None  day weekday_4 INDEX None  weekday venue_4 INDEX None  venue city_3 INDEX None  city year_2 INDEX None  year entertainer_3 INDEX None  entertainer month_2 INDEX None  month year_3 INDEX None  year venue_6 INDEX None  venue entertainer_5 INDEX None  entertainer city_5 INDEX None  city weekday_5 INDEX None  weekday day_3 INDEX None  day month_3 INDEX None  month eventname_6 INDEX None  eventname year_4 INDEX None  year venue_7 INDEX None  venue weekday_7 INDEX None  weekday day_4 INDEX None  day city_8 INDEX None  city entertainer_7 INDEX None  entertainer eventname_8 INDEX None  eventname month_4 INDEX None  month month_5 INDEX None  month day_5 INDEX None  day year_5 INDEX None  year entertainer_8 INDEX None  entertainer eventname_9 INDEX None  eventname link1 FULLTEXT None  link1 entertainer_2 FULLTEXT None  entertainer eventname_2 FULLTEXT None  eventname venue_2 FULLTEXT None  venue city_2 FULLTEXT None  city weekday_2 FULLTEXT None  weekday weekday_3 FULLTEXT None  weekday venue_3 FULLTEXT None  venue eventname_4 FULLTEXT None  eventname link1_2 FULLTEXT None  link1 city_4 FULLTEXT None  city entertainer_4 FULLTEXT None  entertainer link1_3 FULLTEXT None  link1 venue_5 FULLTEXT None  venue eventname_5 FULLTEXT None  eventname weekday_6 FULLTEXT None  weekday city_6 FULLTEXT None  city entertainer_6 FULLTEXT None  entertainer link1_4 FULLTEXT None  link1 venue_8 FULLTEXT None  venue city_7 FULLTEXT None  city eventname_7 FULLTEXT None  eventname weekday_8 FULLTEXT None  weekday link1_5 FULLTEXT None  link1 entertainer_9 FULLTEXT None  entertainer eventname_10 FULLTEXT None  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 Mar 11, 2024 at 02:45 AM Last check Apr 18, 2024 at 08:46 PM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `pics` WHERE 1		month day year link1 entertainer eventname venue city weekday
Show this query here again
Or Location of the textfile:
Location of the textfile:
(Max: 2,048KB)
Compression:      Autodetect   None   "gzipped"   "bzipped"
Character set of the file: armscii8 ascii big5 binary cp1250 cp1251 cp1256 cp1257 cp850 cp852 cp866 cp932 dec8 euckr gb2312 gbk geostd8 greek hebrew hp8 keybcs2 koi8r koi8u latin1 latin2 latin5 latin7 macce macroman sjis swe7 tis620 ucs2 ujis utf8