-1

For Example

I have the following Columns in a DB-table: Name, Surname, Adress, Contact. In one row the value for the column name is Smith , the surname Bob and the adress Street1.

How can i combine the mentioned values to the column Contact? The Value in this row should be like this then: Bob_Smith_Street1

I want this to be automatically created in the table. so as soon as I right click on the Table -->select 1000 rows, the value is displayed. Without having me to enter the mentioned select command. Is this possible? Can anything be done when creating the table for this. So for example create table employees (Contact(name""surname""address)).

thanks

ps. sorry for my bad english:)

theKomplizierte
  • 1
  • 1

1 Answers1

0

Use CONCAT(). For example:

select concat(Name, '_', Surname, '_', Adress) as contact from t
The Impaler
  • 45,731
  • 9
  • 39
  • 76
  • thanks for the fast reply. However, I want this to be automatically created in the table. so as soon as I right click on the Table -->select 1000 rows, the value is displayed. Without having me to enter the mentioned select command. Is this possible? Can anything be done when creating the table for this. So for example create table employees (Contact(name"_"surname"_"address)). do you understand what I mean? – theKomplizierte Mar 31 '22 at 21:33
  • In that's the case, then the answer is already in the closing action: https://stackoverflow.com/questions/43526409/mysql-add-new-column-with-default-string-concat-with-data-from-existing-column – The Impaler Apr 01 '22 at 13:08