Database has more than 30000 vehicle data, more than 1700 kinds of vehicle types,
The question now is: will the more than 1700 kinds of modified into a variety of vehicle types of fixed several vehicle types, have what good way

CodePudding user response:

First of all to have a more than 1700 kinds of a variety of vehicle types, and finally you need, fixed several vehicle types, tidy up corresponding relation, with this, it's not hard to,

CodePudding user response:

Tidy up first to modify the contents of the corresponding relation, there are two ways to
Partial batch change
1.2. Write a stored procedure, iterate through each data change

CodePudding user response:

reference 1st floor AHUA1001 response:

in the first place to have a more than 1700 kinds of a variety of vehicle types, and finally you need, fixed several vehicle types, tidy up the corresponding relationship, with this, it's not hard to,

Ok, thank you??

CodePudding user response:

refer to the second floor clouds fly me reply:

first in order to modify the contents of the corresponding relation, there are two ways to
Partial batch change
1.2. Write a stored procedure, iterate through each data change

Ok thank you!