Let us see an example and create a table first.mysql> create table Add1ToExistingValue    -> (    -> Value int    -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into Add1ToExistingValue values(10); Query OK,  1 row affected (0.12 sec) mysql> insert into Add1ToExistingValue values(13); Query OK,  1 row affected (0.15 sec) mysql> insert into Add1ToExistingValue values(15); ... Read More

You can use CAST() with MAX() for this. Since the string is filled with string and integer, fir example, “STU201”, therefore we need to use CAST().Let us first create a table −mysql> create table DemoTable (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    StudentBookCode varchar(200) ); Query OK, ... Read More

The interrupts in 8085 is classified into the following partsThe data transfer scheme: Executing of 8085 program where the communication process is carried out systematically and is not done directly with the Input Output device. The data transfer can be either in two forms namely parallel or serial respectively.Basic or simple ... Read More

Now let us see a program of Intel 8085 Microprocessor. In this program we will see how to add the contents of N word locations.Problem Statement:Write 8085 Assembly language program to add N 16-bit numbers stored into memoryDiscussion:The 16-bit numbers are stored into memory location 8001H onwards. The value of ... Read More

In this post you can get some details where you can buy and view free drafts of some current and past C/C++ standards.C DocumentsC11:198 CHF (https://www.iso.org/standard/57853.html)Publicly at (http://www.open-std.org/JTC1/SC22/WG14/www/docs/n1570.pdf)Wikipedia Link (https://en.wikipedia.org/wiki/C11_(C_standard_revision))C99:Cannot Purchase (https://www.iso.org/standard/29237.html)Publicly at (http://www.open-std.org/jtc1/sc22/wg14/www/docs/n1256.pdf)Wikipedia Link (https://en.wikipedia.org/wiki/C99)C90, C89, ANSI C, Standard CWikipedia Page: (https://en.wikipedia.org/wiki/ANSI_C)C++ DocumentsC++14:198 CHF (https://www.iso.org/standard/64029.html)Based On (https://www.iso.org/standard/29237.html)Wikipedia Link (https://en.wikipedia.org/wiki/ANSI_C)C++11:Cannot ... Read More

In C we cannot use function name at the left hand side of an expression. In C++ we can use it like that. This can be done by some function which returns some reference variable.A C++ function can return a reference in a similar way as it returns a pointer.When ... Read More

The is a header file. This file includes all standard library. Sometimes in some coding contests, when we have to save time while solving, then using this header file is helpful.In software engineering approach we should reduce the minimize the include. Using this header file, it will include lots ... Read More

To retrieve time as HH:MM format, use the DATE_FORMAT() function. To understand the function and retrieve time, let us create a table.The query to create a table is as followsmysql> create table retrieveTimeDemo    -> (    -> UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> UserArrivalTime datetime   ... Read More

We use this method when there is a lack of accurate knowledge of the timing characteristics of the Input Output device which takes maximum time for the device to be ready for use. Suppose we resort for the checking of data transfer; the processor here wastes a huge time in ... Read More

In a single operation, we can run the entire program of 8085. We run the entire program in this mode so that we can get the accurate results. If the process is unsuccessful a single-stepping by the entire program is attempted.We type ‘G’ at the prompt ‘>’. By noticing the ... Read More