https://help.superhosting.bg/en/mysql-import-txt-load-data-local-infile.html
  • bg
  • en

Hosting, Domains, Virtual Private Servers (VPS), Managed VPS, SSL Certificates

MySQL

How to Import Data From Text File Using MySQL Query

If you need to import data from text file (.txt, .csv, …) to a database table, you should use LOAD DATA LOCAL INFILE instead of LOAD DATA INFILE. For example: LOAD DATA LOCAL INFILE ‘/home/cpaneluser/data.txt’ INTO TABLE Data; LOAD DATA LOCAL INFILE ‘file-path’ INTO TABLE table-name; You need to upload the text file to your hosting… »

MySQL (relational database)

MySQL is a relational database using SQL (Structured Query Language) – the most popular language for database information adding, accessing, and processing. The base is open source; it may be downloaded from the Internet and used by anyone based on their needs without a license. MySQL’s advantage is that specific data may be stored in a large number of… »

database

All rights reserved © 2005-2019 , www.superhosting.bg