mysql之导入（LOAD DATA）导出（SELECT ...INTO OUTFILE）语法

LOAD DATA
    INFILE 'file_name'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [CHARACTER SET charset_name]
    [{FIELDS | COLUMNS}
        [TERMINATED BY 'string']
        [[OPTIONALLY] ENCLOSED BY 'char']
        [ESCAPED BY 'char']
    ]
    [LINES
        [STARTING BY 'string']
        [TERMINATED BY 'string']
    ]
    [IGNORE number {LINES | ROWS}]
    [(col_name_or_user_var
        [, col_name_or_user_var] ...)]
    [SET col_name={expr | DEFAULT}
        [, col_name={expr | DEFAULT}] ...]

SELECT ... INTO OUTFILE

CREATE TABLE blog.`abc` (
  `id` int NOT NULL,
  `a` varchar(45) DEFAULT NULL,
  `b` varchar(45) DEFAULT NULL,
  `c` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) 

INSERT INTO `abc` VALUES (1,'a','b','c'),(2,'a1','b1','c1'),(3,'a2','b2','c2');

SELECT id,a,b,c from abc INTO OUTFILE '/var/lib/mysql-files/abc.txt'；

SELECT id,a,b,c from abc INTO OUTFILE '/var/lib/mysql-files/abc2.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';

load data infile '/var/lib/mysql-files/abc.txt' INTO TABLE blog.abc;

load data infile '/var/lib/mysql-files/abc2.txt' INTO TABLE blog.abc  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';

FIELDS TERMINATED BY '	' ENCLOSED BY '' ESCAPED BY '\'
LINES TERMINATED BY '
' STARTING BY ''