In this program we will see how to find the minimum number in a given array.Problem StatementWrite 8086 Assembly language program to find the minimum number in a given array, which is starts from memory offset 501. The size of the series is stored at memory offset 500. Store the ... Read More

The addAll() method of the AbstractList class is used to insert all of the elements in the specified collection into this list at the specified position.The syntax is as followsboolean addAll(int index, Collection

Yes, we can select second largest record from a table without using LIMIT clause. Let us first see an example and create a table −mysql> create table DemoTable (    Number int ); Query OK, 0 rows affected (0.66 sec)Insert records in the table using insert command −mysql> insert into ... Read More

Update date of datetime field with the help of arithmetic operator minus(-).The syntax is as followsupdate yourTableName set yourDateTimeColumnName=yourDateTimeColumnName - interval yourValue day where date(yourDateTimeColumnName)=’yourDateValue’;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table updateDateDemo    -> (   ... Read More

To find the highest value from sub-arrays in documents, you can use an aggregate framework. Let us first create a collection with documents> db.findHighestValueDemo.insertOne(    ... {       ... _id: 10001,       ... "StudentDetails": [          ... { "StudentName": "Chris", "StudentMathScore": 56},   ... Read More

The PGM is the Portable Gray Map. If we want to store a 2d array in C as images in PNG, JPEG, or any other image format, we have to do lots of work to encode the data in some specified format before writing into a file.The Netpbm format gives ... Read More

The following URL will pass two values to HelloForm program using the GET method.href="http://localhost:8080/main.jsp?first_name=ZARA&last_name=ALI" Below is the main.jsp JSP program to handle input given by web browser. We are going to use the getParameter() method which makes it very easy to access the passed information −           ... Read More

First of all, you need to check the host. The host can be ‘localhost’ or ‘%’. Check the existence of user accounts with host −mysql> select user, host from MySQL.user;This will produce the following output −+------------------+-----------+ | user             | host      | +------------------+-----------+ ... Read More

In this program we will see how to transfer a block from one location to another location.Problem StatementWrite 8086 Assembly language program to transfer a block from one memory section to another memory section. The numbers are stored at memory offset 501 onwards. The block size is stored at memory ... Read More

The syntax is as followsupdate yourTableName set yourColumnName1=yourValue where yourColumnName2=yourValue order by yourIdColumnName DESC LIMIT 1;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table UpdateWithHighestDemo    -> (    -> UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY,   ... Read More