If all the values in MySQL COALESCE() function are NULL then it returns NULL as the output. It means that this function does not find any non-NULL value in the list.Examplemysql> Select COALESCE(NULL, NULL, NULL, NULL); +----------------------------------+ | COALESCE(NULL, NULL, NULL, NULL) | +----------------------------------+ |           ... Read More

If we want to replace strings in multiple records then REPLACE() function must have the column name as 1st argument i.e. at the place of string. It means that, it will replace all the substring with another substring in that particular column. We can also use REPLACE() function with WHERE ... Read More

Suppose if we provide an empty string for padding on LPAD() or RPAD() functions then MySQL will return NULL as output. Following example will demonstrate it −Examplemysql> Select LPAD('ABCD', 22, ''); +--------------------+ | LPAD('ABCD', 22, '') | +--------------------+ | NULL               | +--------------------+ ... Read More

We can use MySQL INSERT() function to insert new string within a string after removing the characters from the original string.SyntaxINSERT(original_string, @pos, @len, new_string)Here, original_string is the string in which we want to insert new string at the place of some specific number of characters.@pos is the position at which ... Read More

When we use LOCATE() function with MySQL WHERE clause, we need to provide the substring as first argument and column name of the table as the second argument along with a comparison operator. Following is an example using ‘Student’ table to demonstrate it −ExampleSuppose we have the following values in ... Read More

The marker-offset property allows you to specify the distance between the marker and the text relating to that marker.Example You can try to run the following code to implement marker-offset property                            UK          US                      UK          US          

The margin-bottom property is used to set the bottom margin of an element. It can have a value in length, % or auto.ExampleYou can try to run the following code to set the bottom margin                            Cricket crazy nation India!                      Cricket crazy nation Australia!          

The padding-bottom specifies the bottom padding of an element. It sets the bottom padding (space) of an element. This can take a value in terms of length of %.Example                            This is a paragraph with a specified bottom padding                      This is another paragraph with a specified bottom padding in percent          

The border-right-width property changes the width of right border. You can try to run the following code to implement border-right-width propertyExample                            This is demo content.          

The border-bottom-style property changes the style of bottom border. You can try to run the following code to implement the border-bottom-style property:Example                            This is demo content