MySQL database function concat field type conversion, field stitching

    SelectL.lid, Group_concat (s.name) shopname, M.realname, U.name, M.phone, A.name, Concat (l.progress,"')     fromloan L, Bank B, Merchant M, Bank_user u, area A, shop swhereL.bid=B.bid andL.mid=M.mid andL.uid=U.uid andB.aid=a.id andL.lid=S.lidGROUP  byL.lid

Shop to loan is many to one, group_concat (s.name) can be a lid of multiple shop.name with "," splicing up

Clever conversion of field types!

Concat (l.progress,") 

Convert other types of progress fields to varchar, or string output!
Prevents errors when data is removed from the library (for example, true/false after tinyint type is removed)

MySQL database function concat field type conversion, field stitching