In this program we will see how to divide a 16-bit number by an 8-bit numberProblem StatementWrite 8085 Assembly language program to divide a 16-bit number by an 8-bit number.DiscussionIn this program we are taking the 16-bit number from 8000H and 8001H. The 8000H is holding the lower order byte ... Read More

The microcomputer system basically consists of three blocksThe microprocessorThe memories of microprocessor like EPROM and RAM andThe I/O ports by which they are connected.The possible data transfers are indicated below.Between the memory and microprocessor data transfer occurs by using the LDA and STA instructions.Between microprocessor and I/O ports also data ... Read More

In this program we will see how to find the HCF or GCD of two numbers using 8085.Problem StatementWrite 8085 Assembly language program to find the HCF of two numbers stored at memory location 8000H and 8001H.DiscussionThis problem is solved by the Euclidean algorithm to find HCF. This algorithm is ... Read More

We have four Counters, ranging from CR3-0, which consists of 16 bits each. At the time when the CR becomes access to the processor which is 16-bits wide, the Least Significant and the Most Significant Byte of the register are accessed in an alternate manner, which starts with the Least ... Read More

Now let us see a program of Intel 8085 Microprocessor. This program will find the LCM of two8-bit numbers.Problem StatementWrite 8085 Assembly language program to find LCM of two 8-bit numbers stored at location8000H and 8001HDiscussionIn this program we are reading the data from 8000H and 8001H. By loading the ... Read More

Many situations may arise, where a microcomputer system requires accurate time delays. For example, when we implement a real time clock, the time needs to get updated at least for once in every second.We generate accurate time delays by using a few instructions in a loop.It is completely software based, ... Read More

To count distinct values, you can use distinct in aggregate function count().The syntax is as follows −select count(distinct yourColumnName) as anyVariableName from yourTableName;To understand the above concept, let us create a table. The following is the query to create a table −mysql> create table DistinctDemo −> ( ... Read More

To validate email and phone in swift language we can use multiple conditional statements like if conditions, but that’s a long process and may contain 50-100s of if statements to validate email.So instead of conditionals we’ll use Regular expression. Swift provides NSPredicates which we can use to evaluate a regular ... Read More

To get today’s date, use in-built function CURDATE(). The CURDATE() gives only current date not time. With that, to get the records for the same day, you can try the following syntax −select yourColumnName1, yourColumnName2, ......, yourColumnNameN, DATE_FORMAT(yourDateColumnName, '%Y-%m-%d') from yourTableName WHERE DATE(yourDateColumnName) = CURDATE();To understand the above concept, let ... Read More

To get the creation date of a MySQL table, use create_time from information_schema.tables. The syntax is as follows −SELECT create_time FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'yourDatabaseName' AND table_name = 'yourTableName';My table name is 'skiplasttenrecords' and database is ‘test’.Implement the above syntax for your database and table name. The query is ... Read More