Sreedhar.a wrote:
Hi Dennis,
I have created 2 tables for PlayList as u suggested as Follows.
"CREATE TABLE MUSIC (MusicId INTEGER PRIMARY KEY NOT NULL,Album_Id
INTEGER,Artist_Id INTEGER,Bgm_Id INTEGER, Track Text);"
MusicId Album_Id Artist_Id Bgm_Id Track
11
Hi Dennis,
I have created 2 tables for PlayList as u suggested as Follows.
"CREATE TABLE MUSIC (MusicId INTEGER PRIMARY KEY NOT NULL,Album_Id
INTEGER,Artist_Id INTEGER,Bgm_Id INTEGER, Track Text);"
MusicId Album_Id Artist_Id Bgm_Id Track
11
Sreedhar.a wrote:
Thanks a lot for ur help.
You are welcome.
Right now I am trying to INSERT and UPDATE by means of triggers.
My doubt is:
"CREATE TABLE ALBUM (AlbumId INTEGER PRIMARY KEY NOT NULL, Album
Text,unique(Album));"
"CREATE TABLE ARTIST (ArtistId INTEGER PRIMARY KEY NOT NULL
ement looks like [For both
insert and update].
Even if update any records in one table It has to be changed in all the
others Please help to solve this.
Thanks & Regards,
Sreedhar.A
-----Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 04, 2007 9:56
Sreedhar.a wrote:
CREATE TABLE ALBUM (AlbumId INTEGER NOT NULL PRIMARY KEY,Album Text); CREATE
TABLE ARTIST (ArtistId INTEGER NOT NULL PRIMARY KEY,Artist Text); CREATE
TABLE BGM (BgmId INTEGER NOT NULL PRIMARY KEY,Bgm Text);
CREATE TABLE MUSIC (Id INTEGER NOT NULL PRIMARY KEY,Album_Id INTEGER
CO
st_Id)
IS NOT NULL THEN 'DELETE FROM ARTIST WHERE ArtistId=OLD.Artist_Id'
END;
END;"
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 11:53 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite:Deletion in Joins meth
Sreedhar.a wrote:
I have only one ALBUM named 'Confession' with id 1 and
only one ARTIST named 'Madonna' with id 2 and
one BGM named 'rock' with id 5.
MUSIC table will have all these details.
Now If I delete the Album 'Confession' From table ALBUM.
Then it is deleting that record wi
Hi,
Thanks for your suggestion Dennis.
Now I normalized the database as follows:
* CREATE TABLE ALBUM (AlbumId INTEGER NOT NULL PRIMARY KEY,Album
Text);"
* CREATE TABLE ARTIST (ArtistId INTEGER NOT NULL PRIMARY KEY,Artist
Text);"
* CREATE TABLE BGM (BgmId IN
in Joins method
Sreedhar.a wrote:
> Hi,
>
> I have created database using the joins method.
>
> My database caontains 4 tables with the Artist(1),Album(2),Genre(or)
> BGM(3),Combination of all these and Track names in one table.
>
> I am ha
Sreedhar.a wrote:
Hi,
I have created database using the joins method.
My database caontains 4 tables with the Artist(1),Album(2),Genre(or)
BGM(3),Combination of all these and Track names in one table.
I am having 4 tables as follows.
*
"create table ALBUM(AlbumId integer
Hi,
I have created database using the joins method.
My database caontains 4 tables with the Artist(1),Album(2),Genre(or)
BGM(3),Combination of all these and Track names in one table.
I am having 4 tables as follows.
*
"create table ALBUM(AlbumId integer primary key,Album text
11 matches
Mail list logo