String concatenation in MySQL

I am using MySQL and MySQL Workbench 5.2 CE. When I try to concatenate 2 columns, last_name and first_name, it doesn’t work :

select first_name + last_name as "Name" from test.student

Related Posts:

  1. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  2. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  3. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  4. Create a new database with MySQL Workbench
  5. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  6. MySQL error code: 1175 during UPDATE in MySQL Workbench
  7. Cannot connect to Database server (mysql workbench)
  8. Is there a naming convention for MySQL?
  9. How to unblock with mysqladmin flush hosts
  10. Access denied for user ‘root@localhost’ (using password:NO)
  11. Which MySQL data type to use for storing boolean values
  12. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  13. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  14. Cannot delete or update a parent row: a foreign key constraint fails
  15. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  16. Your password does not satisfy the current policy requirements
  17. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  18. What is the definition of cardinality in SQL
  19. How to restart remote MySQL server running on Ubuntu linux?
  20. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  21. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  22. mysql Foreign key constraint is incorrectly formed error
  23. Selecting data from two different tables without using joins
  24. Difference between VARCHAR and TEXT in MySQL
  25. MySQL: Invalid use of group function
  26. How can I loop through all rows of a table? (MySQL)
  27. mysql: SOURCE error 2?
  28. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  29. Simple Random Samples from a Sql database
  30. What does SQL clause “GROUP BY 1” mean?
  31. LAST_INSERT_ID() MySQL
  32. SQL select only rows with max value on a column
  33. Trying to perform MINUS operation in MySQL
  34. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  35. mysql count duplicates
  36. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  37. Repair all tables in one go
  38. MySQL config file location – redhat linux server
  39. Create boolean column in MySQL with false as default value?
  40. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  41. MySql – HAVING vs WHERE 
  42. How to stop mysqld
  43. Is merge statement available in MySQL
  44. GROUP_CONCAT comma separator – MySQL
  45. Set page template for all pages?
  46. Optimize Multiple Taxonomy Term MySQL Query?
  47. WordPress MySQL & PHP Performance
  48. What specific database privileges does WordPress need?
  49. Using source control with WordPress
  50. My WordPress site always displays a cached version of its homepage
  51. Updating User Meta with SQL Query
  52. wpdb prepare syntax
  53. How to run this SQL query of wp_terms database
  54. Configure WordPress to connect to Mysql DB using SSH tunneling
  55. Proper way to work with wpdb to get user’s firstname
  56. How to change post format from Aside to Image for all posts?
  57. Inserting Hundreds of Thousands of Posts at Once
  58. wp_admin edit.php slow with lots of queries
  59. How to add and SQL query of posts only published
  60. Slow Mysql Queries
  61. can database and media folder be moved to a different drive?
  62. Find duplicate posts with same slug and author
  63. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  64. writing inner join in wpdb
  65. How to get data from WordPress site sql file
  66. Unknown collation when I import a dump from an existing site into a development database?
  67. PHP script can’t connect to Database on port 3307
  68. WordPress with php5-fpm and nginx
  69. How to split the a table in database?
  70. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  71. How to translate this mySQL query to $wpdb query
  72. $wpdb to insert html form information
  73. Proper usage of $wpdb->update()?
  74. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  75. Separate DB by yearly archive of WordPress
  76. What should a WordPress developer know about MySQL? [closed]
  77. Copyright: Get first and last date of post type
  78. Update MySQL query so that it functions again
  79. Query posts by custom taxonomy and sort by post_modified
  80. WordPress $wpdb get posts from category and sort by custom meta
  81. What’s the sql for this condition?
  82. Copy usermeta value where ID matches in the same table
  83. Array Formation Issue
  84. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  85. WordPress $wpdb no result
  86. User set date and time from frontend doesn’t get stored into database
  87. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  88. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  89. edit_user_created_user hook – using to update Groups
  90. Mysql Error in querying form entries in Gravity Form plugin
  91. Improving performance of SQL sub-queries in WordPress
  92. Saving custom term value to the database in new table
  93. MySQL errors after a WordPress clone
  94. MYSQL Join on meta key value?
  95. Complicated MySQL Query
  96. problem with quotes on new post
  97. remove wordpress post links
  98. SQL get last entry of a specific gravity form
  99. mysqldump to a tar.gz
  100. Where is my mysql log on OS X?

Leave a Comment