PLEASE Help, Mysql question - GoFuckYourself.com

jeroman · 09-24-2003, 12:02 PM

I need to "empty" a field within a table.
How do I do that ? (truncet)

I can empty the table itself but there's
20 other fields I don't want to "empty"

DrGuile · 09-24-2003, 12:03 PM

probably not the best way... but

update <tablename>
set <fieldname> = ""

if that doesnt work, add

where 1 = 1

Stud Money · 09-24-2003, 12:03 PM

Could ya not drop the field from the table then re-add it?

Babaganoosh · 09-24-2003, 12:05 PM

UPDATE whatever SET field='' WHERE field !='';

09-24-2003, 12:02 PM	#1
jeroman So Fucking Banned Join Date: Oct 2002 Location: Norway or UK or...damn, where am I Posts: 356	PLEASE Help, Mysql question I need to "empty" a field within a table. How do I do that ? (truncet) I can empty the table itself but there's 20 other fields I don't want to "empty"

09-24-2003, 12:03 PM	#2
DrGuile Confirmed User Join Date: Jan 2002 Posts: 2,025	probably not the best way... but update <tablename> set <fieldname> = "" if that doesnt work, add where 1 = 1 __________________ LiveBucks / Privatefeeds - Giving you money since 1999 Up to 50% Commission! 25% Webmaster Referal Powered by Gamma

09-24-2003, 12:03 PM	#3
Stud Money So Fucking Banned Join Date: Sep 2003 Location: Somewhere between my monitor and my chair Posts: 3,214	Could ya not drop the field from the table then re-add it?

09-24-2003, 12:05 PM	#4
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	UPDATE whatever SET field='' WHERE field !='';