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]