RDB

데이터 밀어넣기

CSV 밀어넣기

scp -i zoozooclub.pem ./company_data.csv ubuntu@133.186.220.38:/home/ubuntu/

DB 데이터넣는법

company

scp -i zoozooclub.pem ./company_data.csv ubuntu@133.186.220.38:/home/ubuntu/

LOAD DATA LOCAL INFILE '/home/ubuntu/company_data.csv' INTO TABLE  company FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n' (id, dart_code, name, email, homepage, corp_cls, @dummy, est_dt, description);

stock

scp -i zoozooclub.pem ./stock_data.csv ubuntu@133.186.220.38:/home/ubuntu/

LOAD DATA LOCAL INFILE '/home/ubuntu/stock_data.csv' INTO TABLE stock FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n' (id, code, name, company_id);

club

scp -i zoozooclub.pem ./club_data.csv ubuntu@133.186.220.38:/home/ubuntu/

LOAD DATA LOCAL INFILE '/home/ubuntu/user_data.csv' INTO TABLE user FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n'

account

scp -i zoozooclub.pem ./account_data.csv ubuntu@133.186.220.38:/home/ubuntu/

LOAD DATA LOCAL INFILE '/home/ubuntu/account_data.csv' INTO TABLE account FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n';

user