Re: Picky delete statement?
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 = > > 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
RE: Picky delete statement?
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 = 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 Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186981 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
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 = 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 - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186929 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
