On Tue, 4 Jun 2019 11:26:12 -0700
"Doug" <[email protected]> wrote:
> select songfile_id,dancename,dancegroupname from songfiletable where
> dancename like "Waltz";
What Shawn Wagner's answer shows you is that
'Waltz'
is a string and
"Waltz"
is a column name, because in SQL double-quotes denote identifiers.
They don't denote strings, unlike as in, say, C.
The double-quote escape syntax let's you have odd columns names with
spaces and such:
create table "The Blue Danube" (
"Waltzing Matilda" text not NULL primary key
);
If there's no column name "Waltz" in songfiletable, that's a bug IMO.
As a matter of style, what is songfiletable? A set of songs, or a
file, or a table? Why not just "songs"?
create table songs {
id integer not null primary key, -- probably not needed
dance ... ,
dance_group ... , -- or just "group", but see next
);
If songs have names and dances, and dances have groups, then
dancegroupname belongs in another table, "dances".
HTH.
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
