413,964 yabancı şarkı sozu mysql db

db yapısı:
CREATE TABLE lyrics (
id int(7) NOT lisanssız auto_increment,
artist varchar(250) NOT lisanssız default '',
title varchar(250) NOT lisanssız default '',
album varchar(250) NOT lisanssız default '',
letter char(2) NOT lisanssız default '',
lyrics text NOT lisanssız,
PRIMARY KEY (id),
FULLTEXT KEY artist (artist),
FULLTEXT KEY title (title),
FULLTEXT KEY album (album)
) TYPE=MyISAM;


ornek veriler :

INSERT INTO lyrics VALUES (268749,'Natalie Cole','Sophisticated Lady','Natalie','N','Written by Chuck Jackson, Marvin Yancy and Natalie Cole
rn
rnSophisticated lady, sophisticated lady
rn
rnShe's a different lady with a different style
rn
rnShe stands tall and steady like the Eiffel Tower
rn
rnShe is hip to politics but loves her jazz
rn
rnShe's got lots of rhythm she's got lots of class
rn
rnEverybody knows how she got her name, yeah
rn
rnOh, ha, she wears knee length dresses with her high heel steppers
rn
rnShe's not no back stabber but she's sure a pleaser
rn
rnShe talks quiet and gentle, she acts very cool
rn
rnShe sticks close to her lover, she obey God's rules, woh
rn
rn(Sophisticated lady) Sophisticated lady, yeah
rn
rn(Sophisticated lady) Oh
rn
rn(Sophisticated lady) That's her name, that's her name
rn
rn(Sophisticated lady) Woh, woh
rn
rnEverybody knows how she got her name
rn
rnYeah, yeah, yeah, yeah----
rn
rnWoh--, oh, oh, oh, oh
rn
rnShe's the kind of person that you'd like to meet
rn
rn'Cause she's always smiling and she's always neat
rn
rnShe can start a fire in the coldest man
rn
rnShe's a hip slick sister known throughout the land, oh
rn
rn(Sophisticated lady) That's her name
rn
rnSophisticated lady (sophisticated lady) yeah
rn
rnOh, well, woo, woo, woo, woo, woo, woo, hoo, that's her name
rn
rnSophisticated lady (sophisticated lady) lady, lady
rn
rnSophisticated lady (sophisticated lady) oh
rn
rnSophisticated lady, (sophisticated lady) ah
rn
rnSophisticated lady (sophisticated lady)
rn
rnOoh, ooh (sophisticated lady)
rn
rnRepeat (Sophisticated lady');


INSERT INTO lyrics VALUES (275584,'Nirvana','Marigold','Heart- Shaped Box B Side','N','He's there in case I wandered off
rnHe's scared because I want
rnHe's there in case I want it all
rnHe's scared because I want
rn
rnAll in all the clock is slow
rnSix colour pictures all in a row of a marigold');


INSERT INTO lyrics VALUES (282838,'Orchestral Manoeuvres In The Dark','Secret','Crush','O','I've got a secret I can't explain
rnAnd all the time I've waited for this day
rnAll along I was never in doubt
rnI always knew it would never get out
rnThere are things that I cannot tell
rnAnd there are things that you know damn well
rnThis is getting very hard for me
rnI guess you'd better just wait and see
rn
rnThis is all, this is all
rn
rnYou heard a message and the message was clear
rnAnd all the time you wipe away that tear
rnAll I want is to hold your hand
rnTo see the sun and walk the sand
rnYou make me sad and you make me glad
rnAnd now you see all my secret is this love
rnIs love, is love
rnAll my secret is this love
rn
rnEveryday you're always there
rnYou comfort me and make me feel it's worth my while
rnAnd then I look around and you're not there
rnAnd everyday you say you care and I'll beware
rn
rnThis is all, this is all
rn
rnI've got a secret and I can't explain
rnAll I want is to hold your hand
rnAll along I was never in doubt
rnTo see the sun and to walk the sand');

sıkıştırılmış hali ~125 mb
acılmış mysql txt hali ~500mb

fiyati : 100 YTL