- 博客(2)
- 收藏
- 关注
原创 load csv file from s3 to db
LOAD DATA FROM S3 ‘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
269
原创 shell备考
#!/bin/bash DB-csv出力 schema=insvjsk_cmn cred="-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
154
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人