Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql --user=root --password=root -t -v -v -v --local-infile=1 -e "set profiling=1;use sgd;
- load data local infile '/Users/joaogoncalves/Desktop/Tables/part.tbl' into table part fields terminated by '|' lines terminated by '\r\n';
- load data local infile '/Users/joaogoncalves/Desktop/Tables/partsupp.tbl' into table partsupp fields terminated by '|' lines terminated by '\r\n';
- load data local infile '/Users/joaogoncalves/Desktop/Tables/customer.tbl' into table customer fields terminated by '|' lines terminated by '\r\n';
- load data local infile '/Users/joaogoncalves/Desktop/Tables/nation.tbl' into table nation fields terminated by '|' lines terminated by '\r\n';
- load data local infile '/Users/joaogoncalves/Desktop/Tables/orders.tbl' into table orders fields terminated by '|' lines terminated by '\r\n';
- load data local infile '/Users/joaogoncalves/Desktop/Tables/region.tbl' into table region fields terminated by '|' lines terminated by '\r\n';
- load data local infile '/Users/joaogoncalves/Desktop/Tables/supplier.tbl' into table supplier fields terminated by '|' lines terminated by '\r\n';
- load data local infile '/Users/joaogoncalves/Desktop/Tables/lineitem.tbl' into table lineitem fields terminated by '|' lines terminated by '\r\n';
- show profiles;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement