Does CONCAT change the database table?

Question

Does CONCAT change the database columns? So if you did a SHOW columns FROM tablename would you see the newly created column resulting from the CONCAT function?

-Thanks

Answer 1

No, if you do-
SHOW columns FROM table_name;
It will display the actual column name which was given to it at the time of table creation.

When you use the CONCAT function, it results a temporary change in the column name which is only at the time of display of your result.