我把csv的資料寫入sql，但是原csv表中是數字型的，在我的table中竟然也是數字型的，即使我設定的是varchar,求解
use o2o_stage1_lucky;
create table stage1_train_off(
user_id varchar(32),
merchant_id varchar(32),
coupon_id varchar(32),
discount_rate varchar(32),
distance varchar(32),
date_received varchar(32),
date_id varchar(32)
);
load data infile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/ccf_offline_stage1_train.csv'
into table o2o_stage1_lucky.stage1_train_off
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\n'
uj5u.com熱心網友回復：
用navicat_premium匯入吧方便快捷
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/60133.html
標籤：數據庫及相關技術