CONCAT() & CONCAT_WS String functions in SQL/ MySQL || Mysql Tutorial Series || Code With Neha
In my previous video of MySQL series I have discussed about char() and char length string in SQL or MySQL you can check the video from above i button
Today I will be discussing about CONCAT and CONCAT ws string function in SQL
So without any further delay let's get started
CONCAT() Function
The CONCAT() function adds two or more expressions together.
. Syntax
CONCAT(expression1, expression2, expression3,...)
There is another string function which doesn't require to insert null string for a gap
CONCAT_WS() Function
The CONCAT_WS() function adds two or more expressions together with a separator.
Syntax
CONCAT_WS(separator, expression1, expression2, expression3,...)
The main differences between CONCAT and CONCAT_WS in SQL are how they handle separators and NULL values.
CONCAT appends strings end-to-end without a built-in separator. Any separator must be manually included as a separate argument within the function call.
CONCAT_WS (Concatenate With Separator) uses a specified separator (its first argument) between all subsequent strings. This makes for cleaner code when a common delimiter is needed, like for addresses or CSV formats
that's all for today
will discuss rest of the string function one by one in my upcoming videos
Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy
#mysql
#mysql_workbench
#mysql8
#mysqlserver
#mysqldba
#mysqltutorials
#mysqldb
#mysqldatabase
#sql
#sqlbasics
#sqlserver
#sqlfunctions
#sqlfundamentals
#sqlstringfunctions
#ascii
#ASCIISTRING
#ASCIISTRINGFUNCTIONS
#mysqltutorialforbeginners
#sqltutorialforbeginners
#strings
#stringfunctions
#stringfunctionsinsql
#stringfunctionsinmysql
#mysqlstringfunction
#sqlstringfunction
#concat
#concatstringfunction
#concatfunction
#concatfunctioninsql
#concatfunctioninmysql
#concatwsfunction
#concatwsstring
#concatwsstringfunctionsql