Skip to content

Instantly share code, notes, and snippets.

@benyaminl

benyaminl/load-infile.sql

Last active January 26, 2020 05:33
Show Gist options
  • Save benyaminl/6a1023d35e1099741a27cfff1893403c to your computer and use it in GitHub Desktop.
Save benyaminl/6a1023d35e1099741a27cfff1893403c to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Load Infile
Raw
load-infile.sql
--- Load All data Infile
SHOW VARIABLES LIKE "local_infile";
SET GLOBAL LOCAL_INFILE = 1;
SHOW VARIABLES LIKE "secure_file_priv";
load data infile
'/var/opt/rh/rh-mysql57/lib/mysql-files/saldo22.csv'
INTO TABLE hokky.`__import_all`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(a,b);
-- Load All data Infile MySQL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment