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
done

echo $random

for update in $random
do
echo "update dump set random= '$random' limit 1"|mysql -uroot insert
done

## end of script ###

-- 
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]

Reply via email to