To replace values in a table, use the CASE statement. To understand the concept, let us create a table. The query to create a table is as followsmysql> create table replaceValueDemo    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> Name varchar(10),    -> isGreaterThan18 ... Read More

The pins of Interrupt of 8085 are used by Input Output devices just for the initiation of the data transfer to or from 8085, without the wasting of the time of the CPU. As we have seen previously it is a very useful process when there is no well known ... Read More

Before getting into example, we should know what is Recycler view in android. Recycler view is more advanced version of list view and it works based on View holder design pattern. Using recycler view we can show grids and list of items.This example demonstrate about how to Scroll top in ... Read More

Running the program in Single-Step Mode:The single step mode is very useful for finding our program which has not yielded the desired outcomes after being executed in a single burst. We use it for program debugging. Similarly, like the operation to be executed singly ‘S’ is typed at the ‘>’ ... Read More

RST7.5 pin is an input which is edge-sensitive. Peripherals uses it for sending a pulse, rather than a sustained high level, for the interruption of the processor. Internal to 8085 we have a flip-flop which gets connected to the interrupt pin RST7.5. We set this flip-flop to 1, when a ... Read More

You need to use ORDER BY clause to get the second last row of a table in MySQL.The syntax is as follows.select *from yourTableName order by yourColumnName DESC LIMIT 1, 1;To understand the above syntax, let us create a table. The query to create a table is as follows.mysql> create ... Read More

This example demonstrate about How to check android mobile supports PRESSURE sensorStep 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml.     In the ... Read More

Let’s take an Integrated Circuit decoder. We take the popular 3 to 8 decoder Integrated Circuit 74138. The Integrated Circuit is of 16 pins.We have three input pins which are actively in high state and are classified as I2, I1 and I0. The outputs are actively in low state and ... Read More

In android, we can lunch other applications using packing name. This example demonstrate about How to Launch an application from another application on Android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 ... Read More

We write an 8085 assembly language program for finding the square of a single digit (0 to 9) using a look-up table for displaying a number and its square in the address field.FILE NAME MYSQR.ASM ORG C100H X: DB 00H, 01H, 04H, 09H, 16H, 25H, 36H, 49H, 64H, ... Read More