select * from rr_bind_info into outfile 'data.txt' fields TERMINATED BY ',';
load data infile 'data.txt' into table rr_bind_info1 fields terminated by ',';
这两个函数可以实现数据的导入和导出!
文章标签 select into outfile load data infile 文章分类 数据库
select * from rr_bind_info into outfile 'data.txt' fields TERMINATED BY ',';
load data infile 'data.txt' into table rr_bind_info1 fields terminated by ',';
这两个函数可以实现数据的导入和导出!
oceanbase运维,it小白,OB数据库
mysql导入数据load data infile用法整理
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M