Green Mountain Cycles

Create Table SQL

    CREATE TABLE tblContactInfo(
    pmkContactID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldFirstName varchar(50) DEFAULT NULL,
    fldLastName varchar(50) DEFAULT NULL,
    fldEmail varchar(50) DEFAULT NULL,
    fldReason varchar(20) DEFAULT NULL,
    fldDescription varchar(400) DEFAULT NULL
    )
    

    CREATE TABLE tblProducts (
    pmkProductID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldImageName varchar(50) DEFAULT NULL,
    fldProductName varchar(100) DEFAULT NULL,
    fldPrice varchar(20) DEFAULT NULL
    )
    

Insert records into the table

    INSERT INTO tblContactInfo
    (pmkContactID, fldFirstName, fldLastName, fldEmail, fldReason, fldDescription)
    VALUES
    (1, 'Aaron', 'Perkel', 'aperkel@uvm.edu', 'Other', 'Test');
    

    INSERT INTO tblProducts
    (pmkProductID, fldImageName, fldProductName, fldPrice)
    VALUES
    (1, 'test.jpg', 'test', '$0.00');
    

Select all from table

    SELECT * FROM `tblContactInfo`
    

    SELECT * FROM tblProducts