![]() ![]() Consider a simple example where we want to concatenate the string values “GOOD”,” MORNING!”,” HAVE”, “A NICE” and” DAY!”. This automatically results in a single concatenated string that appends all the selected strings, separated by spaces. In MySQL, you can easily concatenate strings by specifying them within single or double quotes and separating them with spaces. The execution of the above query statement gives the following output with expected strings:Īn alternative way of concatenating strings in MySQL: We can use the Concat function to do so in the following query statement: SELECT CONCAT('Word ', word, ' means that ', meaning) AS 'Meaning of Words' FROM dictionary Now, we have to concatenate the column values such that the resultant string will have the strings in the format Word “word column string” means that “meaning string”. Let us retrieve the inserted records: SELECT * FROM dictionary The execution of the above query statement shows the following output: ('panache', 'a tuft or plume of feathers', 'feather collection') ('flair', 'stylishness and originality.', 'originality'), ('knack', 'an acquired or natural skill at doing something.', 'natural skill'), ('thesaurus', 'a reference tool which shows groups of words that have similar meanings', 'representation of groups of words that have similar meanings'), ('polysemy','the fact that some words can have more than one meaning', 'multiple meaning words'), ![]() ('lexicography', 'the job or skill of writing dictionaries', 'writing dictionaries'), ('etymology', 'the study of the origins of words the origins of a particular word', 'the study of the origins'), ('connotation', 'an additional idea or emotion that a word suggests to you', 'emotions attached to words' ), ('antonym', 'a word that means the opposite of another word', 'an Alternative name'), Let us insert some records in the table using the following query statement: INSERT INTO 'dictionary' ('word', 'meaning', 'description') VALUES We will use the following table to create the table: CREATE TABLE 'dictionary' ( Let us create a dictionary table containing three columns: word, description, and meaning. We can even concatenate the values stored inside the variables and column values. The execution of the above query statement gives the following output as NULL because even a single NULL parameter can result in the output string being NULL: We will try concatenating “Welcome”, “To “, “EDUCBA” and NULL parameters using the following query – SELECT CONCAT("Welcome", "To ", "EDUCBA ", NULL) Let us try concatenating the strings with a NULL value as one of its parameters in the Concat function. The execution of the above query statement gives the following output: For this, we will use the following query statement – SELECT CONCAT("EDUCBA", "IS A GREAT ", "PLATFORM ", "TO EXPAND ", "YOUR HORIZONS ", "OF LEARNING") AS "Final String" Now, we will concatenate the string values “EDUCBA”, “IS A GREAT “, “PLATFORM “, “TO EXPAND “, “YOUR HORIZONS” and “OF LEARNING” using the Concat function in MySQL. We can observe from the output that an error is raised, saying that an incorrect number of parameters were supplied to the Concat function. The execution of the above query statement gives the following output – We will execute the following query statement – SELECT CONCAT() Let us first try to execute the MySQL Concat function without passing any parameters and see the output which is arisen. ![]()
0 Comments
Leave a Reply. |