'Programming/MySQL'에 해당되는 글 1건

  1. 2014.01.13 DB data simply im/export to csv file in MySQL
posted by Solver Full-stack Developer 2014.01.13 16:54

Export DB data


SELECT (column,...] INTO OUTFILE '/tmp/backUpDB.csv' FROM [table name];

Import DB data


LOAD DATA LOCAL INFILE '/tmp/backUpDB.csv' INTO TABLE [table name];


ps data에 탭이 있을경우 조건식을 줘야함.

신고

'Programming > MySQL' 카테고리의 다른 글

DB data simply im/export to csv file in MySQL  (0) 2014.01.13