DataGrip导出sql文件

DataGrip导出sql文件

导入csv： 代码如下:load data infile ‘/test.csv’ into table table_name fields terminated by ‘,’ optionally enclosed by ‘”‘ escaped by ‘”‘ lines terminated by ‘

’ ignore 1 lines;

导csv： 代码如下:SELECT * INTO OUTFILE ‘/test.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘

’ FRO