Shulou(Shulou.com)05/31 Report--

MySQL how to batch update and delete data shell script, in view of this problem, this article introduces the corresponding analysis and solutions in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

#! / bin/bash

. ~ / .bash_profile

Log=/tmp/update_log_1_$ (date +% F) .log

Vstart=1

Step=100

Vstop=$ ((${vstart} + ${step}))

Max=50000

USER='yoon'

PWDroomyoon123, please.

HOST=127.0.0.1

DB=yoon

PORT=3306

TB=employees_ptarc

Echo "stop value is $vstop"

While [${vstart}-lt $((${max} + 1))]

Do

Echo "`date +% Fmuri% T`; / usr/local/mysql/bin/mysql-h$ {HOST}-u$ {USER}-p$ {PWD}-P$ {PORT} ${DB}-e\" UPDATE ${TB} set v_int=9 where id between ${vstart} and ${vstop}\ "> > ${log}

/ usr/local/mysql/bin/mysql-h$ {HOST}-u$ {USER}-p$ {PWD}-P$ {PORT} ${DB}-e "UPDATE ${TB} set v_int=9 where id between ${vstart} and ${vstop}"

Vstart=$ ((${vstop} + 1))

Vstop=$ ((${vstop} + ${step}))

If [${vstop}-gt ${max}]; then

Vstop=$ {max}

Fi

Sleep 1

# echo "start at ${vstart}, stop at ${vstop}"

Done

This is the answer to the question about how MySQL updates and deletes data in batch shell scripts. I hope the above content can be of some help to you. If you still have a lot of doubts to solve, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.