mysql数据库存歌,在MySQL数据库中存储歌词

I wanted to know what is the best way of storing music "Lyrics" in a mysql database. and what are the setting used for that. Also, i would like the table to store the break lines.

I was thinking about using "|" to indicate a new line and using php to replace string.

I have no idea where to start, or what to use for the parameters (varchar, int (i know it's not going to be int), etc.)

Currently, I have my tracks table laid out like this

table tracks

----

id (int, 10, primary key)

albumid (foreign key to albums table)

name (varchar, 50)

override_artist (overrides album artist if not null)

playtime (int, 5)

lyric (??????)

Any ideas would be awesome.

解决方案

Your lyric column should be the TEXT type, and you should probably store it in a separate MyISAM table keyed to t