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
Articles by Chandu yadav
Page 62 of 81
Prompt mode in 8085 Microprocessor
We have seen previously that the linker is invoked in three modes i.e. they are command line mode, prompt mode and data file mode. In the Prompt mode the linker is run by simply typing the ‘LINK85’. Responding to the prompt the linker requests the user for the file name. In the given example, responding with ‘MULT.OBJ’ is there in fact MULT is enough.The linker prompts for the address of the offset. The value of the offset which is input by means of the user is finally added to the value of any ORG statements in the file. In response ...
Read MoreMySQL replace values in a table?
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 varchar(10) -> ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into replaceValueDemo(Name, isGreaterThan18) values('John', 'YES'); Query OK, 1 row affected (0.24 sec) mysql> insert into replaceValueDemo(Name, isGreaterThan18) values('Carol', 'NO'); Query OK, 1 row affected (0.16 sec) ...
Read MoreRunning 8085 program in single-step mode
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 ‘>’ prompt. We can notice clearly that the change of address occurs after S. The given system clearly prompts which is stated below:The address of starting is: xxxx - yy/where the memory address is xxxx and the content of the located memory is yy which allows for responding the user ...
Read MoreRST7.5 pin in 8085
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 positive-going edge occurs on the input RST 7.5. The waveform of pin RST7.5 and output Q of RST7.5 flip-flop is shown in the Fig.Internal interrupt signal RST7.5 has a priority higher than the internal interrupt signals of RST6.5, RST5.5 and INTR. As we can see from fig the RST7.5 internal interrupt ...
Read MoreGet the second last row of a table in MySQL?
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 table secondLastDemo -> ( -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentName varchar(10) -> ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command.The query is as follows.mysql> insert into secondLastDemo(StudentName) values('Larry'); Query OK, 1 row affected (0.15 ...
Read MoreHow to check android mobile supports PRESSURE sensor?
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 above code, we have taken text view to show PRESSURE 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 textView; private ...
Read MoreWorking of 74138 decoder IC
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 are eight in number and are classified as O7*, O6*, …, O0*. A power supply of +5 V DC is needed by the chip and is Grounded. ...
Read MoreHow to Launch an application from another application on Android
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 − Add the following code to res/layout/activity_main.xml. In the above code, we have created one textview. When you click on textview, it will open YouTube.Step 3 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.content.Intent; import android.os.Bundle; import android.support.v7.app.AppCompatActivity; import android.view.View; import android.widget.LinearLayout; import android.widget.TextView; import ...
Read MoreHow to use action move event in android?
This example demonstrate about How use action move event 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 perform an action move event.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.annotation.SuppressLint; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v4.view.MotionEventCompat; import android.support.v7.app.AppCompatActivity; import android.util.Log; import android.view.MotionEvent; import android.view.View; import android.view.View.OnTouchListener; import android.widget.TextView; import android.widget.Toast; public class ...
Read MoreHow to get file extension of file as a result of MySQL query?
In order to get file extension of file as a result of SQL query, you can use SUBSTRING_INDEX().The syntax is as followsselect substring_index(yourColumnName, '.', -1) 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 getFileExtensionDemo -> ( -> File_Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> File_Name text -> ); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into getFileExtensionDemo(File_Name) values('John.AllMySQLConcept.doc'); Query OK, 1 row affected (0.17 sec) mysql> ...
Read More