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'