Karthikeya Boyini has Published 2545 Articles

MySQL query to increment one of the column values

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:43:15

1K+ Views

Let us first create a table −mysql> create table DemoTable -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Name varchar(100), -> Score int -> ); Query OK, 0 rows affected (0.78 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Name, Score) values('John', 68); ... Read More

How to use offer() in android PriorityBlockingQueue?

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:42:58

52 Views

Before getting into the example, we should know what PriorityBlockingQueue is. It is an unbounded queue and follows the same order as a priority queue. The main usage of priority blocking queue is, it going to handle out of memory error.This example demonstrates about How to use offer() in android ... Read More

How to use offer() in android ConcurrentLinkedQueue?

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:41:55

58 Views

Before getting into an example, we should know what ConcurrentLinkedQueue is, it is an unbounded queue based on linked nodes. Multiple threads can access queue elements with safety. Elements travel based on queue strategy as FIFO and elements going to insert from a tail. It does not allow null values.This ... Read More

How to use lastIndexOf() in android CopyOnWriteArrayList?

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:40:49

54 Views

Before getting into the example, we should know what CopyOnWriteArrayList is. 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 lastIndexOf() in android CopyOnWriteArrayListStep 1 − Create a new project ... Read More

How to use isEmpty() in android CopyOnWriteArraySet?

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:39:09

67 Views

Before getting into the example, we should know what CopyOnWriteArraySet is. 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 isEmpty() in android CopyOnWriteArraySetStep 1 − Create a new project ... Read More

How to use in android CopyOnWriteArraySet?

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:36:37

92 Views

Before getting into an example, we should know what CopyOnWriteArraySet is. 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 demonstrates about How to use in android CopyOnWriteArraySetStep 1 − Create a new project in ... Read More

Given a column name how can I find which tables in a MySQL database contain that column?

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:34:59

100 Views

Use the COLUMN_NAME to find which table in a database contains a specific column. Let us first create a table −mysql> create table DemoTable    -> (    -> CustomerId int,    -> CustomerName varchar(20),    -> CustomerCountryName varchar(100)    -> ); Query OK, 0 rows affected (1.05 sec)Following is ... Read More

How to order MySQL rows by multiple columns?

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:34:14

196 Views

Let us first create a table −mysql> create table DemoTable    -> (    -> FirstName varchar(20),    -> LastName varchar(20)    -> ); Query OK, 0 rows affected (1.44 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John', 'Smith'); Query OK, 1 row affected ... Read More

How to use containsAll() in android CopyOnWriteArraySet?

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:33:58

89 Views

Before getting into an example, we should know what CopyOnWriteArraySet is. 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 demonstrates about How to use containsAll() in android CopyOnWriteArraySetStep 1 − Create a new project ... Read More

Sort a column ignoring a specific word in MySQL

karthikeya Boyini

karthikeya Boyini

Updated on 30-Jun-2020 14:33:18

121 Views

Let us first create a table −mysql> create table DemoTable    -> (    -> Name text    -> ); Query OK, 0 rows affected (1.31 sec)Insert some records in the table using insert command. Here, we have inserted a name with a specific word “name”, which we need to ... Read More

Advertisements