In case if the number of characters to be removed exceeds the number of characters available in original string then MySQL INSERT() function will continue to remove the characters until the end of the original string.Examplemysql> Select INSERT('myteststring', 3, 15, 'original'); +----------------------------------------+ | INSERT('myteststring', 3, 15, 'original') | +----------------------------------------+ ... Read More

When we run the INSERT INTO statement without giving the columns name/s and values both then MySQL will store NULL as the value of the column/s of table. Consider the example given below in which we have created a table ‘Student’ with the following query −mysql> Create table Student(RollNO INT, ... Read More

When we use INSTR() function with MySQL WHERE clause, we need to provide column name of the table as the first argument and the substring as 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 list-style-position property indicates whether the marker should appear inside or outside of the box containing the bullet points. If the text goes onto a second line, the text will wrap underneath the marker, for the value inside.Example If the text goes onto a second line, the text will be aligned with ... Read More

The list-style-image allows you to specify an image so that you can use your own bullet style.ExampleYou can try to run the following code to set an image for bullet with CSS                            Football          Cricket          

The margin-top specifies the top margin of an element. It can have a value in length, % or auto. You can try to run the following code to set the top margin:Example                            This is a paragraph with ... Read More

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

As we know that by default searching in LOCATE() function starts from beginning. We can manage the start position by giving an argument to specify the position from which we want to start the search in string. Following example will demonstrate it −Examplemysql> Select LOCATE('good', 'Ram is a good boy. ... Read More

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

The border-bottom-color property changes the color of the bottom border.ExampleYou can try to run the following code to implement the border-bottom-color property:                    p.demo {             border:3px solid;             border-bottom-color:#FF0000;          }                              Example showing border top color property