Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- *env: windows 10 version mysql 5.7 Ram 32GB ide : toad mysql*
- CREATE TABLE `2017` (
- `MOB_NO` bigint(20) DEFAULT NULL,
- `CAF_SLNO` varchar(50) DEFAULT NULL,
- `CNAME` varchar(58) DEFAULT NULL,
- `ACT_DATE` varchar(200) DEFAULT NULL,
- KEY `2017_index` (`MOB_NO`,`ACT_DATE`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- SET autocommit=0;
- SET unique_checks=0;
- SET foreign_key_checks=0;
- LOAD DATA LOCAL INFILE 'D:/base/test/2017/2017.txt'
- INTO TABLE 2017COLUMNS TERMINATED BY '|';
- commit;
Add Comment
Please, Sign In to add comment