Advertisement
mayankjoin3

csv into mysql

Oct 3rd, 2022 (edited)
728
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.38 KB | None | 0 0
  1. mysql -uroot -ppass --local-infile Mess -e "LOAD DATA LOCAL INFILE 'may_files.csv'  INTO TABLE may_files  FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'"
  2.  
  3. mysql -uroot -ppass --local-infile  Temp_May -e "LOAD DATA LOCAL INFILE 'v.csv'  INTO TABLE v_files  FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'"
  4.  
  5. SELECT md5, count(*) FROM `may_files` WHERE 1 group by md5 HAVING COUNT(*) > 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement