SQL

UPDATE
UPDATE table SET column1=value, column2=value2,… WHERE column=value

EX:
UPDATE user SET firstname=’Luke’, lastname=’Skywalker’ WHERE id=1;

INSERT INTO
INSERT INTO tableName (column1,column2,column3,…) VALUES (value1, value2, value3,…)

Leave a Reply