SQL Syntax in MYSQL Please help me the condition in DELETE in MYSQL

[codeispoetry]

@DaveMaxwell

Still doesn’t mean you HAVE to use the unique id from the table to delete it. Deleting by any criteria is one of the strengths of using a database.

Cant we delete through Values?

[codeispoetry]

@benanamen

If you look at the site it is obvious each record has a unique id number.

Although, I didnt consider that the id’s keep incrementing every time sample data is added/deleted

Yes, you got it correctly. Thanks.

[m_hutley]

Why would you be hardcoding sample data into your code, though?

[r937]

@codeispoetry

Cant we delete through Values ?

of course

[codeispoetry]

@r937

of course

How, and when values are more than one. Compact version sir?

[codeispoetry]

@m_hutley

Why would you be hardcoding sample data into your code, though?

This is an app I am building fro sake of learning CRUD so I am trying whatever coming in my mind. I think that is how we learn keep trying everything and playing around? This is not a live Project of any commercial utility.

[m_hutley]

So if you’ve got a standard test set of data you’re loading on a repeatable basis, why not just TRUNCATE the entire table and start from scratch every time you test?

[codeispoetry]

Already such option, but I was willing to do this one also.

[r937]

@codeispoetry

How, and when values are more than one. Compact version sir?

i gave you two ways to do it (with the disclaimer that i wasn’t sure the second way would work in MySQL)

have you still not tried the first way?