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]