In mysql, how to query all fields and convert one of the fields? for example, select * fromtablewhereid1. in table, a date field needs to be converted to stringDATE_FORMAT (updateTime, & #39; % Y-% m-% d % H: % I: % s & #39;) asupdateTime indicates that each field is not typed, is there any other way to process the date ???, If the field is too much trouble, the SQL statement will still have a long selectupdatetime field javamysql
In mysql, how can I query all fields and convert one of them?
For example, select * from table where id = 1;
In the table, there is a date field that needs to be converted to string during output.
DATE_FORMAT (updateTime, '% Y-% m-% d % H: % I: % S') as updateTime
This means that you do not need to input every field and then use the date processing method.
Is there any other way ???, If the field is too complicated, the SQL statement will be too long.