Here we will see the control words and the operation modes of the 8254 programmable interval timer chip.Before discussing its operating modes and control word properties, we should know about some important facts of this chip.When the chip is powering up, the state is undefined. The mode, count value, and ... Read More

Use the getPreviousNode() method to get the previous node of this node in Java. Here, we are displaying the previous node of child node “eight” −System.out.println("Get Previous Node = "+eight.getPreviousNode());The following is an example to get the previous node from a JTree −Examplepackage my; import javax.swing.JFrame; import javax.swing.JTree; import javax.swing.tree.DefaultMutableTreeNode; ... Read More

You can use a CASE statement for this. Let us first create a table −mysql> create table DemoTable    (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    Name varchar(20)    ); Query OK, 0 rows affected (1.11 sec)Insert records in the table using insert command −mysql> insert into ... Read More

Here we will see how to add even parity to 7-bit ASCII string using 8085.Problem StatementWrite a program to add even parity to a string of 7 bit ASCII characters. The length of the string is in memory location 8040 H and the string itself begins at memory location 8041 ... Read More

Here we will see how we can implement running light with some delays using 8085.Problem StatementWrite 8085 program to implement running light display with appropriate delays using lookup table stored from memory location 8100H on words.DiscussionThe patterns are stored at location 8100 onwards. We are using 8255 port IC to ... Read More

To convert MM/DD/YY to UNIX timestamp, you can use the below syntax −select UNIX_TIMESTAMP(str_to_date(yourColumnName, '%m/%d/%Y')) from yourTableName;Let us first create a table −mysql> create table DemoTable    (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    dateConvertToUnix varchar(100)    ); Query OK, 0 rows affected (0.58 sec)Insert some records ... Read More

Here we will see how we can add two consecutive elements in an array using 8085.Problem StatementWrite 8085 program to add two consecutive elements of an array and store them in the same location. The carry will be placed at bottom of the other byte. The numbers are stored from ... Read More

Now let us see a program of Intel 8085 Microprocessor. In this program we will generate 00H and FFH alternatively.Problem Statement:Write 8085 Assembly language program to generate 00H and FFH alternatively.Discussion:The 00H and FFH are changed alternatively in each second. So we need one second delay. We have created delay ... Read More

You can use subquery for this. Let us first create a demo tablemysql> create table uniqueBothColumnValueSameDemo    -> (    -> UserId int,    -> UserValue int    -> ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command. The query is as follows ... Read More

These instructions are used to control the processor action by setting/resetting the flag values.These are the process/processor control instructions.OpcodeOperandDescriptionSTC----Used to set carry flag CY to 1CLC----Used to clear/reset carry flag CY to 0CMC----Used to put complement at the state of carry flag CY.STD----Used to set the direction flag DF to ... Read More