As shown in figure, how to set the display name in SQL-CodePudding

Home > database > As shown in figure, how to set the display name in SQL

As shown in figure, how to set the display name in SQL

Time：09-19

As shown in figure
The _MyData1 displayed as' working years, MyData2 displayed as' working hours'

Below how to display the name MyData1 into Chinese

The database column names

CodePudding user response:

Is take the data transformation or column name
Field use

 SELECT 
MyData1 as work-life 
, MyData2 as working time

Data conversion
The CASE WHEN MyData1=1 THEN... The WHEN...

CodePudding user response:

If you have the program source code, it is ok to directly change the source code!