- 博客(2)
- 收藏
- 关注
原创 load csv file from s3 to db
LOAD DATAFROMS3 ‘s3://xxxx/load/vop_cnv_mst.csv’INTO TABLE INSVJSK_CMN.VOP_CNV_MST FIELDS TERMINATED BY‘,’ ENCLOSED BY‘"’ LINES TERMINATED BY‘\r\n’mysql -h xxxx.cluster-crfum7txw65z.ap-northeas...
2019-03-15 09:54:16 258
原创 shell备考
#!/bin/bashDB-csv出力schema=insvjsk_cmncred="-h xxxx.cluster-crfum7txw65z.ap-northeast-1.rds.amazonaws.com ${schema} -u -p"mapfile result < <(mysql ${cred} -se “SHOW TABLES FROM insvjsk_cmn;...
2019-03-15 09:48:10 151
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人