Working with MySQL Data

Flashcards covering insert, update, and delete statements in MySQL.

Insert Statements

Adds data to tables line by line.

Values

Keyword used in SQL to add values to specified columns in a table.

Update Statement

Used to change the values in any row or in many rows at once.

WHERE Clause

A clause used with UPDATE statements to filter the rows you want to change.

Delete Statements

Removes rows from a MySQL table. Used carefully, they can actually remove all data from a table.

Truncate Statement

Removes all data from a table. It is faster than using a delete statement with no where clause. It resets the auto increment counter.