I have a number of 'fields' within the Categories table that I would like to empty. I tried playing around with mySQLMan but couldn't see a way of doing it.

Is there a simple way with mySQL Monitor to empty a particular field?

Thanks in advance,


Regards,


Clint.
--------------------------
http://AffiliatesDirectory.com
The Affiliate Programs Directory

http://www.mysql.com/doc/D/E/DELETE.html

The URL Paul provided is for deleting records/rows from your table.

What you will need to do is use the UPDATE function to "empty" fields/columns (not complete records/rows) via your SQL Monitor.

You can use the example UPDATE function:



If you want the column to be completely NULL, then you can update the SET attribute value to NULL rather than using DefaultValue....
========================================
Buh Bye!

Cheers,
Me