MySQL concatenation operator

by

|| is the ANSI standard string concatenation operator, supported by most databases (notably not MS SQL Server). MySQL also supports it, but you have to SET sql_mode="PIPES_AS_CONCAT"; or SET sql_mode="ANSI"; first.

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 make SQL case sensitive string comparison on MySQL?
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. How to do a batch insert in MySQL
  9. MySQL offset infinite rows
  10. Ordering by the order of values in a SQL IN() clause
  11. Creating a “Numbers Table” in MySQL
  12. SQL Selecting from two Tables with inner join and limit [duplicate]
  13. Can a foreign key reference a non-unique index?
  14. MySQL Group by SUM
  15. Get the latest date from grouped MySQL data
  16. In SQL, how to select the top 2 rows for each group
  17. Mysql query to dynamically convert rows to columns on the basis of two columns
  18. MySQL Error 1264: out of range value for column
  19. MySQL error 1241: Operand should contain 1 column(s)
  20. How to set a MySQL row to READ-ONLY?
  21. Split a string and loop through values in MySQL stored procedure
  22. How to create dummy variable columns for thousands of categories in Google BigQuery?
  23. Mysql: Order by like?
  24. MySQL Select Query – Get only first 10 characters of a value
  25. Most efficient way to store IP Address in MySQL [duplicate]
  26. Getting first day of the week in MySql using Week No
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. mysql select id and name from other table and join query
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment