Samual Sam has Published 2310 Articles

What type of comments does C++ support?

Samual Sam

Samual Sam

Updated on 11-Feb-2020 07:33:15

196 Views

Program comments are explanatory statements that you can include in the C++ code. These comments help anyone reading the source code. All programming languages allow for some form of comments.C++ supports single-line and multi-line comments. All characters available inside any comment are ignored by C++ compiler.Single line commentsTo create a ... Read More

How can MySQL find and replace the data with REPLACE() function to UPDATE the table?

Samual Sam

Samual Sam

Updated on 07-Feb-2020 10:42:53

1K+ Views

As we know that REPLACE () function is used to replace the occurrences of a substring with another substring within a string. We can also use REPLACE function with UPDATE statement to update the table by finding and replacing the data.Examplemysql> Update Student set Father_Name = REPLACE(Father_Name, 'Mr.', 'Shri '); ... Read More

How can we extract a substring from a string in MySQL?

Samual Sam

Samual Sam

Updated on 07-Feb-2020 05:55:34

472 Views

MySQL SUBSTRING() function can be used to extract a substring from a string. Basically SUBSTRING() returns a substring with a given length from a string starting at a specific position. It has various forms as follows −SUBSTRING(str, pos)SUBSTRING(str FROM pos)SUBSTRING(str, pos, len)SUBSTRING(str FROM pos FOR len)The forms without a len ... Read More

What happens if the length of the original string is greater than the length of the string returned after padding in LPAD() or RPAD() functions?

Samual Sam

Samual Sam

Updated on 06-Feb-2020 06:54:02

319 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

What are the different wildcard characters that can be used with MySQL LIKE operator?

Samual Sam

Samual Sam

Updated on 06-Feb-2020 06:05:04

422 Views

As we know that LIKE operator is used along with WILDCARD characters to get the string having specified string. Basically, WILDCARD is the characters that help search data matching complex criteria. Followings are the types of wildcard which can be used in conjunction with LIKE operator % -The PercentageThe ‘%’ wildcard ... Read More

Style the numbering characters in an ordered list with CSS

Samual Sam

Samual Sam

Updated on 03-Feb-2020 07:02:06

388 Views

The list-style-type property allows you to control the shape or style the numbering characters in ordered lists.Example                            India          US          UK          

Specify all the list properties into a single expression with CSS

Samual Sam

Samual Sam

Updated on 03-Feb-2020 06:58:11

123 Views

The list-style property allows you to specify all the list properties into a single expression.ExampleYou can try to run the following code to list all properties like list-style, type, etc in one line:                            Laptop          Desktop System                      Laptop          Desktop System          

Set Outset border with CSS

Samual Sam

Samual Sam

Updated on 03-Feb-2020 06:39:20

489 Views

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

The set border that looks as though it is carved into the page

Samual Sam

Samual Sam

Updated on 03-Feb-2020 06:31:55

111 Views

Use the border-style property with groove value to set a border as carved into the page. 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 carved into the page.          

Usage of border-right-style property in CSS

Samual Sam

Samual Sam

Updated on 03-Feb-2020 06:15:08

113 Views

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          

Advertisements