To modify an existing column’s data type, you can use MODIFY. Let us first create a table −mysql> create table DemoTable    (    ClientId varchar(100),    ClientName varchar(100),    ClientAge int,    ClientProjectDeadline timestamp,    ClientCountryName varchar(100),    isMarried boolean,    ClientNumber bigint    ); Query OK, 0 rows ... Read More

Here we will see how we transfer a block of data in reverse order using 8085.Problem StatementWrite 8085 program to transfer a block of N-bytes in reverse order. The block is stored at location 8001 onwards, the size of the block is stored at 8000. The block will be moved ... Read More

You cannot use ‘from’ as column name directly because ‘from’ is a reserved word in MySQL.If you want to still use it, then you need to use the backtick symbol.Let us first create a table −mysql> create table DemoTable    (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,   ... Read More

Let us first create a table wherein we have a Primary Key CustomerId −mysql> create table DemoTable    (    CustomerId int NOT NULL AUTO_INCREMENT,    CustomerName varchar(20),    CustomerAge int,    CustomerCountryName varchar(100),    PRIMARY KEY(CustomerId)    ); Query OK, 0 rows affected (0.94 sec)Following is the query to ... Read More

Here we will see how we can subtract two consecutive elements in an array using 8085.Problem StatementWrite 8085 program to subtract two consecutive elements of an array and store them in the same location. The results will be placed at the same location from where they are taken. The numbers ... Read More

Now let us see a program of Intel 8085 Microprocessor. In this program we will see how to generate real time clock using 8085.Problem Statement:Write 8085 Assembly language program to simulate real-time clock.Discussion:In this program we are creating a real time clock using 8085MPU. Here we are generating 1s delay ... Read More

To understand the concept, let us first create a table. The query to create a table is as followsmysql> create table ReorderSortDemo -> ( -> UserId int -> ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table ... Read More

String is a group of bytes/words and their memory is always allocated in a sequential order. String is either referred as byte string or word string. Here we will see some instructions which are used to manipulate the string related operations.The String manipulation instructions are as follows.OpcodeOperandDescriptionREPInstructionUsed to repeat the ... Read More

To remove all collections whose name matches a string, you can follow some steps. Use for loop to iterate over all collections and find that particular collection name with certain string. After that, use the drop method to remove all collections.Let’s say we are using the database “sample”. The collections ... Read More

The asLongStream() method of the IntStream class returns a LongStream consisting of the elements of this stream, converted to long.The syntax is as followsLongStream asLongStream()Create an IntStream and add some elements in the StreamIntStream intStream = IntStream.of(30, 40, 60, 70, 90, 110, 140, 150);Now, use the asLongStream() method to convert ... Read More