Mysql LOAD DATA demo

最新推荐文章于 2021-05-09 20:38:26 发布

mylomen

最新推荐文章于 2021-05-09 20:38:26 发布

阅读量288

点赞数

分类专栏： sql 文章标签： mysql

本文链接：https://blog.csdn.net/fangfengzhen115/article/details/77482931

版权

sql 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

基本语法：
load data  [low_priority] [local] infile 'file_name txt' [replace | ignore]
into table tbl_name
[fields
[terminated by't']
[OPTIONALLY] enclosed by '']
[escaped by'\' ]]
[lines terminated by'n']
[ignore number lines]
[(col_name,   )]
local da

function loadData()
{
    taPath=$1;
        LOAD DATA LOCAL INFILE "$dataPath"  REPLACE INTO TABLE ad_data fields terminated by ',' (time,app_id,pkg_name,country,placement,ad_req_num,ad_req_filled_num,imp_num,click_num,revenue);
}