Mysql Tutorial (Ubuntu) - How to import csv to mysql table using LOAD DATA INFILE

Channel:
Ambar Hasbiyatmoko
Subscribers:
4,970
Published on ● Video Link: https://www.youtube.com/watch?v=x26eu_UzIyY


Category:
Tutorial
Duration: 7:12
5,472 views
29

How to import csv to mysql table using LOAD DATA INFILE.

step :
1. create .csv based on field table mysql
2. copy .csv to /var/lib/mysql-files/
3. run LOAD DATA INFILE on terminal

see this video for details.



Other Videos By Ambar Hasbiyatmoko


2019-04-22[Tutorial] PHP variable - Passing by reference
2019-04-03Tutorial FTP Ubuntu - Create a FTP user to access home directory only
2019-04-02How to fix Ubuntu 18.04 - Command ifconfig not found, but can be installed with
2019-03-31[How to fix] Android Studio - Error inflating class android widget TextInputLayout
2019-01-19How to solving Ubuntu 18.04 - 'New Document' on right click menu not appear
2019-01-13How to fix FTP Server (Ubuntu) - 550 Permission denied, cannot put file to server
2019-01-13How to install FTP and add user FTP on Ubuntu 18.04
2019-01-06Javascript Tutorial - How to send out iframe variables to outside iframe
2019-01-02Codeigniter Tutorial - How to encrypt decrypt a plain text using codeigniter 3
2018-12-31How to fix Guzzle - SSL certificate problem, self signed certificate
2018-12-30Mysql Tutorial (Ubuntu) - How to import csv to mysql table using LOAD DATA INFILE
2018-12-30How to fix bootstrap - focus() doesn't work after modal open and ajax call
2018-12-16How fix phpmyadmin in ubuntu - Parameter must be an array or an object that implements Countable.
2018-12-16How to solve error in Moodle (ubuntu) - PHP has not been properly configured with MySQLi extension
2018-12-02Moodle - install moodle version 3.5 on Ubuntu 18.04
2018-11-18Ubuntu 16.04 - How to monitor apache web server request using apache mod_status
2018-11-14Ubuntu 17.04 [error install apache2] - How to solve unable to locate package apache2
2018-10-04Codeigniter - how to install spout and export to xlsx
2018-10-01How to solve php7-zip depends libzip4 in Ubuntu 18.04
2018-09-30How to configure static IP Ubuntu 18.04 server on Virtualbox
2018-09-29How to install ubuntu server 18.04 on Virtualbox


Tags:
mysql
import
csv
excel
terminal
ubuntu
tutorial
data
linux