Advertisement
Guest User

Untitled

a guest
Mar 6th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.26 KB | None | 0 0
  1.   mysql  --user=root --password=root -t -v -v -v --local-infile=1 -e "set profiling=1;use sgd;
  2.  load data local infile '/Users/joaogoncalves/Desktop/Tables/part.tbl' into table part fields terminated by '|' lines terminated by '\r\n';
  3.  load data local infile '/Users/joaogoncalves/Desktop/Tables/partsupp.tbl' into table partsupp fields terminated by '|' lines terminated by '\r\n';
  4.  load data local infile '/Users/joaogoncalves/Desktop/Tables/customer.tbl' into table customer fields terminated by '|' lines terminated by '\r\n';
  5.  load data local infile '/Users/joaogoncalves/Desktop/Tables/nation.tbl' into table nation fields terminated by '|' lines terminated by '\r\n';
  6.  load data local infile '/Users/joaogoncalves/Desktop/Tables/orders.tbl' into table orders fields terminated by '|' lines terminated by '\r\n';
  7.  load data local infile '/Users/joaogoncalves/Desktop/Tables/region.tbl' into table region fields terminated by '|' lines terminated by '\r\n';
  8.  load data local infile '/Users/joaogoncalves/Desktop/Tables/supplier.tbl' into table supplier fields terminated by '|' lines terminated by '\r\n';
  9.  load data local infile '/Users/joaogoncalves/Desktop/Tables/lineitem.tbl' into table lineitem fields terminated by '|' lines terminated by '\r\n';
  10.  show profiles;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement