Guest User

Untitled

a guest
May 24th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. *env: windows 10 version mysql 5.7 Ram 32GB ide : toad mysql*
  2.  
  3. CREATE TABLE `2017` (
  4. `MOB_NO` bigint(20) DEFAULT NULL,
  5. `CAF_SLNO` varchar(50) DEFAULT NULL,
  6. `CNAME` varchar(58) DEFAULT NULL,
  7. `ACT_DATE` varchar(200) DEFAULT NULL,
  8. KEY `2017_index` (`MOB_NO`,`ACT_DATE`)
  9. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  10.  
  11. SET autocommit=0;
  12. SET unique_checks=0;
  13. SET foreign_key_checks=0;
  14. LOAD DATA LOCAL INFILE 'D:/base/test/2017/2017.txt'
  15. INTO TABLE 2017COLUMNS TERMINATED BY '|';
  16. commit;
Add Comment
Please, Sign In to add comment