mysql question (easy Q for most...)

HI everyone!

Easy question. How do i delete one specific row in a table?

For example: Lets say i have a db that has 100 items in it. How can i delet item 67 and only 67? I keep trying and keep deleting my entire table, lol

 

Does your table have an "id" column or something similar (something that uniquely identifes each row).

If it does, you can just do something like this "DELETE FROM tablename WHERE id = 67".

 

Yup, that's what i woudl need to go by (the id column). That line is what i needed, thank you!!

 

did that work? I would have done

DELETE * FROM tablename WHERE id=67

 

That should have worked, I think. I am presuming that you are a bit of a beginner with SQL. This should help you get started:
http://www.krasline.ru/Library/postgress/manual/sql-commands.htm

 

Two things:

1. You provided a link to PostgreSQL syntax, which is not always correct in MySQL
2. Aforementioned link is broken

Therefore, I present you with http://dev.mysql.com/doc/refman/5.0/en/tutorial.html