Updating Data
11 important questions on Updating Data
What are the 2 syntaxes for a INSERT statement?
INSERT INTO table_name
SET column_name = value [, column_name = value] ... ;
What are the 2 differences between INSERT SET and INSERT VALUES()?
When inserting multiple rows with INSERT VALUES(), does each set need it's own ()?
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What is the benefit of ON DUPLICATE KEY UPDATE above two separate statements?
Does the update of an ON DUPLICATE KEY UPDATE clause count as separate affected row?
What is the benefit of using REPLACE above a separate DELETE and INSERT statement?
Do multiple NULL values count as duplicate key for a REPLACE statement?
What is the syntax of an UPDATE statement?
SET column_name> = value [, column_name = value] ...
WHERE .... ;
Do records that match the WHERE clause of an update statement always count as affected_rows?
What is the syntax of a DELETE statement?
TRUNCATE TABLE table_name;
Does TRUNCATE (TABLE) return a true row count of the deleted set?
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding
![Trustpilot Logo](/images/design_2020/lp/clp-trustpilot-en.png)