SQL

Create table

        CREATE TABLE tblSongsForStoke(
            pmkSongsForStokeId INT AUTO_INCREMENT PRIMARY KEY,
            fldSong varchar(14),
            fldDuration varchar(10),
            fldStokeLevels varchar(15)
        ) 
    

Insert Data

    INSERT INTO tblSongsForStoke (fldSong, fldDuration, fldStokeLevels) VALUES
    ('The Chicken Reel', '2:33 mins', 'Mid to Moderate'),
    ('Freefalling', '4:03 mins', 'Quite High'),
    ('Moneymusk', '3:40 mins', 'Off the chart')
    

Select Records

        SELECT fldSong, fldDuration, fldStokeLevels FROM tblSongsForStoke
    

Create Form Table

        CREATE TABLE tblMusicPreferences (
            pmkMusicPreferences int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
            fldBluegrass tinyint(1) DEFAULT 0,
            fldRock tinyint(1) DEFAULT 0,
            fldPop tinyint(1) DEFAULT 0,
            fldRap tinyint(1) DEFAULT 0,
            fldPreference varchar(15) DEFAULT NULL,
            fldFirstName varchar(30) DEFAULT NULL,
            fldLastName	varchar(30) DEFAULT NULL,
            fldEmail varchar(50) DEFAULT NULL
        )
    

Insert Data

        INSERT INTO tblMusicPreferences
        (pmkMusicPreferences, fldBluegrass, fldRock, fldPop, fldRap, fldPreference, fldFirstName, fldLastName, fldEmail)
        VALUES(1, 1, 1, 0, 0, 'Listen', 'Corinna', 'Kelly', 'ilovefiddle@uvm.edu');