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
    )
    

Insert records into the table

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

Select all from table

    SELECT * FROM `tblContactInfo`