In MySQL, you can delete data just as easily as you can query it or update it.
SQL DELETE
Statement
Use the SQL
DELETE
statement to delete data from your database. Like the SELECT
and UPDATE
statements, the DELETE
statement accepts a WHERE
clause so that you can specify the exact record/s to delete.Syntax
DELETE
FROM table_name
WHERE column_name = value;
Example
Delete All Records
You can delete all records in a table quite easily. Actually, it's easier to delete all records than to delete one specific record.
As you can imagine, it pays to be very careful when using the
DELETE
statement. This is where Safe Updates mode can help (as we covered when updating our data).
As it turns out, I was only able to run the above statement after disabling Safe Updates mode. So, before I ran that statement, I ran the following command:
SET SQL_SAFE_UPDATES = 0;
So now it's probably a good time for me to enable Safe Updates again — before I do any more damage…
SET SQL_SAFE_UPDATES = 1;
Restore the Data
Now that we've wiped out all records from the Fruit table, let's see if we can restore them to their original value. Fortunately for us, we previously wrote a script to insert data into our tables.
No comments:
Post a Comment
Hey, It's Been Grabbed