Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
NOTE: There is only one difference between AND and && is that AND is a standard while && is ownership syntax.Except the above statement, there is no difference between AND and &&. Let us look at all the conditions.The result of AND and && will always be either 1 or 0. As we know the AND and && both are logical operators, if there are more than one operand and any one of them has value 0 then result becomes 0 otherwise 1.Here is the demo of AND and &&.Case 1(a): If both operands are 1. Using AND.The query is ... Read More
The Zilog Z-80 is 40 pin DIP Microprocessor. Here we will see the actual pin level diagram of Z-80 and also the functional pin diagram of it.This is the actual pin diagram of Z-80 Microprocessor. Now we will see the functional pin diagram of it.Now let us see the Pin functions of the Z-80 microprocessor.PinsTypeFunctionA15 – A0Output16-bit address bus, which provides the addresses for memory (up to 64KB)D7 – D0Input/Output8-bit bi-directional data bus to transfer data between memory/IO devices and CPU.BUSACKOutputIt is Bus Acknowledge pin. It indicates the requesting device that the address bus, data bus, control bus enter into ... Read More
You can use in-built function UNIX_TIMESTAMP() from MySQL to get the timestamps and the difference between two timestamps. The syntax is as follows −SELECT UNIX_TIMESTAMP(yourColumnName1) - UNIX_TIMESTAMP(yourColumnName2) 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 DifferenceInSeconds −> ( −> FirstTimestamp TIMESTAMP, −> SecondTimestamp TIMESTAMP −> ); Query OK, 0 rows affected (0.93 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into DifferenceInSeconds values('2012-12-12 ... Read More
To being with, the basic difference between CV and Resume is CV is British English and Resume is an American word for your career profile. Now, leaving the vocabulary aside, there are principle differences between the two and let us look at those differences.A CV (Curriculum Vitae, which means the course of life in Latin) is an elaborate document which runs over two or more pages. It is your professional biography which speaks in detail about your achievements and accomplishments. CV covers not only your academics and career graph but also other accomplishments like publications, awards, honors etc. This document ... Read More
To combine date and time column into a timestamp, you can use cast() function with concat().The syntax is as follows −select cast(concat(yourDateColumnName, ' ', yourTimeColumnName) as datetime) as anyVariableName from yourTableName;In the above concept, you will use cast() when your date and time is in string format. The cast() function can be used only for datetime. To understand the above syntax, let us create a table.The query to create a table is as follows −mysql> create table DateAndTimeToTimestamp −> ( −> Duedate date, −> DueTime time −> ); ... Read More
Samuel Taylor Coleridge is a popular name among all Romantic poets who were influenced by the French Revolution. He was a leader of the British Romantic movement and was born on October 21, 1772, in Devonshire, England.Literary Qualities of Samuel Taylor Coleridge1. Treatment of the supernatural: He treats the supernatural in such a manner that it becomes convincing and at the same time, in some sense, a criticism of life.2. Suspension of Disbelief: The way in which Coleridge has achieved the willing suspension of disbelief has been even explained beautifully in the book The Romantic Imagination by Bowra.3. Realism: He ... Read More
You need to use LIKE with OR operator to find all the names that starts with a or b or c. The syntax is as follows:SELECT *FROM yourTableName WHERE yourColumnName like 'A%' or yourColumnName like 'B%' or yourColumnName like 'C%';The above query finds all names that starts only with the letter ‘a’ or ‘b’ or ‘c’. To understand the above syntax, let us create a table. The query to create a table is as follows:mysql> create table AllNamesStartWithAorBorC -> ( -> Id int NOT NULL AUTO_INCREMENT, -> EmployeeName varchar(20), -> PRIMARY KEY(Id) -> ); Query ... Read More
As we know that the Intel 8085 has five interrupt pins (TRAP, RST7.5, RST6.5, RST6.5 and INTR), but the Zilog Z-80 has only two interrupt pin. The NMI and INT . But it has superior interrupt structure compared to 8085.The INT InterruptIt is an active low, level triggered input interrupt. This is maskable and using DI instruction this can be disabled. When the interrupt pin is disabled, the Z-80 will not be interrupted if the IO devices enables the INT pin. Even after the reset, it will be disabled. So if we want that the MPU will be interrupted by the pin, there must be ... Read More
Human resource management is the key to establish and develop a company. We can divide the HR into two main divisions, administrative and strategic.The first division Administrative will help in, recruitment and retention of staff and other administrative responsibilities to run the office. The other division strategic management is what makes the business to grow, the company to achieve targets by talent management and helping the management to take key decisions and implement them. They can assess the companies future staffing requirement and project the workforce required to complete the project.Human resource management helps its employees to understand the business ... Read More
There is a single way by which you can set a global event_scheduler=ON even if MySQL is restarted. You need to set global system variable ON and need to use this system variable even if MySQL restart.For this, I am using system variable @@event_scheduler using select statement. The query is as follows:mysql> select @@event_scheduler;The following is the output:+-------------------+ | @@event_scheduler | +-------------------+ | ON | +-------------------+ 1 row in set (0.00 sec)Now, restart MySQL. The query is as follows:mysql> restart; Query OK, 0 rows affected ... Read More