Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
project-collie
project-collie
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 5
    • Issues 5
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge requests 2
    • Merge requests 2
  • Operations
    • Operations
    • Incidents
  • Analytics
    • Analytics
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • granite
  • project-collieproject-collie
  • Wiki
    • Data_pump
    • Writers
  • file

file · Changes

Page history
compatible authored Apr 27, 2020 by 宋志鹏's avatar 宋志鹏
Hide whitespace changes
Inline Side-by-side
Showing with 8 additions and 2 deletions
+8 -2
  • data_pump/writers/file.md data_pump/writers/file.md +8 -2
  • No files found.
data_pump/writers/file.md
View page @ a499d976
......@@ -46,8 +46,14 @@
将csv_dialect设为 mysql 生成的CSV文件可以使用mysqlimport导入到mysql中。
```
@宋志鹏 在这里贴一个mysqlimport完整命令
mysqlimport --verbose
--fields-terminated-by='\t' \
--lines-terminated-by='\n' \
--fields-enclosed-by='' \
-h {host} -P {port} -u{user} -p{password} \
--force \
--columns="{fields}" \
--local {database} {table}.csv
```
#### 为excel准备数据
......
Clone repository
  • README
  • data_pump
    • data_pump
    • filters
    • filters
      • bloom
    • readers
    • readers
      • file
      • kafka
      • mongodb
      • sql
    • writers
    • writers
      • file
  • dev_guide
  • dev_manual
  • Home
  • ops
    • ansible
View All Pages