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,…)
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,…)