Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- LOAD DATA INFILE "file.txt path"
- INTO TABLE tableName
- FIELDS TERMINATED BY ','
- LINES TERMINATED BY '\r\n';
- Example of file content :
- 7839, KING, PRESENT, 0, 17-Nov-81, 22332, 0, 10
- for schema :
- CREATE TABLE employer (
- empno INT NOT NULL,
- ename VARCHAR(45) NULL,
- job VARCHAR(50) NULL,
- mgr INT NULL,
- hiredate VARCHAR(40) NULL,
- sal INT NULL,
- comm INT NULL,
- deptno INT NULL,
- PRIMARY KEY (empno)
- );
RAW Paste Data