SELECT DATA FROM TABLE : SELECT employeeid, firstname, lastname, title, email FROM employees WHERE employeeid = 3; Update DATA in TABLE : UPDATE table SET column_1 = new_value_1, column_2 = new_value_2 WHERE search_condition ORDER column_or_expression LIMIT row_count OFFSET offset; Update one column example : UPDATE employees SET lastname = 'Smith' WHERE employeeid = 3;