how do i display columns as strings in mysql?

Use CONCAT to generate the output you want:

SELECT CONCAT(NAME, '.', ID) AS RESULT
FROM COMPANY
WHERE EMPLOYEES > 10000
ORDER BY EMPLOYEES;

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top