Jump to content

Archived

This topic is now archived and is closed to further replies.

blanktarget

trouble deleting rows

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.