• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 51
  • Last Modified:

combine data in sql

hi ,
i have customer table
whit 2 columns that i want to combine
Address         HouseNum
xxxxx                   225

i want to set the value in house num to the address if houseNum exsist
like that
address
xxxxx 225

how can i set it  ?
thanks ...
0
Tech_Men
Asked:
Tech_Men
1 Solution
 
aranaCommented:
something like this?
update customers set address=adress+" "+HouseNum where Housenum>0
or I didnt understand what you need
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now