MySQL 导出数据select into outfile用法

发布时间：2020-12-12 00:02:15 所属栏目：MySql教程来源：网络整理

导读：export_options: [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] span style="font-size:14px;" 语法例子：说明：xxx为本机用户名查

export_options:

[{FIELDS | COLUMNS}

[TERMINATED BY 'string']

[[OPTIONALLY] ENCLOSED BY 'char']

[ESCAPED BY 'char']

]

[LINES

[STARTING BY 'string']

[TERMINATED BY 'string']

]

<span style="font-size:14px;">
语法例子：










说明：xxx为本机用户名
查询导入数据：




查看对应目录下：<span style="font-size:14px;">可以发现上述数据已经存入到loaddatass.txt内。








                        （编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!