导入时连接列（MySQL / phpmyadmin）

Question

I have a table with a basic structure... column1, column2, column3.

When I upload to this table on phpmyadmin (or any other environment for that matter), I would like to be able to add a fourth column which is a concatenation of the three columns being uploaded.

Is there any way of creating a column which is the equivalent of CONCAT(column1, column2, column3) as column4 so that each time I import to this table, column4 will be populated automatically?

I'm trying to avoid having to do this work before import or after, which I presume would require creating an additional table.

Any help would be appreciated.

Cheers, Ste

Answer 1

I don't think you need to create a extra column in your database rather you can just do the same while displaying the data using a SELECT statement saying

SELECT column1, column2, column3,
CONCAT(column1, column2, column3) as column4
FROM table1;