Home > database >  Why is automatically added to the load data infile behind a new line
Why is automatically added to the load data infile behind a new line

Time:09-23

Using the load data infile "n.t xt" into table table name (field name)
Other fields have data in a table, want to import one of no data field, why is when imported into other new lines, instead of on line have already inserted,
How to field import data in the existing line,

CodePudding user response:

This statement is to import the data, if you want to update existing fields, suggest to create a new table, the data into the table, then according to the correlation update you need to watch,
  • Related