CONCAT()

1. SELECT author_fname, author_lname FROM books;
2.  
3. CONCAT(x,y,z) // from slides
4.  
5. CONCAT(column, anotherColumn) // from slides
6.  
7. CONCAT(author_fname, author_lname)
8.  
9. CONCAT(column, 'text', anotherColumn, 'more text')
10.  
11. CONCAT(author_fname, ' ', author_lname)
12.  
13. CONCAT(author_fname, author_lname); // invalid syntax
14.  
15. SELECT CONCAT('Hello', 'World');
16.  
17. SELECT CONCAT('Hello', '...', 'World');
18.  
19. SELECT
20. CONCAT(author_fname, ' ', author_lname)
21. FROM books;
22.  
23. SELECT
24. CONCAT(author_fname, ' ', author_lname)
25. AS 'full name'
26. FROM books;
27.  
28. SELECT author_fname AS first, author_lname AS last,
29. CONCAT(author_fname, ' ', author_lname) AS full
30. FROM books;
31.  
32. SELECT author_fname AS first, author_lname AS last,
33. CONCAT(author_fname, ', ', author_lname) AS full
34. FROM books;
35.  
36. SELECT CONCAT(title, '-', author_fname, '-', author_lname) FROM books;
37.  
38. SELECT
39. CONCAT_WS(' - ', title, author_fname, author_lname)
40. FROM books;