Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
DAA instruction in 8085 Microprocessor
Let us consider we want to add two decimal numbers 38 and 45. They will be represented in BCD as 0011 1000 and 0100 0101. The addition results in 0111 1101. But the answer will be incorrect if we want to interpret this result as a BCD number. The result will be not only incorrect but also illegal as 1101, which we obtained as the last nibble in the answer is not a valid BCD number. Here, in such situations, we can use DAA to have the BCD sum as outcome. All that is required to be done is to ...
Read MoreHow can I improve my spoken English?
No one can deny the value of English in the current era where it becomes difficult to survive without the knowledge of this precious language. Moreover, you receive a fine bouquet of respect and honor by folks around you if you are a good orator of this language. Knowing English also gives you a great social status and adds value to your personality.Therefore, it becomes imperative to speak in English. But how? Because, for some, it’s extremely difficult to utter even a few words in English when asked. They literally start trembling. But what? Speaking in English is must as ...
Read MoreHow can I select the row with the highest ID in MySQL?
You can select the row with highest ID in MySQL with the help of ORDER BY with LIMIT OFFSETThe syntax is as follows −select *from yourTableName order by yourColumnName desc limit 1 offset 0;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table HighestIdOrderBy −> ( −> EmployeeId int, −> EmployeeName varchar(200) −> ); Query OK, 0 rows affected (0.58 sec)Insert records in the table with the help of insert command. The query is as follows −mysql> insert into HighestIdOrderBy values(200, 'David'); Query OK, ...
Read MoreWhat is the significance of Ajanta Caves?
The UNESCO Heritage site of Ajanta caves is located in Aurangabad, Maharashtra. These caves were excavated as a part of the first wave of cave architecture in India. It became an important center for Buddhist religion and art under the enlightened patronage of the Vakataka rulers. However, it is important to note that the excavations of these caves happened in different phases in different time periods beginning in the 2nd Century.The aerial view of the site looks like a horseshoe. This site was abandoned during the 6th-7th centuries and was rediscovered only during the British period by an Army officer ...
Read MoreChange One Cell's Data in MySQL?
Update only one cell’s data with the help of UPDATE command. The syntax is as follows −UPDATE yourTableName yourColumnName=yourNewValue where yourColumnName=yourOldValue;To understand the above concept, let us first create a table. The query to create a table is as follows −mysql> create table changeCellsData -> ( -> Id int, -> Name varchar(100), -> Age int -> ); Query OK, 0 rows affected (0.81 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into changeCellsData values(101, 'Mike', 23); Query OK, 1 row affected (0.12 sec) mysql> insert into ...
Read MoreHow to decrement a value in MySQL keeping it above zero?
You can decrement value in MySQL with update command. With this, you can also restrict the value to not reach below 0.The syntax is as follows −update yourTableName set yourColumnName = yourColumnName - 1 where yourColumnName > 0;To avoid the value to go below zero, you can use yourColumnName > 0.To understand the above syntax, let us create a table. The query to create a table.mysql> create table DecrementDemo −> ( −> DecrementValue int −> ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table with insert statement. ...
Read More8085 program to find maximum of two 8 bit numbers
In this program we will see how to find the maximum of two numbers.Problem StatementWrite 8085 Assembly language program to find the maximum number of two 8-bit number stored at location 8000H and 8001H.DiscussionThis checking is done by using the CMP instruction. This instruction is very similar to the SUB instruction. The only difference is that it does not update the value of Accumulator after executing. So after comparing, if the CY flag is set, it means that the first number is smaller, and the second one is largerInputFirst inputAddressData......8000FD800123......second inputAddressData......800059800175......Flow DiagramProgramAddressHEX CodesLabelMnemonicsCommentsF00021, 00, 80LXI H, 8000HPoint to the first ...
Read MoreHow to detect if an iOS application is in background or foreground?
To detect if an iOS application is in background or foreground we can simply use the UIApplication just like we can use it to detect many other things like battery state, status etc.Let’s see how we can do this in our application. We’ll make use of shared resources of our Application which are stored in UIApplication.shared. We can use it like shown below −print(UIApplication.shared.applicationState)The shared.application state is an enum of type State, which consists of the following as per apple documentation.public enum State : Int { case active case inactive case background }The case active means that ...
Read MoreGet the record of a specific year out of timestamp in MySQL?
You can get year out of timestamp using YEAR() function. The syntax is as follows −SELECT yourColumnName FROM yourTableName WHERE YEAR(yourTimestampColumnName)='yourYearValue’';To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table getYearOut -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(10), -> yourTimestamp timestamp default current_timestamp, -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (1.56 sec)Insert some records in the table using INSERT command−mysql> insert into getYearOut(Name, yourTimestamp) values('John', now()); Query OK, 1 row affected (0.26 sec) ...
Read MoreWhat is the difference between story and screenplay in film scripts?
What is a Script All About?Although based on the same incident, both story and screenplay still have disparities. A script is a written text generally created for a film, play, TV serial, etc. Only a script provides a very elaborated explanation of the incidents and characters. A script is created for both movies based on a story. Therefore, we can consider the story as an account of real and imaginary events. A script also gives an opportunity to the actor to comprehend the nature of the character, personality, likes and dislikes. Moreover, as per the demand scriptwriters write their script ...
Read More