update a field with multiple value

2005-03-18 Thread Eko Budiharto
Hi, I am trying to to update one field with multiple value. I tried with regulare update command syntax does not work. How to update a field with multiple value. regular update syntax is this, UPDATE variableInfo SET variable='A' WHERE variable is null; but what I want to do is UPDATE

Re: update a field with multiple value

2005-03-18 Thread Alec . Cawley
Eko Budiharto [EMAIL PROTECTED] wrote on 18/03/2005 16:54:09: Hi, I am trying to to update one field with multiple value. I tried with regulare update command syntax does not work. How to update a field with multiple value. regular update syntax is this, UPDATE variableInfo SET

Re: update a field with multiple value

2005-03-18 Thread SGreen
Eko Budiharto [EMAIL PROTECTED] wrote on 03/18/2005 11:54:09 AM: Hi, I am trying to to update one field with multiple value. I tried with regulare update command syntax does not work. How to update a field with multiple value. regular update syntax is this, UPDATE variableInfo SET

Re: update a field with multiple value

2005-03-18 Thread Gleb Paharenko
Hello. but what I want to do is UPDATE variableInfo SET variable='A, B' WHERE variable is null; when I use that command, mysql does not understand the syntax. How to update a field with multiple value or with an array? Multiple values could hold the SET columns, But I think