Re: deleting a data of fields on a table
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]
RE: deleting a data of fields on a table
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]
Re: deleting a data of fields on a table
Also i can use this: update users set password = ''; =) -- 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]
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]