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

  1. 2014.01.13 DB data simply im/export to csv file in MySQL
posted by Full-stack Developer 2014. 1. 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에 탭이 있을경우 조건식을 줘야함.