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 to use addAll() in android CopyOnWriteArraySet?
Before getting into example, we should know what CopyOnWriteArraySetis. It is a thread-safe variant of ArrayList and operations add, set, and so on by making a fresh copy of the underlying array.This example demonstrate about How to use addAll() in android CopyOnWriteArraySetStep 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 to show CopyOnWriteArraySet elements.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; ...
Read MoreDisplay records from two columns based on comparison in MySQL?
Let us first create a table −mysql> create table DemoTable -> ( -> Num1 int, -> Num2 int -> ); Query OK, 0 rows affected (0.54 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 200); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(200, 100); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(300, 400); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(400, 300); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values(500, 600); Query OK, 1 ...
Read MoreHow to update element based on index in android CopyOnWriteArrayList?
Before getting into example, we should know what CopyOnWriteArrayListis. It is a thread-safe variant of ArrayListand operations add, set, and so on by making a fresh copy of the underlying array.This example demonstrate about How to update element based on index in android CopyOnWriteArrayListStep 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 to showCopyOnWriteArrayListelements.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; ...
Read MoreHow to search an element in android ArrayBlockingQueue?
Before getting into example, we should know what arrayblockingqueue is, it travels FIFO manner and first element going to live longest period of time and last element of the queue going to live short period of the time.This example demonstrate about How to search an element in android ArrayBlockingQueueStep 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 to showArrayBlockingQueue elements.Step 3 − Add ...
Read MoreCount only null values in two different columns and display in one MySQL select statement?
Use IS NULL to test for NULL value. Let us first create a table −mysql> create table DemoTable -> ( -> Number1 int, -> Number2 int -> ); Query OK, 0 rows affected (0.62 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(1, NULL); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values(NULL, NULL); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(3, NULL); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(NULL, 90); Query OK, 1 row affected ...
Read MoreHow to remove element from ArrayBlockingQueue in android?
Before getting into example, we should know what arrayblockingqueue is, it travels FIFO manner and first element going to live longest period of time and last element of the queue going to live short period of the time.This example demonstrate about How to remove element from ArrayBlockingQueue in androidStep 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 to showArrayBlockingQueue elements.Step 3 − ...
Read MoreHow to get last element in android ConcurrentLinkedDeque?
Before getting into example, we should know what ConcurrentLinkedDequeis, it is unbounded deque based on linked nodes. Multiple threads can access deque elements with safety.This example demonstrate about How to get last element in android ConcurrentLinkedDequeStep 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 to showConcurrentLinkedDequeelements.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import ...
Read MoreMySQL query to remove special characters from column values?
Let us first create a table −mysql> create table DemoTable -> ( -> StudentId varchar(100) -> ); Query OK, 0 rows affected (0.53 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('STU#123'); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values('STU#567'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('STU#98494'); Query OK, 1 row affected (0.19 sec)Display all records from the table using select statement −mysql> select *from DemoTable;OutputThis will produce the following output −+-----------+ | StudentId | +-----------+ | STU#123 | | STU#567 ...
Read MoreHow to get head element from ArrayBlockingQueue in android?
Before getting into example, we should know what arrayblockingqueue is, it travels FIFO manner and first element going to live longest period of time and last element of the queue going to live short period of the time.This example demonstrate about How to get head element from ArrayBlockingQueue in androidStep 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 to showArrayBlockingQueue elements.Step 3 ...
Read MoreChange multiple columns in a single MySQL query?
For this, use UPDATE and REPLACE() in MySQL. Let us first create a table −mysql> create table DemoTable -> ( -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentName varchar(100), -> StudentCountryName varchar(100) -> ); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(StudentName, StudentCountryName) values('John', 'US'); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql select *from DemoTable;OutputThis will produce the following output −+-----------+-------------+--------------------+ | StudentId | StudentName | StudentCountryName | +-----------+-------------+--------------------+ | ...
Read More