Spread Kindness

Create Table SQL

        CREATE TABLE tblComplimentIdeas (
            pmkComplimentIdeasId INT NOT NULL
            AUTO_INCREMENT PRIMARY KEY,
            fldPersonality VARCHAR(12),
            fldAppearance VARCHAR(6),
            fldLifestyle VARCHAR(15)
        )
        

Insert Data

        INSERT INTO tblComplimentIdeas (fldPersonality, fldAppearance, fldLifestyle) VALUES
        ("Kindness", "Outfit", "Doing great"),
        ("Intelligence", "Hair", "Work ethic"),
        ("Funny", "Smile", "Time management")
        

Select Data

        SELECT fldPersonality, fldAppearance, fldLifestyle FROM tblComplimentIdeas
        

Create table for form

        CREATE TABLE tblKindnessForm (
            pmkKindnessFormId INT AUTO_INCREMENT PRIMARY KEY,
            fldFirstName varchar(30),
            fldAge varchar(3),
            fldEmail varchar(50),
            fldBeenBullied varchar(3),
            fldBullied varchar(15),
            fldFavoriteKindness varchar(20),
            fldEmpathetic TINYINT(1),
            fldCaring TINYINT(1),
            fldOpenMinded TINYINT(1),
            fldApproachable TINYINT(1),
            fldWhyKind text
        )
        

Insert Record

        INSERT INTO tblKindnessForm
            (fldFirstName, fldAge, fldEmail, fldBeenBullied, fldBullied, fldFavoriteKindness, 
            fldEmpathetic, fldCaring, fldOpenMinded, fldApproachable, fldWhyKind)
        VALUES
            ('Dakota', '20', 'dakota.smith@uvm.edu', 'Yes', 'Yes', 'Giving gifts',
            '1', '1', '1', '0', 'Why not')