On Thursday 08 July 2004 09:19, Louie Miranda might have typed:
>
> As you can see, it updates the whole "random" field on the table. What
> i would like to do is, update each and everyone of it. using a random
> program, which i have. Its on my first email.
>
> > ###
> > #!/bin/sh -x
> > for ran
Btw, here are the sample database i have.
mysql> select * from dump;
+-+--+--+
| countid | random | name |
+-+--+--+
| 1 | theeyahs | randpass |
| 2 | ciuwaise | randpass |
| 3 | ciuwaise | randpass |
| 4 | ciuwaise | ra
Im trying to work on a program that can update each field and insert a
random value on it. But when i run this program it only updates the
whole random field.
Can anyone help me? Im pretty clueless how to work this right. :/
###
#!/bin/sh -x
for random in `pwgen --no-capitalize -N1`
do
sleep 0
do