add sqlTableCopies.mysql for runSQL.sh

[lsyyff23]

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/warehouse.csv' INTO TABLE benchmarksql.warehouse FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (w_id, w_ytd, w_tax, w_name, w_street_1, w_street_2, w_city, w_state, w_zip);

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/item.csv' INTO TABLE benchmarksql.item FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (i_id, i_name, i_price, i_data, i_im_id);

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/stock.csv' INTO TABLE benchmarksql.stock FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (s_i_id, s_w_id, s_quantity, s_ytd, s_order_cnt, s_remote_cnt, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10);

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/district.csv' INTO TABLE benchmarksql.district FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (d_id, d_w_id, d_ytd, d_tax, d_next_o_id, d_name, d_street_1, d_street_2, d_city, d_state, d_zip);

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/customer.csv' INTO TABLE benchmarksql.customer FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (c_id, c_d_id, c_w_id, c_discount, c_credit, c_last, c_first, c_credit_lim, c_balance, c_ytd_payment, c_payment_cnt, c_delivery_cnt, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_since, c_middle, c_data);

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/cust-hist.csv' INTO TABLE benchmarksql.history FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (hist_id, h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_data);

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/order.csv' INTO TABLE benchmarksql.oorder FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (o_id, o_w_id, o_d_id, o_c_id, o_carrier_id, o_ol_cnt, o_all_local, o_entry_d);

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/order-line.csv' INTO TABLE benchmarksql.order_line FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (ol_w_id, ol_d_id, ol_o_id, ol_number, ol_i_id, ol_delivery_d, ol_amount, ol_supply_w_id, ol_quantity, ol_dist_info);

LOAD DATA LOCAL INFILE '/root/tpcc/benchmarksql-mysql/run/dt/new-order.csv' INTO TABLE benchmarksql.new_order FIELDS ESCAPED BY '\' TERMINATED BY ',' LINES TERMINATED BY '\n' (no_w_id, no_d_id, no_o_id);

[waterguo]

Thanks simoz, do you want to send me a pull request?

[lsyyff23]

I can do that.

[waterguo]

thanks, code merged