 Hey everybody, this is Brian. Welcome to the 53rd LAMP tutorial. Today we're going to be discussing how to delete records out of your database. Now if you've been following along, you know we have this beautiful little database here. And let's just execute this select statement. So let's just say we want to get rid of this guy because it's a duplicate. Actually, you know what? Let's be creative. Let's get rid of this first one here. So what we need is a delete statement. So we can right click this and go to delete. You see how it says delete from database dot table where and we have the where condition. Once again, I should caution you that if you are not using the MySQL workbench or if you have disabled the safeties, if you do that, you admit the where statement, it's going to delete the entire table. It will truncate it and there's a truncate command also where you can truncate the entire database. So we are going to just delete from table where have our where statement id tbl products equal one and then just the number of our primary key which is one. So we're saying delete from the table where and then our condition. And we're going to put this select statement underneath here. And once again, order by wouldn't make much sense in deleting because you're just deleting them. So let's execute. Voila! Notice how the first record or the one that matched that is now gone. And we can actually do that with the second one if we felt like it. Now, I should caution you. Once you delete a record, there is no way of recovering. It is just gone. Permanently, indefinitely gone. So there's your words of wisdom and caution, I should say. Hope you found this educational entertaining and thank you for watching.