trouble deleting rows

[blanktarget]

I\'m using this:

DELETE FROM table WHERE table_id=100;

to delete the row where the id is 100. Only it\'s deleting the whole table.

[shivabharat]

DELETE FROM table WHERE table_id=100; 

 

Cant believe that this deleted the whold table did you have records with only table_id 100??

 

How are you executing this ssatement using PHP or in the mysql prompt?

 

You can give this a try.

 

DELETE FROM table WHERE table_id=\'100\'; 

 

If you still have problme post with your code and sample table data.