See what we can offer to your school
"SimpleStudy just makes sense...”
Get the best plan for your school
14 cards from this deck
Add new records, modify existing ones, remove unwanted data
INSERT, UPDATE, DELETE
Adds brand new rows of data to an existing table
INSERT INTO table (fields) VALUES (values)
Must match up perfectly (first value to first field, etc.)
Modifies existing records without deleting and recreating them
Table to update, SET clause, WHERE clause
Specifies exactly which records should be modified
Changes every single record in the table
Removes unwanted records permanently from database
DELETE FROM table_name WHERE condition
Deletes every single record in the table
DELETE (permanently removes data)
Acts as filter ensuring only specific records are affected
Select your subjects, and get access to A+ resources today.