String Concatenation
Combine columns into one.
SQLite / MySQL
sql
1SELECT name || ' - ' || course AS student_info
2FROM students;Using CONCAT
sql
1SELECT CONCAT(name, ' (', age, ')') AS display
2FROM students;
Combine columns into one.
1SELECT name || ' - ' || course AS student_info
2FROM students;1SELECT CONCAT(name, ' (', age, ')') AS display
2FROM students;