|
|
Posted by Tim Martin on 12/16/88 11:57
> Ac1d^ wrote:
>> NTG, ...
>>
>> update my_table set field = (field+10);
>>
>> that should do.
>
version2 wrote:
> i am looking at resetting all the values in the column and giving the
> first value 10 htne 2 value 20 and so on
Why don't you start by explaining what problem you're trying to solve
with this? It smells like a nasty hack to me.
Assuming you already have the incremental numbers, you can do
UPDATE my_table
SET field=(field*10)
In addition, this has nothing to do with PHP. In future, you might want
to try comp.databases.mysql (or the appriate group for whatever DB you use)
Tim
Navigation:
[Reply to this message]
|