Spread Kindness

One Action to Change the World

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