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
How 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 MoreHow to use Swift to detect when AVPlayer video ends playing?
To detect the end of a video in swift we’ll need to create a video player, then use notifications to detect when the video stops playing. We’ll do this with help of an example in swift.Let’s create a project and drag and drop any video with extension “mp4”, select copy resource if required and add to the target of our project.Now we’ll programmatically first create a Video Player, then we’ll create url of the video in our project, and then we’ll play the video.var videoPlayer: AVPlayer!Now, in the viewDidAppear add the following code.override func viewDidAppear(_ animated: Bool) { super.viewDidAppear(animated) ...
Read More