我从工作正常的表创建了一个VIEW。问题是在我的表中,我将“ FIRSTNAME”和“ LASTNAME”作为单独的列。在我看来,我想将它们串联在一起作为一个全名。
MySQL:
CREATE VIEW leader_table AS
SELECT
lgl_leaders.LEAD_ID,
lgl_type.LG_TYPE,
member_db.FIRSTNAME AS PRIMARY_FNAME,
member_db.LASTNAME AS PRIMARY_LNAME,
lgl_leaders.LG_ADDRESS,
lgl_leaders.LG_CITY,
lgl_leaders.LG_ZIP,
lgl_leaders.LG_LAT,
lgl_leaders.LG_LNG,
lgl_leaders.CHILDCARE,
lgl_leaders.LG_DAY,
lgl_leaders.LG_TIME
FROM
lgl_leaders,lgl_type,member_db
WHERE
lgl_type.IDNUM = lgl_leaders.LG_TYPE
AND member_db.IDNUM = lgl_leaders.PRIMARY_LEADER
一个例子是:
member_db.FIRSTNAME:“ BOB”
member_db.LASTNAME:“ SMITH”
我希望一个单元格(称为“ FULLNAME”)显示为:“ BOB SMITH”,而不要使用单独的列。
如何修改视图以将两个字符串连接在一起?
利用 CONCAT()
CREATE VIEW leader_table AS
SELECT
lgl_leaders.LEAD_ID,
lgl_type.LG_TYPE,
CONCAT(member_db.FIRSTNAME ," ",member_db.LASTNAME ) FULL_NAME,
lgl_leaders.LG_ADDRESS,
lgl_leaders.LG_CITY,
lgl_leaders.LG_ZIP,
lgl_leaders.LG_LAT,
lgl_leaders.LG_LNG,
lgl_leaders.CHILDCARE,
lgl_leaders.LG_DAY,
lgl_leaders.LG_TIME
FROM
lgl_leaders,lgl_type,member_db
WHERE
lgl_type.IDNUM = lgl_leaders.LG_TYPE
AND member_db.IDNUM = lgl_leaders.PRIMARY_LEADER
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句