Server: mysql.puroparty.com

Database: puroparty

Table: lyrics

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	id	int(10)		UNSIGNED	No		auto_increment
	title	varchar(50)	latin1_swedish_ci		No
	artist	varchar(50)	latin1_swedish_ci		No
	album	varchar(50)	latin1_swedish_ci		No
	words	longtext	latin1_swedish_ci		No
	extras	varchar(225)	latin1_swedish_ci		No
	file	varchar(100)	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 title artist album words extras file

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 55901  id id_2 UNIQUE 55901  id id_4 UNIQUE 55901  id id_5 UNIQUE 55901  id id_7 UNIQUE 55901  id id INDEX None  id title INDEX None  title artist INDEX None  artist album INDEX None  album extras INDEX None  extras file INDEX None  file artist_3 INDEX None  artist id_3 INDEX None  id file_3 INDEX None  file extras_3 INDEX None  extras title_3 INDEX None  title album_4 INDEX None  album id_6 INDEX None  id file_5 INDEX None  file extras_5 INDEX None  extras title_5 INDEX None  title album_5 INDEX None  album artist_6 INDEX None  artist file_7 INDEX None  file artist_7 INDEX None  artist album_7 INDEX None  album title_7 INDEX None  title id_8 INDEX None  id extras_8 INDEX None  extras id_9 INDEX None  id artist_9 INDEX None  artist album_9 INDEX None  album id_10 INDEX None  id id_11 INDEX None  id id_12 INDEX None  id id_13 INDEX None  id words FULLTEXT None  words title_2 FULLTEXT None  title artist_2 FULLTEXT None  artist album_2 FULLTEXT None  album words_2 FULLTEXT None  words extras_2 FULLTEXT None  extras file_2 FULLTEXT None  file album_3 FULLTEXT None  album artist_4 FULLTEXT None  artist extras_4 FULLTEXT None  extras file_4 FULLTEXT None  file words_3 FULLTEXT None  words title_4 FULLTEXT None  title artist_5 FULLTEXT None  artist extras_6 FULLTEXT None  extras words_4 FULLTEXT None  words file_6 FULLTEXT None  file title_6 FULLTEXT None  title album_6 FULLTEXT None  album words_5 FULLTEXT None  words extras_7 FULLTEXT None  extras artist_8 FULLTEXT None  artist file_8 FULLTEXT None  file album_8 FULLTEXT None  album title_8 FULLTEXT None  title file_9 FULLTEXT None  file title_9 FULLTEXT None  title album_10 FULLTEXT None  album Create an index on  columns

Space usage:  Type Usage Data 41,076 KB Index 3,072 Bytes Total 41,079 KB

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 55,901 Row length ø 752 Row size  ø 752 Bytes Next Autoindex 1,511,793,809 Creation Mar 04, 2018 at 04:06 PM Last update Apr 17, 2024 at 09:24 AM Last check Apr 18, 2024 at 02:51 PM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `lyrics` WHERE 1		id title artist album words extras file
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