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 George John
Page 63 of 79
Program for adding 2 numbers input from keyboard in 8085 Microprocessor
We write an 8085 assembly language program of two input using two 2-digit hexadecimal numbers from the keyboard and then we add and the output results in the address field.FILE NAME ADD2NUM.ASM ORG C000H CURAD: EQU FFF7H UPDAD: EQU 06BCH CLEAR: EQU 044AH GTHEX: EQU 052FH MVI A, 0EH SIM EI ; Unmask RST5.5 and enable interrupts MVI B, 01 CALL GTHEX ; Input a 2 digit number and display in data field MOV A, E STA C100H ; Store the 2-digit hex number in C100H MVI B, 01 CALL GTHEX ; Input a 2 digit number and display in ...
Read MoreUpdating a MySQL column that contains dot (.) in its name?
If the MySQL column contains dot (.) in its name, then you need to use backticks around the column name. To understand the above concept, let us create a table. The query to create a table is as followsmysql> create table UpdateDemo -> ( -> UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> `User.FirstName.LastName` varchar(60) -> ); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into UpdateDemo(`User.FirstName.LastName`) values('John Smith'); Query OK, 1 row affected (0.14 sec) mysql> insert into UpdateDemo(`User.FirstName.LastName`) values('Adam Smith'); Query OK, ...
Read MoreDisplay interface using serial transfer in 8085 Microprocessor
In this module we have explained the complete interface of four numbers segmented into seven parts having the Light Emitting Diode which uses a serial data transfer scheme. The portion which is displayed of the interface has 4 LEDS comprises of 7-segments LEDs as we can see from the physical layout of the interface. The connection to the interface is done by the ALS-8085 kit which uses a flat table of 26 crores. We connect the connector C1 to the interface to the Input Output connector P3 on the ALS kit. There is a power supply of of +5 V ...
Read MoreHow to check current wifi supports 5 GHz band support in android?
This example demonstrate about How to check current wifi supports 5 GHz band support in 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 − Add the following code to res/layout/activity_main.xml. In the above code, we have taken a text view to show about wifi.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.net.wifi.WifiManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.view.View; import android.widget.TextView; public class MainActivity extends AppCompatActivity { TextView textView; ...
Read MoreOpcode Fetch (OF) machine cycle in 8085 Microprocessor
The OF machine cycle are constituted by the four clock cycles shown in the figure below. Here in these four clock cycles we execute opcode fetch, decode, and complete the execution. Moreover, in the instructions of 2- and 3-byte, and also in the instructions of 1 byte like ‘MOV B, M’, only OF and decode operations gets completed in these four cycles of the clock. Hence opcode fetch is consisted by the OF machine cycle and for performing the decode operation, and in some rare cases execution. For performing some typical instructions like DCX B, the six states are provided ...
Read MoreI/O Read (IOR) machine cycle in 8085 Microprocessor
The three clock cycles at the last stages in the IN 35H instruction is an example of machine cycle for IOR. The Waveforms for the IOR machine cycle are shown in the figure below.The point to be noted that in an IOR machine cycle, Wand Z has identical has port address of 8 bit. The value of 16 bit in the register pair WZ are sent out as the address in an Input Output Read machine cycle. Also the point to be noted that in an IOR machine cycle, only the data is received by the accumulator from the addressed ...
Read MoreHow to order by date and time in MySQL?
You need to use ORDER BY clause for this. Let us first create a table. The query to create a table is as followsmysql> create table OrderByDateThenTimeDemo - > ( - > Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, - > ShippingDate date, - > ShippingTime time - > ); Query OK, 0 rows affected (0.56 sec)Now you can insert some records in the table using insert command. Here, we have two similar dates, but different times i.e. 2018-01-24mysql> insert into OrderByDateThenTimeDemo(ShippingDate, ShippingTime) ...
Read MoreHow to programmatically take a screenshot in android?
This example demonstrate about how to programmatically take a screenshot in 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 − Add the following code to res/layout/activity_main.xml. In the above code we have taken two views as imageview and textview. when user click on textview, it going to take screen shot and append to imageview.Step 3 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.graphics.Bitmap; import android.graphics.Canvas; import android.os.Bundle; import android.support.v7.app.AppCompatActivity; import android.view.View; import android.widget.ImageView; import ...
Read MoreMerits of I/O-mapped I/O and demerits of memory-mapped I/O
Before having a discussion regarding the merits of I/O mapped I/O and demerits of memorymapped I/O, let us have a generic discussion regarding the difference between I/O mapped I/O and memory mapped I/O.In Memory Mapped Input Output −We allocate a memory address to an Input Output device.Any instructions related to memory can be accessed by this Input Output device.The Input Output device data are also given to the Arithmetic Logical Unit.Input Output Mapped Input Output −We give an Input Output address to an Input Output device.Only IN and OUT instructions are accessed by such devices.The ALU operations are not directly ...
Read MoreMySQL case-insensitive DISTINCT?
If you want case-insensitive distinct, you need to use UPPER() or LOWER().Case 1: Using UPPER().The syntax is as follows:SELECT DISTINCT UPPER(yourColumnName) FROM yourTableName;Case 2: Using LOWER().The syntax is as follows:SELECT DISTINCT LOWER(yourColumnName) FROM yourTableName;To understand the above syntax, let us create a table. The query to create a table is as follows:mysql> create table CaseInsensitiveDistinctDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> UserEmailId varchar(30), -> UserPassword varchar(10), -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (0.64 sec)Now you ...
Read More