2020-01-20: mysql, a table with 300 million data, not table, requirements are in the big table to add a column of data, the database can't stop, and increases the deletion operation, could you tell me how to operate? # # f greatly architects a daily topic

CodePudding user response:

Still as usual, the new table, what are all the same, the data also fall in the past, (regret medicine ready first)
Or select a user action less time
Then the table name changes, problems immediately change back, looking for user's right