Hi,
I am having 40000 records in my database.
I am using Joins method.
My Table Looks like:
"CREATE TABLE ARTIST (ArtistId INTEGER PRIMARY KEY NOT NULL,ArtistName TEXT
NOT NULL COLLATE NOCASE ,YomiArtistName TEXT NOT NULL,UNIQUE(ArtistName));"
ArtistId ArtistName YomiArtistName
10 bbb BBB
11 xxx XXX
12 aaa AAA
"CREATE TABLE ALBUM (AlbumId INTEGER PRIMARY KEY NOT NULL,AlbumName TEXT NOT
NULL COLLATE NOCASE ,YomiAlbumName TEXT NOT NULL,UNIQUE(AlbumName));"
AlbumId AlbumName YomiAlbumName
20 zzz ZZZ
21 ccc CCC
22 bbb BBB
"CREATE TABLE MUSIC(Id INTEGER PRIMARY KEY NOT NULL,Track TEXT NOT
NULL,YomiTrack TEXT NOT NULL,URL TEXT NOT NULL,Album_Id INTEGER,Artist_Id
INTEGER,AlbumArtist_Id INTEGER);"
Id Track YomiTrack URL Album_Id Artist_Id
AlbumArtist_Id
1 trak1 TRAK1 c:/trak1 22 10 1
2 song SONG c:/song 21 11 2
3 abc ABC c:/abc 23 12 3
Now I want to Update the AlbumName or ArtistName for all the records in
MUSIC table . How can I do.If I update All the Records to one New AlbumName
Then the rest of the AlbumName should be deleted.
Can I use Update Trigger I tried but not working.
Please help to solve this.
Thanks & Regards,
Mahalakshmi
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
