Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by Ankith Reddy
Page 59 of 73
Get MySQL maximum value from 3 different columns?
To get the maximum value from three different columns, use the GREATEST() function.The syntax is as followsSELECT GREATEST(yourColumnName1, yourColumnName2, yourColumnName3) AS anyAliasName FROM yourTableName;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table MaxOfThreeColumnsDemo -> ( -> First int, -> Second int, -> Third int -> ); Query OK, 0 rows affected (0.73 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into MaxOfThreeColumnsDemo values(30, 90, 60); Query OK, 1 row affected (0.16 sec) mysql> insert into MaxOfThreeColumnsDemo values(100, ...
Read MoreGeneration of .OBJ file using a cross-assembler
Generation of .OBJ file by using a cross-assembler:The file assembly language program file, e.g. MULT.ASM which is created by using an editor is simply a text file. We cannot execute this file directly. At first we have to assemble the file, and then we have to link it. The step of assembly the translation of the program of assembly language to machine code requires the generation of a .OBJ file.We have used some examples in the text of ‘2500 A.D i.e. the 8085 cross-assembler of version 4.01.In the prompt mode the translation is:We type ‘X8085’ just for performing the translation ...
Read MoreStatus check data transfer in 8085
Status check data transfer process is a much more complex process than simple data transfer. We use this method is used when there is lack of accurate knowledge of the Input Output device consisting of the timing characteristics. Status information is received by the processor regarding the readiness of the Input Output device for performing the data transfer. Generally, the processor is involved in the checking of the loop for the device to get ready. The device releases from the loop when the device is ready for use for the execution of the IN or OUT instruction which depends on ...
Read MoreData file mode in 8085 Microprocessor
DATA FILE MODE in8085 MicroprocessorWe can refer to ‘X8085 cross-assembler’ manual for details.The format of Intel Hex: We have shown the MULT.HEX file to give a brief description at a glance.:01 C100 00 04 3A:01 C200 00 05 38:02 C300 00 00 00 3B:10 C000 00 21 00 C1 5E 16 00 21 00 C2 7E 21 00 00FE 00 CA 90:10 C010 00 17 C0 19 3D C2 12 C0 22 F7 FF 22 00C3 CD BC 06 D3:01 C020 00 76 A9:00 0000 01 FFThere are several lines which the file consists of which are termed as records. ...
Read MoreAction taken by 8085 when INTR pin is activated
We have assumed that the interrupt system gets enabled by using the EI instruction, and the signals which have higher priority are not in active state.In the penultimate clock cycle of the last machine cycle of every instruction, the 8085 senses all the internal interrupt signals.If the INTR internal signal which is at logic 1, the 8085 enters to a machine cycle which is called interrupt acknowledge (INA) machine cycle.The interrupts from the Input Output port gets acknowledged by the 8085 by the activation of INTA* pin in the T2 state of the machine cycle INA where INTA* is a ...
Read MorePin details and its address range in 8085 Microprocessor
Let us assume that we have a RAM chip of 2K x 8, It signifies that, we have 2 x 1024 = 2048 memory locations having information of 8 bits at each location. For selecting one of 2K = 211 memory locations in chip, there should be exactly input pins of 11 address lines. For bidirectional data transfer scheme, there should be eight pin involved in this process. The processor action involved in it is signified by the input pins RD* and WR*. Two pins are specified for grounding process of the pin and connecting of Direct Current of +5 ...
Read MoreHow to Get the current language in Android device?
While doing internalization in android application, we should know what is the current language in android device. This example demonstrate about how to Get the current language in Android device.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 − Add the following code to res/layout/activity_main.xml. In the above code we have taken Button. When user click on button, it will take device country name and language and append to text view.Step 3 − Add the following code ...
Read MoreProgram for simulating a stopwatch in 8085 Microprocessor
We write an 8085 assembly language program just to simulate a stopwatch for displaying minutes and seconds in the address field. There exists a provision to stop the stopwatch, along with the display for continuation to show the time just previous to the stop command.FILE NAME STOPWACH.ASM PRESSING THE ‘VECT INTR’ KEY STOPS THE STOPWATCH, WITH STATIONARY DISPLAY ORG C000H CURAD: EQU FFF7H UPDAD: EQU 06BCH RESET: LXI H, 0000H REPEAT: SHLD CURAD CALL UPDAD; Display time present in HL in the address field MVI A, 00011011B SIM ; Unmask RST7.5, Reset RST7.5 flip flop EI ; Enable interrupt ...
Read MoreHow to check android mobile supports PROXIMITY sensor?
This example demonstrate about How to check android mobile supports PROXIMITY 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 above code, we have taken a text view to show PROXIMITY sensor information.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.annotation.SuppressLint; import android.content.Context; import android.hardware.Sensor; import android.hardware.SensorManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.widget.TextView; public class MainActivity extends AppCompatActivity { TextView ...
Read MoreHow to find strings with a given prefix in MySQL?
You can use LIKE operator to find strings with a given prefix.The syntax is as followsselect *from yourTableName where yourColumnName LIKE 'yourPrefixValue%';To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table findStringWithGivenPrefixDemo -> ( -> UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> UserMessage text -> ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into findStringWithGivenPrefixDemo(UserMessage) values('Hi Good Morning !!!'); Query OK, 1 row affected (0.17 sec) mysql> insert into findStringWithGivenPrefixDemo(UserMessage) values('Hey ...
Read More