I am a newbie. I want to ask a question about how to delete a piece of data in mysql without specifying an id. if I do not specify an id, there are always other conditions. Otherwise, how can I know which one to delete, there are always other identification marks. to delete a piece of data, you must first know which one is used to identify the data, such as ID, NAME, TIME and so on. if you do not specify an ID, you must specify other fields. if you are new to the field, ask a question about how to delete data in php + mysql.
How to delete a piece of data in MYSQL with no id specified
------ Solution --------------------
If you do not specify an id, there are always other conditions. Otherwise, how do you know which one to delete?
------ Solution --------------------
There are other identification marks.
------ Solution --------------------
To delete a piece of data, you first need to know which one is to use the field data of the data to distinguish it, such as ID, NAME, TIME, etc, if no ID is specified, other fields must be specified. if the field data is not unique, the same fields will be deleted.
------ Solution --------------------
When you click "delete", the id is taken over.
------ Solution --------------------
Reference:
Click delete to delete the Database id.
There is always a condition, or how do you know which one you want to delete? this type of deletion generally transfers the unique identifier in the table. This image does not display this unique identifier, but you need to read and hide it as a basis for finding this data, just like your ID card number.
------ Solution --------------------
Reference:
Click delete to delete the Database id.
Quote: reference:
There are other identification marks.
Reference:
If you do not specify an id, there are always other conditions. Otherwise, how do you know which one to delete?
Hello, you deleted this by getting the ID ..
