Re: Identical input field value

[Felix Geerinckx]

M SELEEM wrote:

> 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.

INSERT INTO yourtable (field1, field2, field3, combined_field) VALUES
('very', 'bad', 'idea', CONCAT('very', '-', 'bad', '-', 'idea');

But you should *not* do this, since you're duplicating data.
Calculated fields should be computed when you need them:

SELECT
CONCAT(field1, '-', field2, '-' field3) as combined_field
FROM yourtable

--
felix
Please use BBCode to format your messages in this forum.