Combining two fields data into one field in the same table

sagarbaswa

I Want To Combine The First Name Field And The Last Name Field Into One Single Field In The Same Table

mwasif

Moved to MySQL Forum which is the right palce to ask the question about MySQL.

Kindly use the capital letters appropriately when posting.

mwasif

If you only want to display the name after combining the fields then simply use in this manner

Expand|Select|Wrap|Line Numbers

But if you want to save them in a separate field then use UPDATE query to update all the records in the table.

Expand|Select|Wrap|Line Numbers

 UPDATE table_name SET

full_name = CONCAT(first_name, ' ', last_name);

But why you want to save them in a separate field as you can display then as a single field in SELECT statement.

salesad

Moved to MySQL Forum which is the right palce to ask the question about MySQL.

Kindly use the capital letters appropriately when posting.

HOW MERGE IN TWO FIELDS IN A SAME TABLE

salesad

Moved to MySQL Forum which is the right palce to ask the question about MySQL.

Kindly use the capital letters appropriately when posting.

HOW MERGE IN TWO FIELDS IN A SAME TABLE IN POSTGRESQL

salesad

Merge Two Fields In Same Tale In Postgresql Database

salesad

Merge Two Fields In A Same Table

salesad

How To Merge Two Fields In Same Table In
Postgresql

mwasif

Moved to PostgreSQL Forum.

rski

select filed1 || ' '|| field2 from tabelame;