#!/bin/sh
mysql -h10.10.10.10 -uroot -p123456 -e"
#use centain database
use finereport;
# close sage model for update
SET SQL_SAFE_UPDATES = 0;
#for area get
update APP_ALL_PLOT_AREA_FACT
set UpdateTime = '2022-01-01 17:53:34'
where UpdateTime = '2021-12-31 01:00:00' ;
#for left core
update APP_ALL_HZ_GOAL_FACT
set UpdateTime = '2022-01-01 17:53:34'
where UpdateTime = '2021-12-31 18:34:07'
#ps: have a Quotation marks blow
"