Now I need a quarter to excel data import to mysql, excel data article number in between 30 w, 20 w about import requirements are as follows:

Now need to excel content into two tables, a user (id (on the primary key), name, telephone, address), a single table (work order number, type, category,
User_id), but the import order table, each time find user_id, leading to a long time, do you have any good method?

CodePudding user response:

If can't find how to deal with when the user_id, interruption, submit, or all rolled back? Can build a table, do not check the import single table, after completion of the import again according to the demand will be import data processing, so need not seek a each record,

CodePudding user response:

User_id upon index

CodePudding user response:

refer to the second floor rucypli response:

user_id upon index

I added in the user_id index, but always is very slow

CodePudding user response:

reference 1st floor shinesky response:

how to deal with such as can not find the user_id, submit, or all rolled back? Can build a table, do not check the import single table, after completion of the import again according to the demand will be import data processing, so need not seek a each record,

Can't find the user_id, skip this article data, read on