Why doesn't the date format change in phpmyadmin?

Question

MySQL

Hello. I went to the SQL section and executed the following code

SELECT DATE_FORMAT(`dateend`, '%d.%m.%Y') FROM `main`

, where main is a table and dateend is a column
. And in response to me, here is a message:
"This selection does not contain a unique column. Changing the grid, ticking, editing, copying and deleting is not possible."

If you can see, at the bottom, the date format seems to have changed, but if I go back to the table, the old date format is there. Tell me how to be? How to change the date format to this form: dd.mm.yyyy?

Answer 1

With this command, you have selected a date and changed the output-only format.
the format has not changed in the database - this is normal.
either specify DATE_FORMAT each time, or change the database settings

Answer 2

If you do not want to select the data, but change it, then you can do it like this (after changing the column type, if necessary):
The notice in the yellow box tells you that you cannot change the data in the phpmyadmin visual editor, because the system does not have enough data to determine which rows you want to make changes to.