Fiddle Music

Recommendations and Facts

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