SQL

Start Here Glossary WHERE INSERT (Create) SELECT (Read) UPDATE DELETE Join Tables Sub Query Limit Records SQL Injection SSMS Meta Data Sum TABLE Apostrophe Date Identity
O O

Weather Controls

Time Of Day
Rain
Wind Speed
Wind Direction
Clouds

SQL : INSERT (Create)

2018-03-03

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() )