Creat Table SQL

    CREATE TABLE tblChessOpenings(
        pmkChessOpeningsID INT AUTO_INCREMENT PRIMARY KEY,
        fldRank INT,
        fldOpening VARCHAR(200),
        fldMoves VARCHAR(200)
    )

INSERT INTO tblChessOpenings
(fldRank, fldOpening, fldMoves)
VALUES:
(1, 'French Defense', '1. e4 e6'),
(2, 'Sicilian Defense', '1. e4 c5'),
(3, 'Queen's Gambit Declined', '1. d4 d5 2. c4 c6'),
(4, 'Slav Defense', '1. d4 d5 2. c4 c6'),
(5, 'Italian Game', '1. e4 e5 2. Nf3 Nc6 3. Bc4'),
(6, 'Caro-Kann Defense', '1. e4 c6 2. d4 d5'),
(7, 'London System', '1. d4 d5 2. bf4 Nf6 3. Nf3')
    
SELECT fldRank, fldOpening, fldMoves FROM 'tblChessOpenings'

CREATE TABLE tblFormData (
pmkSubmissionID int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldLastName varchar(30) DEFAULT NULL,
    fldEmail varchar(50) DEFAULT NULL, 
    fldGender varchar(7) DEFAULT NULL, 
    fldTheory tinyint(1) DEFAULT 0, 
    fldPractice tinyint(1) DEFAULT 0, 
    fldTournament tinyint(1) DEFAULT 0,
    fldOther varchar(100) DEFAULT NULL
)

INSERT INTO tblFormData (
    fldLastName, fldEmail, fldGender, fldTheory, fldPractice, fldTournament, fldOther
)
VALUES
1, 'DBsideTest', 'aschaef1@uvm.edu', 'Male', 0, 1, 1, 'tarea test.'