MYSQL LOAD DATA

hy_jin·2023년 11월 23일

LOAD DATA local INFILE 'C:/Users/Administrator/Downloads/data/olist_orders_dataset.csv'
INTO TABLE orders
CHARACTER SET euckr
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(@order_id, @customer_id, @order_status, @order_purchase_timestamp, @order_approved_at, @order_delivered_carrier_date, @order_delivered_customer_date, @order_estimated_delivery_date)
SET order_id = @order_id,
customer_id = @customer_id,
order_status = @order_status,
order_purchase_timestamp = @order_purchase_timestamp,
order_approved_at= @order_approved_at,
order_delivered_carrier_date = @order_delivered_carrier_date,
order_delivered_customer_date= @order_delivered_customer_date,
order_estimated_delivery_date = @order_estimated_delivery_date
;

profile
천천히 꾸준히

0개의 댓글