SQL
Create table
CREATE TABLE tblMaintenanceRecords(
pmkMaintenanceRecordsID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
fldMileage VARCHAR(10),
fldDate VARCHAR(10),
fldMaintenancePerformed VARCHAR(150)
)
Insert Data
INSERT INTO tblMaintenanceRecords
(fldMileage, fldDate, fldMaintenancePerformed)
VALUES
('~214,250', '4/25/22', 'Replaced wheels and tires (15 x 7 Sparco FF1's, 195/50R-15 Yokohama Advan Fleva V701 SL)'),
('~214,250', '4/25/22', 'Replaced windshield wipers'),
('~214,250', '4/26/22', 'PA state safety and emissions inspection (passed)'),
('~214,250', '4/26/22', 'Replaced soft top (Robbins soft top, glass rear window)'),
('~214,300', '4/27/22', 'Full interior detail'),
('~214,300', '4/27/22', 'Oil change'),
('~214,300', '4/27/22', 'Replaced alternator belt'),
('~214,300', '4/27/22', 'Replaced accessory belt (PS/AC)'),
('~214,300', '4/27/22', 'Replaced PCV hoses')
Select Records
SELECT fldMileage, fldDate, fldMaintenancePerformed FROM tblMaintenanceRecords
Create table for form
CREATE TABLE tblMiataSuggestionsForm(
pmkMiataSuggestionsFormID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
fldFirstName VARCHAR(25),
fldAge VARCHAR(3),
fldEmail VARCHAR(30),
fldCarEnthusiast VARCHAR(15),
fldMiataSuggestions TEXT
)
Insert Data
?, ?)
INSERT INTO tblMiataSuggestionsForm
(fldFirstName, fldAge, fldEmail, fldCarEnthusiast, fldMiataSuggestions)
VALUES (?, ?, ?,