PDA

View Full Version : [MYSQL] How can I delete a line ?


anou1
18/03/2014, 12:08 PM
Hi,


My title is my question. :)

How could I do to delete a row in a mysql table ?

Thank you.

doreto
18/03/2014, 12:11 PM
This is not SQL forum.

FaZeRs
18/03/2014, 12:17 PM
Go to your phpmyadmin > Select your database > Click Structure on which table you want delete row > And delete row which you want delete

anou1
18/03/2014, 12:19 PM
Not like that I mean with a query.

Cause I'm trying to do a CMD that allow an admin to delete a house that exists in the database.

for example:

/deletehouse ID Will delete the house ID X.

VishvaJeet
18/03/2014, 12:46 PM
DELETE FROM (tablename) WHERE row_name = row_value

anou1
18/03/2014, 03:17 PM
Okay thank you