There is a correlation table, column in the table has more than 20 columns, I in addition to separate a few columns do not need other used, how can we find in SQL statements and to get rid of one of the three columns, not stored procedures, are in the SQL statement, solving each bosses!!!!!!

CodePudding user response:

Additional: not with t.x xx, t.x xx, TXXX this kind of form, because there are too many columns, not beautiful

CodePudding user response:

Build a view field screening, look up when I was only a SELECT * FROM V_Table, beautiful ~ ~ ~

CodePudding user response:

This is not fixed, broadly but some columns of table under different conditions will be different, and the number will change, I want to three columns of data to calculate, but how to calculate the value of the field and other fields a piece together present

CodePudding user response:

Such as id, name, age, code, class, school in general, so sometimes changes for id, name, age, code, class, addr, phone but no matter what I need is for calculation, the age and then put into the table

CodePudding user response:

Then build a few more view

CodePudding user response:

Create a view,, and use it every time, when not just ignore it