Karthikeya Boyini has Published 2383 Articles

What MySQL returns, if the length of the original string is greater than the length specified as an argument in LPAD() or RPAD() functions?

karthikeya Boyini

karthikeya Boyini

Updated on 07-Feb-2020 10:10:28

80 Views

In this case, MySQL will not pad anything and truncate the characters from the original string up to the value of length provided as the argument in LPAD() or RPAD() functions.Examplemysql> Select LPAD('ABCD', 3, '*'); +--------------------+ | LPAD('ABCD', 3, '*') | +--------------------+ | ABC             ... Read More

In MySQL, how can we pad a string with another string?

karthikeya Boyini

karthikeya Boyini

Updated on 06-Feb-2020 06:19:15

98 Views

MySQL has two functions namely LPAD() and RPAD() with the help of which we can pad a string with another string.LPAD() function, as the name suggests, left pads a string with another string. Following is the syntax for using it in MySQLSyntaxLPAD(original_string, @length, pad_string)Here,  original_string is the string in which ... Read More

What is the use of MySQL BINARY keyword while performing string comparison?

karthikeya Boyini

karthikeya Boyini

Updated on 04-Feb-2020 05:46:37

749 Views

When MySQL performs string comparison then it is not case-sensitive but with the help of BINARY keyword, MySQL can perform case-sensitive string comparison. It is because BINARY keyword instructs MySQL to compare the characters in the string using their underlying ASCII values rather than just their letters. It can be ... Read More

Usage of CSS list-style-image property

karthikeya Boyini

karthikeya Boyini

Updated on 03-Feb-2020 07:33:54

57 Views

The list-style-image specifies an image for the marker rather than a bullet point or number. You can try to run the following code to implement list-style-image property:Example                            Karnataka          Hyderabad          

How to control the shape or appearance of the marker with CSS?

karthikeya Boyini

karthikeya Boyini

Updated on 03-Feb-2020 07:04:41

124 Views

The list-style-type allows you to control the shape or appearance of the marker. You can try to run the following code to implement list-style-type property to work for the unordered list: Example                            Apple          Mango          Grapes          

Set Inset border with CSS

karthikeya Boyini

karthikeya Boyini

Updated on 03-Feb-2020 06:33:12

707 Views

To set inset border with CSS, use the border-style property with value inset.Example                            This is a border with none width.                      This is inset border.          

Change the width of the bottom border with CSS

karthikeya Boyini

karthikeya Boyini

Updated on 03-Feb-2020 06:30:44

122 Views

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.          

Set the color of the border with CSS

karthikeya Boyini

karthikeya Boyini

Updated on 03-Feb-2020 06:18:36

140 Views

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.          

Change the color of the left border with CSS

karthikeya Boyini

karthikeya Boyini

Updated on 03-Feb-2020 06:17:59

80 Views

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          

How can I set the color, style, and width of lines in a single property with CSS?

karthikeya Boyini

karthikeya Boyini

Updated on 31-Jan-2020 10:48:00

62 Views

The border property allows you to specify color, style, and width of lines in one property.ExampleYou can try to run the following code to specify border property:                            This example is showing shorthand property for border.          

Advertisements