Jump to content

Deleting an entire entry of data?


Freedom-n-Democrazy

Recommended Posts

I have this table:

+------+---------------+------------+

| id | primarycolour | pricerange |

+------+---------------+------------+

| 1 | black | 1 |

| NULL | brown | 2 |

+------+---------------+------------+

 

I want to delete the entire entry for NULL. I tried this, but it didn't work:

delete from testdb.products where id='NULL';

 

How can it be done?

 

Also, I don't think saying "deleting an entire entry of data" is correct. Is what I am asking to do is to delete a primary key?

Link to comment
https://forums.phpfreaks.com/topic/246950-deleting-an-entire-entry-of-data/
Share on other sites

Archived

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

×
×
  • Create New...

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.