modify a field in all records of a table
This is a discussion on modify a field in all records of a table within the MySQL Database forums, part of the Database Forums category; I have a field 'time_zone' which is wrong in all records of my table 'mdl_users' and I would like to ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-03-2006
|
|||
|
|||
modify a field in all records of a table
I have a field 'time_zone' which is wrong in all records of my table
'mdl_users' and I would like to set this field to a unique value '1.0' in all records... is ther a way to do it using phpmyadmin ? or should I use an sql command ? TFYH Joss 
|
|
05-04-2006
|
|||
|
|||
|
Re: modify a field in all records of a table
On 2006-05-04 01:12:02 +0200, "Peter H. Coffin" <hellsop@ninehells.com> said:
> On Thu, 4 May 2006 00:01:03 +0200, Josselin wrote: >> I have a field 'time_zone' which is wrong in all records of my table >> 'mdl_users' and I would like to set this field to a unique value '1.0' >> in all records... >> is ther a way to do it using phpmyadmin ? or should I use an sql command ? > > sql command. thanks
|
Linear Mode
