MySQL, Concatenate two columns

by

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`

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. SQL Print the name of all Employees together with the name of their supervisor
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. multiple query same table but in different columns mysql
  6. How can I temporarily disable a foreign key constraint in MySQL?
  7. How to do a batch insert in MySQL
  8. MySQL offset infinite rows
  9. Ordering by the order of values in a SQL IN() clause
  10. Creating a “Numbers Table” in MySQL
  11. SQL Selecting from two Tables with inner join and limit [duplicate]
  12. MySQL Group by SUM
  13. Get the latest date from grouped MySQL data
  14. In SQL, how to select the top 2 rows for each group
  15. Mysql query to dynamically convert rows to columns on the basis of two columns
  16. MySQL Error 1264: out of range value for column
  17. How to change the default port of mysql from 3306 to 3360
  18. Special Characters in MySQL Table Name
  19. Is it possible to reference one column as multiple foreign keys?
  20. MySQL: How do I join same table multiple times?
  21. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  22. How to set a MySQL row to READ-ONLY?
  23. Split a string and loop through values in MySQL stored procedure
  24. How to create dummy variable columns for thousands of categories in Google BigQuery?
  25. MySQL Select Query – Get only first 10 characters of a value
  26. Most efficient way to store IP Address in MySQL [duplicate]
  27. Getting first day of the week in MySql using Week No
  28. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  29. mysql select id and name from other table and join query
  30. ORDER BY alphabet first then follow by number

Leave a Comment