I think it should be pointed out that this will remove that column from the TABLE, not just for a row (which I think the question was hinting at)
MD On Fri, 10 Dec 2004 09:08:03 -0600, Ryan Duckworth <[EMAIL PROTECTED]> wrote: > You can remove a column, not just set it to NULL. > > Use the ALTER TABLE statement. Syntax: > > ALTER TABLE [table] > DROP COLUMN [columnlist] > > INSERT, DELETE, UPDATE are all built to change specific records. ALTER > TABLE changes the structure of your table. > > Good luck. > > Ryan Duckworth > Macromedia ColdFusion Certified Professional > Uhlig Communications > 10983 Granada Lane > Overland Park, KS 66211 > (913) 754-4272 > > > > > -----Original Message----- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 09, 2004 6:30 PM > To: CF-Talk > Subject: Re: Picky delete statement? > > Thats right. if you want to delete the columns of a record you have to > update the record and set the columns to null or to whatever the > default defined by the database > > e.g. > Update mytable > Set col1 = null > , col2 = null > Where id = <insert id> > > Hope that helps > > Regards > Mark Drew > > On Thu, 9 Dec 2004 18:44:53 -0500, Phillip Perry > <[EMAIL PROTECTED]> wrote: > > Hi, > > > > I've read my sql book but I cant find what i'm looking for. According > to the > > book (as far as my understanding is) you cant specify which columns to > > delete, you can only delete the whole record. Is this true? > > > > Phil > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186983 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
