You don't need to check if a name is in a table to remove the name from the table. A DELETE query looks a lot like a SELECT query, and you would specify which rows to delete just like you can specify which rows to select.
Oct-07-2022, 01:33 PM (This post was last modified: Oct-07-2022, 01:33 PM by pajd.)
(Oct-07-2022, 02:14 AM)deanhystad Wrote: You don't need to check if a name is in a table to remove the name from the table. A DELETE query looks a lot like a SELECT query, and you would specify which rows to delete just like you can specify which rows to select.
Its a user account that I would want to delete from the list of user accounts that are on the MySQL server.
I have now set my code up to use a SQL command to remove the user and I've tested and it works as expected