MySQL / MariaDB

Loading data

LOAD DATA INFILE

  • user_id.txt content
    110284569 
    465 
    7151077 
    
  • command to load
    mysql> load data infile 'user_id.txt' into table users (@var1) SET user_id=@var1, group_id=34, status=1
    

Reference

Last modified 2 years ago Last modified on 09/30/17 06:20:01