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 : UPDATE

2018-03-03

IMPORTANT If you forget where clause, every record in the table gets updated.

UPDATE z_robsTestTable
SET name='Purple Dino', password='***', address1='33 Fun Street'
WHERE primaryID=5