On Thu, 2002-12-05 at 14:42, Beauford.2003 wrote:
> Adolfo,
>
> Thanks for the info, but can you elaborate on it, 'cause basically I am just
> not getting the concept. No way no how can I get these joins to work.
>
> mysql> describe songs; (this contains an ID field and the title of the song
> a
: "Adolfo Bello" <[EMAIL PROTECTED]>
To: "'Beauford.2003'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 04, 2002 4:28 PM
Subject: RE: Table setup question
> Let's assume you want the entire albums list which the song
>
uld show the all the albums a particular song were on.
> (from the example above what would I need to do to show the
> album name and song title for song ID # 1 above).
>
> Sorry if this is long, I just wanted to make sure there is
> enough info.
>
> TIA
>
> Beauford
>
> --
MAIL PROTECTED]>
Sent: Monday, December 02, 2002 7:33 AM
Subject: RE: Table setup question
> Try something like
> CREATE TABLE album( ida int primary key , title varchar(n) not null ) ;
> CREATE TABLE songs( ids intprimary key, song varchar(m) not null ) ;
> CREATE TABLE albumsongs
t;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 03, 2002 7:56 AM
Subject: Re: Table setup question
> Beauford,
>
> > OK, I get it now. I thought there would need to be duplication in the
> > AlbumSonglist DB.
>
> =indeed, the process of 'normal
ks again, Beauford
=hope it helps you along your way to MySQL expertise,
=dn
> - Original Message -
> From: "DL Neil" <[EMAIL PROTECTED]>
> To: "Beauford.2003" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, December 02, 2002 10:41 AM
The other difference is that it works (BTW, a huge benefit)
Adolfo
> -Original Message-
> From: Beauford.2003 [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 02, 2002 11:24 AM
> To: DL Neil; [EMAIL PROTECTED]
> Subject: Re: Table setup question
>
>
> DL,
-
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, December 02, 2002 10:41 AM
Subject: Re: Table setup question
> Beauford,
> [please reply to the list - there are always others 'lurking&
?
>?
> ?
>
>
>
> - Original Message -
> From: "DL Neil" <[EMAIL PROTECTED]>
> To: "Beauf
ord.2003 [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 01, 2002 9:59 PM
> To: [EMAIL PROTECTED]
> Subject: Table setup question
>
>
> Hi,
>
> I have a database of albums by a group and I want to be able
> to search on this table to find out what songs are duplicate
Hi Beauford,
You are on the right track. Yes you should remove the songs to a separate
table. If you merely duplicate the first example (below) in two tables you
have created a "one-to-many" relationship between the Album table and the
Songs table - one album has many songs on it. Your query code
Hi,
I have a database of albums by a group and I want to be able to search on
this table to find out what songs are duplicated on what albums (there are
36+ albums). The problem is how do I set up the database.
Example:
Album1 has 3 songs. 1.song, 2.song, 3.song, 4.song
Album2 has 4 songs. 4.s
* "al butler" <[EMAIL PROTECTED]>
> I have the MySQL book and I am trying to come to terms on how
> to setup a column that is based on another one.
>
> Let me try and explain.
>
> Each row has a string (unique) and indexed.
> This string is catergorized by anothe column defined as a SET ,
> le
Subject: A table setup question.
From: "al butler" <[EMAIL PROTECTED]>
===
I have the MySQL book and I am trying to come to terms on how
to setup a column that is based on another one.
Let me try and explain.
Each row has a string (unique) and indexed.
This string is
14 matches
Mail list logo
