String concatenation in MySQL

Question

I am using MySQL and MySQL Workbench 5 2 CE  When I try to concatenate 2 columns  last name and first name  it doesn t work    select first name   last name as  Name  from test student

User · Answer

Use concat   function instead of   like this   select concat firstname  lastname  as  Name  from test student

User · Answer

That s not the way to concat in MYSQL  Use the CONCAT function Have a look here  http   dev mysql com doc refman 4 1 en string-functions html function concat

User · Answer

MySQL is different from most DBMSs use of   or    for concatenation  It uses the CONCAT function   SELECT CONCAT first name       last name  AS Name FROM test student   As  eggyal pointed out in comments  you can enable string concatenation with the    operator in MySQL by setting the PIPES AS CONCAT SQL mode

User · Answer

Try   select concat first name last name  as  Name  from test student   or  better   select concat first name     last name  as  Name  from test student

[mysql] String concatenation in MySQL

Examples related to mysql

Examples related to mysql-workbench

Examples related to concat