Create Table SQL
CREATE TABLE tblSongs( pmkSongID INT AUTO_INCREMENT PRIMARY KEY, fldMood VARCHAR(20), fldFeel VARCHAR(40), fldSnap VARCHAR(40) ) INSERT INTO tblSongs (fldMood, fldFeel, fldSnap) VALUES('happy', 'Water Me by Lizzo', 'Void by Lil Nas X'), ('angry', ' Picture to Burn by Taylor Swift', ' Innocent by Taylor Swift'), ('anxious', 'Payday by Doja Cat', 'Golden G String by Miley Cyrus'), ('productive', 'The Man by Taylor Swift', 'Start All Over by Miley Cyrus'), ('in love', 'Hey Stephen by Taylor Swift', 'Tonight I\'m Getting Over You by Carly Rae Jepsen') SELECT fldMood, fldFeel, fldSnap FROM `tblSongs`
CREATE TABLE tblFORM( pmkSurveyID INT AUTO_INCREMENT PRIMARY KEY, fldFirstName VARCHAR(25), fldLastName VARCHAR(60), fldFavSinger VARCHAR(200), fldHappy tinyint(1), fldSad tinyint(1), fldLove tinyint(1), fldAngry tinyint(1), fldIndependent tinyint(1), fldAmount int(2), fldFormat VARCHAR(7), fldEmail VARCHAR(60) ) INSERT INTO tblFORM (fldFirstName, fldLastName, fldFavSinger, fldHappy, fldSad, fldLove, fldAngry, fldIndependent, fldAmount, fldFormat, fldEmail) VALUES('Anja', 'Samsom', 'Taylor Swift and Lizzo', 1, 0, 0, 0, 1, 8, 'text', 'anjavt14@gmail.com')