You can use a CASE statement for this. Let us first create a table −mysql> create table DemoTable    (    Number int    ); Query OK, 0 rows affected (0.71 sec)Insert records in the table using insert command −mysql> insert into DemoTable values(490); Query OK, 1 row affected (0.35 ... Read More

Here we will see how to interface PORT IC with 8085.Problem StatementON/OFF desired output LEDs connected at the output port B.DiscussionHere we will see how to On/Off LEDs at port B. We are using 8255 IC for ports. The J1 and J2 connectors to connect the 8085 and 8255. The ... Read More

You can use aggregate function MAX() and MIN() for this.Let us first create a table −mysql> create table DemoTable    (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Number1 int,    Number2 int    ); Query OK, 0 rows affected (0.89 sec)Insert records in the table using insert ... Read More

Here we will see we can take 16-bit BCD data from memory and unpack it, then store into memory using 8085.Problem StatementWrite 8085 program to take 16-bit BCD number from memory then store each digit by unpacking into different locations.DiscussionTo solve this problem, we will create one subroutine, that can ... Read More

You can use substring() for fields in MySQL to get part of string. Following is the syntax −select substring(yourColumnName, yourStartingIndex, yourEndingIndex) from yourTableName;Let us first create a table −mysql> create table DemoTable    (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Title longtext    ); Query OK, 0 ... Read More

Here we will see how we can take all numbers whose D7 and D1 bits are 0, using 8085.Problem StatementWrite 8085 program to take all numbers from an array whose D7 and D1 bits are 0. Numbers are stored from 8001, and the array size is stored at 8000. Store ... Read More

These instructions are used to perform operations where data bits are involved, i.e. operations like logical, shift, etc. We can say that these instructions are logical instructions. In 8086, the destination register may or may not the Accumulator.Let us see the logical instructions of 8086 microprocessor. Here the D, S ... Read More

The LongStream builder() class in Java is used to return a builder for a LongStream.The syntax is as follows.static LongStream.Builder builder()Here, LongStream.Builder is a mutable builder for a LongStream.To use the LongStream class in Java, import the following package.import java.util.stream.LongStream;The following is an example to implement LongStream builder() method in ... Read More

In order to connect to my table by command line, you need to use db commanddb.yourCollectionName.find();Let’s say we have a database “sample” with some collections. First check the current database> use sample; switched to db sample > db; Sample Now we have reached the database sample. The database “sample” is ... Read More

The action can be used to write the template text in JSP pages and documents. Following is the simple syntax for this action −Template dataThe body of the template cannot contain other elements; it can only contain text and EL expressions (Note − EL expressions are explained in a ... Read More