By smiletrl on

Hi, all,
I'm trying to convert a MSSQL VIEW to MYSQL VIEWS.
When do 'select', I want to select two columns from table as a a column in the new view, like select dbo.people.FirstName + ' ' + dbo.people.LastName from dbo.people
This doesn't work for mysql. I tried different ways, like SELECT people.FirstName.' '.people.LastName from dbo.people
Anyone could help? Thank you.

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

How about

SELECT CONCAT(people.FirstName, ' ', people.LastName) as name from people
smiletrl’s picture

smiletrl commented

Hi, nevets
Thank you so much! It works.

smiletrl’s picture

smiletrl commented

Hi, nevets, could you take a look at http://drupal.org/node/1799266.
Is it possible to get xml output in a handy way? Thank you.