Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Use the border-style property with double value to set a border with two lines. You can try to run the following code to implement border-style property:Example This is a border with none width. This is a border with two solid lines.
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.
The margin-right property is used to set the right margin of an element. It can have a value in length, % or auto. You can try to run the following code to set the right marginExample Cricket crazy nation India! Cricket crazy nation Australia!
The border-width property allows you to set the width of element borders. The value of this property could be either a length in px, pt or cm or it should be set to thin, medium or thick.ExampleYou can try to run the following code to set the border width with CSS: David Beckham is a legend. Sachin Tendulkar is a legend.
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-color property specifies the color of a border. You can try to run the following code to implement the border-color property:Example p.demo { border:2px dashed; border-color:#800000; } David Beckham is a legend.
The border-left-color property changes the color of the left border. You can try to run the following code to implement the border-left-color property:Example p.demo { border:3px solid; border-left-color:#FF0000; } Example showing border left color property
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.
We must have to use quotes with reserved words to use them as an identifier. The quotes can be single or double depends upon ANSI_QUOTES SQL mode.If this mode is disabled then the identifier quote character is the backtick (“`”). Consider the following example in which we created a table named ‘select’ −mysql> create table `select`(id int); Query OK, 0 rows affected (0.19 sec)If this mode is enabled then we can use backtick (“`”) and double quotes (“”) both as identifier quote character. Consider the following example in which we created a table named ‘trigger’ −mysql> Create table "trigger" (id ... Read More
In case if the substring is there for more than one time in the string then MySQL LOCATE() function will return the position of the first occurrence of the substring.Examplemysql> Select LOCATE('good','Ram is a good boy. Is Ram a good boy?')As Result; +--------+ | Result | +--------+ | 10 | +--------+ 1 row in set (0.00 sec)As we can see that the substring ‘good’ is in the string for two times. The first occurrence is at position 10 and another occurrence is at position 29. MySQL returns the position of the first occurrence.