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
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to get the Average on MySQL time column?
To get average on time column, use the below syntax. It will give the average in time format −SELECT SEC_TO_TIME(AVG(TIME_TO_SEC(yourColumnName))) as anyVariableName from yourTableName;To understand the above concept, let us create a table. The following is the query −mysql> create table AverageOnTime −> ( −> PunchInTime time −> ); Query OK, 0 rows affected (0.61 sec)Insert time values in the table using insert command. The query to insert records is as follows −mysql> insert into AverageOnTime values('00:00:40'); Query OK, 1 row affected (0.20 sec) mysql> insert into AverageOnTime values('00:02:50'); Query OK, 1 row affected (0.15 sec) ...
Read MoreHow to set Adapter to Auto Complete Text view?
Before getting into an example, we should know what is autocomplete textview in android. Autocomplete textview is just like an edit text and it is a subclass of editext, but it is going to show suggestion from a list as a dropdown list. We have to set up Threshold value to auto-complete text view. for example, we have set it up Threshold as 1 so if user enters one letter is going to give suggestion according to Threshold letter.This example demonstrates about how to set up an adapter to auto-complete Textview.Step 1 − Create a new project in Android Studio, ...
Read MoreHow to prevent going back to the previous activity in Android?
There are so many situations, where we should not call back action when user click on back button.This example demonstrates how to integrate Android Login and register form.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/actvity_main.xml. Step 3 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.widget.Toast; public class MainActivity extends AppCompatActivity { int view = R.layout.activity_main; @RequiresApi(api = ...
Read MoreProgrammer's view of Z-80
In this section we will see the basic architecture of the Z-80 Microprocessor, and different registers to write programs into it.To write programs we have to care about the registers and some instructions to access them during program execution.From this diagram it is clear that there are some special purpose registers like W, Z, some other registers like Stack Pointer (SP), Program Counter (PC) etc. three general purpose register pairs (BC, DE, HL) and Accumulator A. There is also an 8-bit flag register to hold the flag bits. Up to this, it is like the 8085 architecture, but in Z-80, ...
Read MoreHow to reload activity in Android?
In some situations, we need to recall activity again from onCreate(). This example demonstrates how to reload activity in Android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. In the above code, We have taken text view, when a user clicks on text view, it will call Main Activity again.Step 3 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.content.Intent; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.view.View; import ...
Read MoreHow faster is the time when we think of something and Google will show results?
When I googled the question "time taken for Google to show the results", I got 19,40,00,000 results in 0.47 seconds.This again varies with the speed of your system's processor and the speed of your internet connection.This wonderful, super fast search engine is 50,000 times faster than the time our brain takes to interpret an image and about 6 million times faster than the time it takes for an average human brain to react to an external stimulus.
Read MoreWhich out of Ph.D. or qualifying NET exam is better for students pursuing Master’s degree in Literature?
First of all, it must be borne in mind that whatever step one takes in life-related to a course or degree, should be taken keeping in mind what does one need to achieve next or pursue next having this degree in hand. The same goes for all streams of education in India currently. Having said that, if I were to answer which out of Ph. D or NET exam in better to go with for Students pursuing masters in English Literature, again it varies from person to person.When to Choose Ph.D. over NETIf you are a sort of person who ...
Read MoreHow to remove onClickListener for a view in android?
In some situations, We should not allow onClickListener for a view. This example demonstrates how to remove onClickListener for a view in android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/acitivity_main.xml. In the above code, we have taken a text view, In this example, we should remove onClickListner for this text view.Step 3 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.content.res.Configuration; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import ...
Read MoreWhat is Vernier Calipers and How it is used for Measurement?
Measuring things and distances is one of the important concepts to learn when we are studying maths. For maximum uses, measuring scales do the work quite well and everyone is aware of it how to use one. But the measuring scale only provides a specific level of correctness and once you need exact measurements which lie between two spots on the scale it becomes difficult to get a correct reading without a bit of counterpart.Also measuring scales are very vulnerable to parallax mistakes which can cause a huge portion of the difference in readings from person to person which is ...
Read MoreDecrease a row value by 1 in MySQL?
You can increase and decrease row value by 1 in MySQL using UPDATE command. The syntax is as follows −UPDATE yourTableName set yourColumnName = yourColumnName-1 where condition;Let us create a table to decrease row value by 1. The following is the query −mysql> create table IncrementAndDecrementValue −> ( −> UserId int, −> UserScores int −> ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into IncrementAndDecrementValue values(101, 20000); Query OK, 1 row affected (0.13 sec) mysql> insert into IncrementAndDecrementValue values(102, 30000); ...
Read More