目前执行后输出的不一样的结果中不知道是来自于哪个表,能否标记出来自哪个表
,而且输出的结果是把不一样的结果那个值的所在行全部输出,能不能只输出具体的那个值呢?shell脚本如下
#!/bin/bash
HOSTNAME="127.0.0.1" #数据库信息
PORT="3306"
USERNAME="root"
PASSWORD="root"
#DBNAME="data"
#数据库名称
TABLENAME="data.group_day"
TABLENAME1="resouorce.group_day1"
select_sql="select b.adgroup_id, b.campaign_id,
a.store_id,
a.campaign_id,
a.campaign_name,
a.adgroup_id,
a.adgroup_name,
a.brand_id,
a.sku_id,
a.effect_days,
a.source,
a.cost,
a.favorite_item_quantity,
a.indirect_order_quantity,
a.indirect_order_value,
a.direct_order_quantity,
a.favorite_shop_quantity,
a.total_cart_quantity,
a.direct_order_value,
a.direct_cart_total,
a.ctr,
a.favtotal,
a.alipay_inshop_num,
a.alipay_inshop_amt,
a.dw_etl_date,
a.dw_batch_id,
a.rowkey,
a.created_time,
a.updated_time,
a.ecpm,
a.data_source,
a.ad_date,
a.indirect_cart_total,
a.search_type,
a.ecpc,
a.roi,
a.impressions,
a.clicks,
a.cvr,
a.category_id,
a.nick
from data.adgroup_day as a,
resouorce.group_day1 as b
where (a.adgroup_id = b.adgroup_id and a.campaign_id = b.campaign_id)
and (a.store_id != b.store_id or a.campaign_name != b.campaign_name or
a.indirect_cart_total != b.indirect_cart_total or a.search_type != b.search_type or a.ecpc != b.ecpc or
a.roi != b.roi or a.impressions != b.impressions or a.clicks != b.clicks or a.cvr != b.cvr or
a.category_id != b.category_id or a.nick != b.nick or a.ecpm != b.ecpm or a.data_source != b.data_source or a.sku_id != b.sku_id or a.adgroup_name != b.adgroup_name or a.brand_id != b.brand_id or
a.effect_days != b.effect_days or a.source != b.source or a.cost != b.cost or a.favorite_item_quantity != b.favorite_item_quantity or
a.indirect_order_quantity != b.indirect_order_quantity or a.indirect_order_value != b.indirect_order_value or a.direct_order_quantity != b.direct_order_quantity or a.direct_cart_total != b.direct_cart_total or a.ctr != b.ctr or
a.favtotal != b.favtotal or a.alipay_inshop_num != b.alipay_inshop_num or a.alipay_inshop_amt != b.alipay_inshop_amt or a.dw_etl_date != b.dw_etl_date or a.rowkey != b.rowkey or a.created_time != b.created_time or a.updated_time != b.updated_time or a.ad_date != b.ad_date ) LIMIT 110000, 1000;"
mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e"${select_sql}" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > apps.csv
echo '程序已执行'
current_time=$(date "+%Y%m%d-%H%M%S")
echo ${current_time}