George John has Published 1081 Articles

How to restart MySQL server?

George John

George John

Updated on 30-Jul-2019 22:30:25

1K+ Views

Restart the MySQL Server with the help of restart command.The syntax is as followsRestartLet us first check the MySQL version.The query is as followsSELECT version();Now, implement the above command in order to restart the MySQL Server.The query is as followsmysql> restart; Query OK, 0 rows affected (0.00 sec)Case 1Now, MySQL ... Read More

Creation of .ASM file using a text editor

George John

George John

Updated on 30-Jul-2019 22:30:25

5K+ Views

The program written in assembly language is entered by us by the help of any editor, we prefer a screen editor because when we enter the program it is of no importance for the particular exact column label of instructions and the starting of the program. But the point to ... Read More

Basic or simple data transfer in 8085

George John

George John

Updated on 30-Jul-2019 22:30:25

334 Views

 The simplest data transfer scheme is the basic or simple data transfer. This method is beneficial to us when we have accurate knowledge of the Input-Output device timing characteristics. When we become familiar that the device is ready for transferring data, we execute the instructions IN and OUT, depending on ... Read More

How to get the difference between two columns in a new column in MySQL?

George John

George John

Updated on 30-Jul-2019 22:30:25

7K+ Views

Let us first create a table with columns for which we will calculate the difference in a new column −mysql> create table DemoTable (    Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    LowValue int,    HighValue int ); Query OK, 0 rows affected (0.62 sec)Insert some records in the ... Read More

The toString() method of CopyOnWriteArrayList in Java

George John

George John

Updated on 30-Jul-2019 22:30:25

132 Views

To get the string representation of the CopyOnWriteArrayList, use the toString() method in Java.The syntax is as followsString toString()To work with CopyOnWriteArrayList class, you need to import the following packageimport java.util.concurrent.CopyOnWriteArrayList;The following is an example to implement CopyOnWriteArrayList class toString() method in JavaExample Live Demoimport java.util.concurrent.CopyOnWriteArrayList; public class Demo { ... Read More

Command mode in 8085 Microprocessor

George John

George John

Updated on 30-Jul-2019 22:30:25

705 Views

We have seen previously that the linker is invoked in three modes i.e. they are command line mode, prompt mode and data file mode. For the linker to be run in this mode we type ‘LINK85 -C MULT.OBJ’ along with the change of address. In the above command simply “MULT” ... Read More

How to alter a MySQL Column from varchar(30) to varchar(100)?

George John

George John

Updated on 30-Jul-2019 22:30:25

608 Views

You need to use ALTER TABLE command along with MODIFYThe syntax is as followsALTER TABLE yourTableName MODIFY COLUMN yourColumnName varchar(100) NOT NULL;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table syntaxOfAlterCommandDemo    -> (    -> UserId int, ... Read More

Reset_in* and Reset_out pins in 8085

George John

George John

Updated on 30-Jul-2019 22:30:25

2K+ Views

Intel 8085 consists of a RESET_IN* pin which is an active low input pin. We RESET 8085 by placing a logic 0 on this pin at least for 0.5μs, after that the power is supplied to Vcc pin of 8085. Moreover, in practice we place the RESET_IN* in logic 0 ... Read More

Chip Select Logic in 8085 Microprocessor

George John

George John

Updated on 30-Jul-2019 22:30:25

1K+ Views

The master of microcomputer system is the microprocessor since all the operations of a computer are controlled by the microprocessor, the control unit often called as (CU) is found in the microprocessor. In the microcomputer system apart from processor there are several chips of RAM, CHIPS of EPROM and other ... Read More

Trap interrupt pin in 8085

George John

George John

Updated on 30-Jul-2019 22:30:25

5K+ Views

A non-maskable interrupt is a Trap Interrupt which implies that whenever this pin gets activated, the 8085 always gets interrupted even if the state of 8085 is in DI. The input of Trap input is level sensitive and edge sensitive. Hence the Trap line always makes a transition from 0 ... Read More

Advertisements