Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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.
The border-right-style property changes the style of right border. You can try to run the following code to implement the border-right-style property:Example This is demo content
The border-top-color changes the color of top border. You can try to run the following code to implement the border-top-color property:Example p.demo { border:3px solid; border-top-color:#FF0000; } Example showing border top color property
As we know, both the functions are used to search a string from the arguments provided in them but there are some significant differences between them as followsFIND_IN_SET() function uses the string list that is itself a string containing the substring separated by commas. Whereas, LOCATE() function contains a string from which it will find the position of the first occurrence of the substring if present. In LOCATE() function we can manage the starting point of the search by providing an optional argument for a position. Whereas, for FIND_IN_SET() function MySQL do not provide such kind of flexibility and the search ... Read More