你即將離開本站

並前往https://dba.stackexchange.com/questions/239050/concatenate-two-columns-into-one-column-in-a-view-in-mysql

Concatenate two columns into one column in a view in MySQL

Yes, use concat or concat_ws: CREATE VIEW myview AS SELECT concat_ws(' ', firstName, lastName) as "User" FROM mytable;.

確定！ 回上一頁

查詢 「MySQL CONCAT column」的人也找了：

  1. MySQL CONCAT
    2.
  2. MySQL CONCAT column
    3.
  3. MySQL SELECT combine
    4.
  4. Mysql concat all columns
    5.
  5. MySQL concat all rows
    6.
  6. MySQL LIKE CONCAT
    7.
  7. Laravel concat
    8.
  8. Mysql CONCAT multiple fields
    9.