Small is beautiful. Free UNIX!!!! :: [mysql] import from file data

[mysql] import from file data

Posted at 2009/08/05 15:38
Filed under db 이야기

로컬일 경우 :
load data infile '파일명' into table 테이블명

리모트일 경우 :
조건 : 서버와 클라이언트 모두 local-infile옵션 on 상태
mysql> show variables like 'local%';
load data local infile '파일명' into table 테이블명

크리에이티브 커먼즈 라이센스

이 저작물은 크리에이티브 커먼즈 코리아 저작자표시-비영리-변경금지 2.0 대한민국 라이센스에 따라 이용하실 수 있습니다.

Posted by ⓒ쟁이™

Tag: file, import, load, mysql
Response: 5 Trackbacks , No Comment
RSS :: http://funix.net/rss/response/50

Trackback URL : http://funix.net/trackback/50

Trackbacks List

Phentermine cheap no prescription.
Tracked from Cheap 37 5 phentermine. 2010/03/28 21:51 Delete
Phentermine cheap no prescription. Cheap phentermine.
Phentermine adipex.
Tracked from Phentermine side effects. 2010/03/29 04:37 Delete
Phentermine. Phentermine cod.
Buy phentermine mg.
Tracked from Buy cheap phentermine. 2010/04/06 01:13 Delete
Buy phentermine. Mg buy phentermine. Phentermine sales gt buy phentermine online.
Buy cheap phentermine online.
Tracked from Best phentermine cheap and fast. 2010/05/06 23:49 Delete
Cheap phentermine. Cheap phentermine cod pharmacy online.
Phentermine cheap.
Tracked from Buy cheap phentermine mg tabs lowest prices. 2010/05/25 11:32 Delete
Cheap phentermine. Buy prozac phentermine online free shipping cheap. Cheap phentermine pay cash on delivery. Cheap phentermine index.