Netzflut

Webdesign, Webentwicklung, Drupal & Zeuchs

Import text file to mysql

Webdevelopment

Drupal

Betriebssysteme

Design

Sonstige

Mo., 23/09/2013 - 01:05

Infos

http://dev.mysql.com/doc/refman/5.1/de/load-data.html

https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html#:~:text=For%20the%20mysql%20client,%20local,-infile%5B=1%5D%20option.

https://mariadb.com/kb/en/load-data-infile/

 

LOAD DATA LOCAL INFILE '/mnt/www/verben.txt' INTO TABLE verben_import character set UTF8 FIELDS TERMINATED BY '\n' LINES TERMINATED BY '\n'

Webdevelopment
Datenbanken
Add new comment
The content of this field is kept private and will not be shown publicly.
About text formats

Plain text

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <drupal-entity data-*>
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.

User Menu

Flag List

Last Edit