Mysql database need to remove the project in less than rows and columns, told me that the global search project SQL, identify which ranks to the eye is not needed, this method is now seems feasible, but I always feel a little silly -_ - | |, is there any better way for bosses,

CodePudding user response:

Some developers write *, how to analysis?

CodePudding user response:

reference 1st floor selling fruit net reply:

some developers write *, and how to analysis?

Boss said does not collect all these * * of SQL, feedback to the developers,

I think it should be at the beginning of the project to do, the basic completion of this project now,,,
Look at those dynamic SQL is ah==, light I write there one thousand lines of SQL, I now I don't understand, visual statistical difficulty is quite large,

CodePudding user response:

It should let the person to develop this function yourself to do, because a lot of people will have intention to not intentional of writing a few redundant fields, but the actual used to delete may produce some strange bugs,

Dynamic SQL is likely to be more pit, such as query field is at the front desk to write dead to the backend dynamic splicing, or from a dictionary table,,, even some people will write some triggers, stored procedures,,,

CodePudding user response:

Push this thing the boss not bottom go to,,, just throw it to me, all,,
Now I am the true, remove run

CodePudding user response:

This is difficult, it is easy to cause a system crash,
No matter how to do the backup work, otherwise easy to hang up,
Actually don't need 100, 60 points, choose a few fields, absolutely don't need to delete, and boss also won't go to verify, whether it is true that ten percent all unused fields are deleted,

CodePudding user response:

From the analysis on statement I can't, have to from the table structure and business needs analysis

CodePudding user response:

Already with the naked eye saw more than half, I really badly -, the problem is even watching the statistics after this data also can't delete the , first of all not to write their own code followed by dare not guarantee fully understand the business