Server: mysql.puroparty.com

Database: puroparty

Table: cooking

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	id	smallint(3)			No		auto_increment
	name	varchar(35)	latin1_swedish_ci		No
	phone	varchar(15)	latin1_swedish_ci		No
	website	varchar(50)	latin1_swedish_ci		No
	location	varchar(35)	latin1_swedish_ci		No
	pic	varchar(35)	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 id name phone website location pic

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 8  id id_2 UNIQUE 8  id name_2 UNIQUE 8  name pic_2 UNIQUE 8  pic id_4 UNIQUE 8  id name_6 UNIQUE 8  name pic_6 UNIQUE 8  pic id_6 UNIQUE 8  id name_8 UNIQUE 8  name pic_8 UNIQUE 8  pic name_10 UNIQUE 8  name id_8 UNIQUE 8  id name_13 UNIQUE 8  name pic_12 UNIQUE 8  pic pic_13 UNIQUE 8  pic id INDEX None  id name INDEX None  name phone INDEX None  phone website INDEX None  website location INDEX None  location pic INDEX None  pic phone_3 INDEX None  phone name_5 INDEX None  name pic_5 INDEX None  pic id_3 INDEX None  id website_4 INDEX None  website location_4 INDEX None  location id_5 INDEX None  id name_7 INDEX None  name phone_5 INDEX None  phone website_5 INDEX None  website location_5 INDEX None  location pic_7 INDEX None  pic location_8 INDEX None  location website_7 INDEX None  website name_11 INDEX None  name phone_7 INDEX None  phone pic_10 INDEX None  pic id_7 INDEX None  id location_9 INDEX None  location website_9 INDEX None  website name_14 INDEX None  name name_3 FULLTEXT None  name phone_2 FULLTEXT None  phone website_2 FULLTEXT None  website location_2 FULLTEXT None  location pic_3 FULLTEXT None  pic website_3 FULLTEXT None  website name_4 FULLTEXT None  name pic_4 FULLTEXT None  pic location_3 FULLTEXT None  location phone_4 FULLTEXT None  phone name_9 FULLTEXT None  name phone_6 FULLTEXT None  phone website_6 FULLTEXT None  website location_6 FULLTEXT None  location pic_9 FULLTEXT None  pic location_7 FULLTEXT None  location website_8 FULLTEXT None  website name_12 FULLTEXT None  name pic_11 FULLTEXT None  pic phone_8 FULLTEXT None  phone location_10 FULLTEXT None  location website_10 FULLTEXT None  website Create an index on  columns

Space usage:  Type Usage Data 636 Bytes Index 3,072 Bytes Total 3,708 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 8 Row length ø 79 Row size  ø 464 Bytes Next Autoindex 10 Creation Feb 25, 2018 at 06:36 AM Last update Mar 04, 2018 at 11:21 AM Last check Apr 17, 2024 at 10:52 PM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `cooking` WHERE 1		id name phone website location pic
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