- Description: Combines two strings into one.
- Purpose: Useful for creating formatted output.
- Syntax:
CONCAT(string1, string2) - Parameters: Two strings to concatenate.
- Returns: A single concatenated string.
- Example:
CONCAT('Hello', ' World')returns'Hello World'. - Notes: Can use
||operator for concatenation as well. - Use Case: Formatting names or addresses for display.
Leave a Reply