SQL : INSERT (Create)
Insert
The primary key column gets automatically added.
The existing columns that are not included in the statement are given null value.
Add a Single Record
INSERT INTO z_robsTestTable (name, password, address1) VALUES ('Barney', 'pw1@', '123 Street')
Add Multiple Records
INSERT INTO z_robsTestTable (name, password, address1) VALUES
('Joe', 'FEre34', '123 Street'), ('Sam', 'RREs3#', '6231 San Rafael')
MySQL Current Date "2018-03-03"
INSERT INTO rp_robsTable1 (name, dateModified) VALUES ( '{$name}', CURDATE() )