MySQL Concatenate two columns

Question

There are two columns in a MySQL table  SUBJECT and YEAR    I want to generate an alphanumeric unique number which holds the concatenated data from SUBJECT and YEAR   How can I do this   Is it possible to use a simple operator like

User · Answer

In php  we have two option to concatenate table columns   First Option using Query  In query  CONCAT keyword used to concatenate two columns  SELECT CONCAT  SUBJECT        YEAR   AS subject year FROM  table name     Second Option using symbol        After fetch the data from database table  assign the values to variable  then using       Symbol and concatenate the values   subject    row  SUBJECT     year    row  YEAR     subject year    subject          year    Instead of underscore        we will use the spaces  comma  letters numbers  etc

User · Answer

You can use php built in CONCAT   for this   SELECT CONCAT  name         email   as password email FROM  table     change filed name as your requirement  then the result is    and if you want to concat same filed using other field which same then  SELECT filed1 as category filed2 as item  GROUP CONCAT CAST filed2 as CHAR   as item name FROM  table  group by filed1    then this is output

User · Answer

You can use the CONCAT function like this   SELECT CONCAT  SUBJECT         YEAR   FROM  table    Update   To get that result you can try this   SET  rn    0   SELECT CONCAT  SUBJECT   -   YEAR   -  LPAD  rn     rn 1 3  0    FROM  table

User · Answer

In query  CONCAT WS   function  This function not only add multiple string values and makes them a single string value  It also let you define separator                                               etc    Syntax     CONCAT WS  SEPERATOR  column1  column2         Example SELECT  topic   CONCAT WS   quot   quot   subject  year   AS subject year  FROM table

User · Answer

crud- gt set relation  id   students    first name   last name      crud- gt display as  student id   Students Name

[php] MySQL, Concatenate two columns

Examples related to php

Examples related to mysql

Examples related to sql