Add three columns into one Address column: SELECT CONCAT(Address. ![]() ![]() 5, Vaniga Valaagam,, Old Bus Stand,, Salem, Tamilnadu, India - 636001Ĭan someone suggest a way to achieve both. The CONCAT() function adds two or more expressions together. User_id pagetitle companyname Category1 Category2 Categor圓ĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Audio Visual Equipment Audio Visual Equipment- Rentalsĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Outdoor Media Advertising- Signs, Neon, Glow Etcĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Printing & Printers Digital Printingĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Printing & Printers Flexographic Printingĥ09 Digital Arts Digital Arts Advertising, Media & Promotions Audio Visual Equipment, Outdoor Media, Printing & Printers, Printing & Printers Audio Visual Equipment- Rentals, Advertising- Signs, Neon, Glow Etc, Digital Printing, Flexographic PrintingĪnd also merge content from multiple columns to 1 eliminating the empty columns.Īddress buildingname landmark Locality sublocality City State Country pincodeĥ Vaniga Valaagam Old Bus Stand Salem Tamilnadu India 636001Īs if i use concat() with separators the above also includes empty and include multiple separators. Then use CONCAT SELECT CONCAT (id,' ',name,' ',citizens) listing FROM ( SELECT A.id,A.name,GROUPCONCAT (B.name,' ',B.surname) citizens FROM city A INNER JOIN citizen B ON A.id B.cityid GROUP BY A.id,A. In this case, we use GROUPCONCAT function to concatenate multiple rows into one column. Take distinct of each column and concatenate if multiple distinct exists for a record 1 Answer Sorted by: 2 You need to use GROUPCONCAT to aggregate the citizen names first.I am using mysql and want to do the following:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |