SQL

Create table 4:06

            CREATE TABLE tblZappaMusicList (
                pmkZappaMusicListId INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
                fldYear varchar(6),
                fldAlbum varchar(15),
                fldSongname varchar(26)
            )
            

Insert Data

                INSERT INTO tblZappaMusicList (fldYear, fldAlbum, 
                fldSongname) VALUES
                
                ('1969', 'Hot Rats', 'Son of Mr. Green Genes'),  
                ('1969', 'Hot Rats', 'The Gumbo Variations'), 
                ('1969', 'Hot Rats', 'Peaches en Regalia'),
                ('1974', 'Apostrophe (\')', 'Cosmik Debris'),
                ('1974', 'Apostrophe (\')', 'Don\'t eat the Yellow Snow') 
            

Select records

            SELECT fldYear, fldAlbum, fldSongname FROM tblZappaMusicList