Ankith Reddy has Published 996 Articles

How to use user variables in MySQL LIKE clause?

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 09:02:51

4K+ Views

Using the CONCAT() function, we can work with user variables in LIKE clause. The syntax is as follows.set @anyVariableName='anyValue'; select yourColumnName1, yourColumnName2, yourColumnName3, ...N from yourTableName whereyourColumnName like CONCAT('%', @anyVariableName, '%');To understand the above syntax, let us first create a table. The query to create a table is as follows.mysql> ... Read More

Concat a string to SELECT * in MySQL?

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 08:59:56

229 Views

To concat a string, use the CONCAT() function from MySQL as shown in the below syntaxSELECT CONCAT(yourColumnName1, ’anyConcatenationString’), CONCAT(yourColumnName2, ’anyC oncatenationString’), ....N from yourTableName;To understand the above syntax, let us first create a table. The query to create a table is as followsmysql> create table selectConcat -> ( -> StudentId ... Read More

HTML colspan Attribute

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 08:46:43

600 Views

The colspan attribute of the element in HTML defines the number of columns a cell should span.Following is the syntax −Above, num is the count of columns a cell should span.Let us now see an example to implement the colspan attribute of the element −Example Live Demo ... Read More

HTML max Attribute

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 08:35:45

101 Views

Tha max attribute of the tag in HTML is used to set the maximum value in a progress bar.Following is the syntax −Above, num represents the number in floating-point. It displays how much effort the task necessitates.Let us now see an example to implement the max attribute of the ... Read More

HTML value Attribute

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 08:28:31

136 Views

The value attribute of the element specifies the current value of the gauge. This is a required attribute.Following is the syntax −Above, num represents the current value as a floating-point number.Let us now see an example to implement the value attribute of the element −Example Live Demo ... Read More

HTML href Attribute

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 08:18:07

285 Views

The href attribute of the element is used to set the url of the external resource.Following is the syntax −Above, the url is the url of the linked document. Let us now see an example to implement the href attribute of the element −Example ... Read More

Which element is used to add special styles to the first line of the text in a selector with CSS

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 07:16:49

151 Views

Use the :first-line element to add special effects to the first line of elements in the document. ExampleYou can try to run the following code to add special styles to the first line of textLive Demo                    p:first-line {       ... Read More

Generate Random Float type number in Java

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 06:11:10

4K+ Views

In order to generate Random float type numbers in Java, we use the nextFloat() method of the java.util.Random class. This returns the next random float value between 0.0 (inclusive) and 1.0 (exclusive) from the random generator sequence.Declaration −The java.util.Random.nextFloat() method is declared as follows −public float nextFloat()Let us see a ... Read More

Register indirect addressing mode in 8085 Microprocessor

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 06:01:50

3K+ Views

In this mode, the data is transferred from one register to another by using the address pointed by the register. Register indirect addressing mode also used to call as indirect addressing mode. For example MOV A, M: means data is transferred from the memory address pointed by the register pair ... Read More

Architecture of 8259

Ankith Reddy

Ankith Reddy

Updated on 29-Jun-2020 05:53:02

5K+ Views

8259 Microprocessor is architected in a unique style. It can program by means of some interrupts conditions by means of level or interrupt level often called edge-triggered interrupt level. Masking is done to individual interrupt bits. As the number of 8259 increases interrupt pins up to 64 can be obtained. ... Read More

Previous 1 ... 6 7 8 9 10 ... 100 Next
Advertisements