Help needed - Identical input field value

[mseleem2005]

Help needed - Identical input field value

Hi
I have a MySQL Database table, I would like to know how could I have one of my fields in my table to have the same inputs of 3 other fields in the same table with a dash "-" between then when submiting a new entry.

The 3 fields type are VARCHAR.

Thanks in advance.
M Seleem.

 

[TonyGroves]

You could use something like:
[tt]
INSERT tbl
SET
f1='abc',
f2='def',
f3='ghi',
f4=CONCAT(f1,'-',f2,'-',f3)
[/tt]
However, you are inserting redundant data, which is usually best avoided.