mysql 百万计数据导入--Load data infile

最新推荐文章于 2023-09-27 13:48:32 发布

原创最新推荐文章于 2023-09-27 13:48:32 发布

· 214 阅读

0 ·

版权

文章标签：

#mysql #数据库 #java #sql #开发语言

百万计数据导入MySQL时候如果是每条数据都 insert 会很慢

mysql> set global local_infile = 1;
mysql> select @@local_infile;

mysql> load data local infile '/home/mysql/biz_appointment.sql' into table biz_appointment fields terminated by ','' lines terminated by '\n' (`ID`, `ORDER_ID`, `HOSPITAL_ID`, `HOSPITAL_NAME`, `ACCOUNT_ID`, `PATIENT_ID`, `PATIENT__NAME`, `MARK_NO`, `HIS_PATIENT_ID`, `DOCTOR_ID`, `DOCTOR_NAME`, `DEPARTMENT_ID`, `DEPT_NAME`, `HIS_REG_NO`, `POINTT_ID`, `HIS_APPOINTMENT_NAME`, `BOOK_DATE`, `REG_DATE`, `CONTACT_NO`, `STATUS_ID`, `STATUS_NAME`, `MED_STATUS_ID`,  `REG_LEVEL_ID`, `REG_LEVEL_NAME`, `TOTAL_FEE`, `DIAGNOSE_FEE`, `REG_FEE`, `INSPECT_FEE`, `SPECIAL_FEE`, `SUM_FEE`,, `PUB_FEE`, `CKKIN_STATUS`, `IS_NEED_PAY`, `REG_TYPE`, `QUEUE_NO`, `CLOUD_STATUS`, `CLOUD_DESC`, `CLOUD_MED_REMIND`, `APPOINT_WAY``, `ENABLE`, `CREATE_BY`, `CREATE_DATE`, `UPDATE_BY`, `UPDATE_DATE`, `PUSH_FLAG`, `OVER_TIME`);

fields terminated by # 指定字段的分隔符

lines terminated by # 指定每行记录的分隔符，默认是换行符