Birmingham mumbai

[
 341 
]
Figure 13.3: Listing database rows from a table
To remove an entry, the following command will do what we need:
DELETE FROM Employees WHERE Name = 'Joe Smith'; 
Basically, we're using the 
DELETE FROM
 command, giving the name of the table we 
wish to delete from (
Employees
, in this case), and then using 
WHERE
 to provide some 
search criteria for narrowing down our command.
The 
DROP
 command allows us to delete tables or entire databases, and it should be 
used with care. I don't actually recommend you delete the database we just created, 
since we'll use it for additional examples. But if you really wanted to drop the 
Employees
 table, you could use:
DROP TABLE Employees; 
Or use this to drop the entire database:
DROP DATABASE mysampledb; 
There is, of course, much more to MariaDB and its MySQL syntax than the samples 
I have provided, but this should be enough to get you through the examples in this 
book. As much as I would love to give you a full walkthrough of the MySQL syntax, 
it would easily push this chapter beyond a reasonable number of pages. If you'd 
like to push your skills beyond the samples of this chapter, there are great books 
available that are dedicated to the subject.

---

Managing Databases