MQSQL - Lyric Database Problem

[BuLLDoG]

Ok, a while ago I bought a lyric database that contained around 400,000 lyrics and I had it up and running working perfectly. Now I tried setting the database up again and I am having difficulty.

Invalid SQL: SELECT COUNT(*) as songcount FROM songs AS s INNER JOIN artists AS a ON s.primaryartist = a.artistid LEFT JOIN albums AS al ON s.album = al.albumid WHERE a.letter = '09'
mysql error: Table 'bushell_lyrics.artists' doesn't exist

mysql error number: 1146

I have not much of a idea when it comes mysql so if anyone could help me I would really appreciate it.

 

[Peter]

It tells you in the error what the problem is. bushell_lyrics.artists does not exist.

This means that table artists does not exist in the table bushell_lyrics

You cannot get information from a table that does not exist, you need to install the database for the application you are using.

 

[BuLLDoG]

Although I see what you mean. Would it be hard for me to create the table artist or does that mean me entering all the information like each artisit for the song? Sorry about my lack of knowledge of databases.

 

[Wuoshi]

Unless you have a backup of the table with the information that was previously stored in it, you would have to manually add the content.

 

[BuLLDoG]

but when i look at the sql database I can see the artist name ?

 

[Peter]

yes but is it in a table called artists (case and spelling of course important)

 

[Peter]

had a look at the database and the songs table is completely empty. No artists table exists. The artist mentioned is a field in the lyrics table. Therefore the sql does not seem to correspond with the database.