MYSQL big data import

  • 2020-05-06 11:44:53
  • OfStack

                thanks for the code!  
Write it down here, because you'll need it later; Function of information inquiry!  
Step 1: mysql  -h   localhost  -uroot    
Step 2: show   databases;  
Step 3: use   changchunmap;  
Step 4: show   tables;  
Step 5: load     infile   "d:/ c.txt "  replace     changchunmap   fields terminated       '  ';  
No;  
load   data   local   infile   "d:/migration/mysql/babel_topic.txt"   replace   into   table   babel_topic_test   fields   terminated   by   '   '  
load   data   local   infile   "d:/migration/mysql/babel_user.txt"   replace   into   table   babel_user_test   fields   terminated   by   '\t'  
During the import process, the length of some tables is changed because some field data is NULL and can be null. In order to import correctly, please ensure that the following field is modified:  
  Babel_topic:       tpc_uname   VARCHAR(192)   can be NULL    
Babel_user:       usr_password   VARCHAR(64)   can be NULL  
                    usr_nick       VARCHAR(192)   can be NULL  
load   data   local   infile   "d:/c.txt"   replace   into   table   changchunmap   fields   terminated   by   '   '  


Related articles: