Re: deleting a data of fields on a table

2004-07-07 Thread Louie Miranda
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

RE: deleting a data of fields on a table

2004-07-07 Thread Lachlan Mulcahy
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:

Re: deleting a data of fields on a table

2004-07-07 Thread Louie Miranda
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]