sorry for the confusion, but i did found another way. which is the update syntax.
all is working fine now, thanks! On Thu, 8 Jul 2004 16:18:31 +1000, Lachlan Mulcahy <[EMAIL PROTECTED]> wrote: > Louie, > > Can you please clarify if you are wishing to change the structure of the > table so that a particular column no longer exists or if you are just > wanting to "delete" the data in a field (eg. set it to "" or NULL). > > Can you give a more specific example? > > Lachlan > > > -----Original Message----- > From: Louie Miranda [mailto:[EMAIL PROTECTED] > Sent: Thursday, 8 July 2004 3:46 PM > To: [EMAIL PROTECTED] > Subject: deleting a data of fields on a table > > Is it possible to delete only a specific field on a table? > > lets say i have. > > table: dump > field: > - countid > - random > - name > > countid, is an auto increment field > random, is a random words, etc > name, is a field for specifiying where they belong. > > Now, how can i delete a specific data on each field? > > -- > Louie Miranda > http://www.axishift.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Louie Miranda http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]