Get Element Based on Index in Android CopyOnWriteArrayList

Samual Sam
Updated on 30-Jun-2020 13:19:16

467 Views

Before getting into example, we should know what CopyOnWriteArrayListis. 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 get 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 ... Read More

Find Size of ArrayBlockingQueue in Android

karthikeya Boyini
Updated on 30-Jun-2020 13:18:42

114 Views

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 find size of 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 More

Select Return Value from MySQL Prepared Statement

Rama Giri
Updated on 30-Jun-2020 13:17:20

902 Views

Let us create a stored procedure and select return value from MySQL prepared statement −mysql> DELIMITER // mysql> CREATE PROCEDURE return_value()    -> BEGIN    ->   SET @returnQuery= 'SELECT 98 INTO @value';    ->   PREPARE stmt FROM @returnQuery;    ->   EXECUTE stmt;    -> END    -> // Query OK, 0 rows affected (0.20 sec) mysql> DELIMITER ;Call stored procedure using CALL command.mysql> call return_value(); Query OK, 1 row affected (0.07 sec)Display value using select statement −mysql> select @value;outputThis will produce the following output −+--------+ | @value | +--------+ |     98 | +--------+ 1 row in set (0.00 sec)

Count Repeated Values in a Column with MySQL

Kumar Varma
Updated on 30-Jun-2020 13:16:31

1K+ Views

Yes, you can use ORDER BY DESC with GROUP BY. Let us first create a table −mysql> create table DemoTable    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> PostMessage varchar(100)    -> ); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(PostMessage) values('Hi'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable(PostMessage) values('Hello'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable(PostMessage) values('Hi'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(PostMessage) values('Awesome'); Query OK, ... Read More

Count Number of NULLs in a Row with MySQL

Rama Giri
Updated on 30-Jun-2020 13:15:04

690 Views

Use ISNULL() from MySQL. Let us first create a table −mysql> create table DemoTable    -> (    -> Number1 int,    -> Number2 int    -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(10, NULL); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable values(NULL, NULL); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values(29, 98); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(NULL, 119); Query OK, 1 row affected (0.15 sec)Display all records ... Read More

What is Auto Increment in a Create Table Query in MySQL

Arjun Thakur
Updated on 30-Jun-2020 13:13:09

834 Views

The AUTO_INCREMENT=5 in a create table query tells that the first record will start from 5 i.e. not default 1. As we know if you do not set the value to AUTO_INCREMENT then MySQL starts from 1 by default.The syntax is as follows:CREATE TABLE yourTableName ( yourColumnName1 dataType NOT NULL AUTO_INCRMENT, . . . N, PRIMARY KEY(yourColumnName1 ) )AUTO_INCREMENT=5;To understand the above syntax, let us create a table.Case1 − The table starts auto increment from 1 because it is the default standard.The query to create a table is as follows:mysql> create table defaultAutoIncrementDemo    -> (    -> Id int ... Read More

Use IF Clause in MySQL to Display Students' Result as Pass or Fail

Kumar Varma
Updated on 30-Jun-2020 13:13:00

1K+ Views

Let us first create a table −mysql> create table DemoTable    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> Name varchar(100),    -> Subject varchar(100),    -> Score int    -> ); Query OK, 0 rows affected (0.94 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(Name, Subject, Score) values('Chris', 'MySQL', 80); Query OK, 1 row affected (0.32 sec) mysql> insert into DemoTable(Name, Subject, Score) values('Robert', 'MongoDB', 45); Query OK, 1 row affected (0.62 sec) mysql> insert into DemoTable(Name, Subject, Score) values('Adam', 'Java', 78); Query OK, 1 row affected ... Read More

Display Records Ignoring NULL in MySQL

Rama Giri
Updated on 30-Jun-2020 13:11:10

166 Views

Use IS NOT NULL to display only NOT NULL records. Let us first create a table −mysql> create table DemoTable    -> (    -> FirstName varchar(100)    -> ); Query OK, 0 rows affected (3.01 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John'); Query OK, 1 row affected (0.44 sec) mysql> insert into DemoTable values(NULL); Query OK, 1 row affected (0.58 sec) mysql> insert into DemoTable values('Chris'); Query OK, 1 row affected (0.31 sec) mysql> insert into DemoTable values(NULL); Query OK, 1 row affected (0.20 sec) mysql> insert into ... Read More

Log In as a Different User on MySQL

George John
Updated on 30-Jun-2020 13:10:49

18K+ Views

If you want to login as a different user on MySQL, you need to use “mysql -u -p command”. The syntax is as follows to login as a different user.>mysql -u yourUsername -p After pressing enter key Enter password −To understand the above syntax, let us create a user in MySQL. The syntax is as follows −CREATE USER 'yourUserName'@'localhost' IDENTIFIED BY 'yourPassword';Now I am going to create a user with name ‘John’ and password is ‘john123456’. The query is as follows −mysql> CREATE USER 'John'@'localhost' IDENTIFIED BY 'john123456'; Query OK, 0 rows affected (0.15 sec)Now check the user has been ... Read More

Select Topmost Record from a Table Ordered by ID Desc

Kumar Varma
Updated on 30-Jun-2020 13:10:20

105 Views

For this, use ORDER BY DESC with LIMIT 1. Let us first create table −mysql> create table DemoTable    -> (    -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> UserName varchar(100),    -> UserMessage text    -> ); Query OK, 0 rows affected (1.17 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(UserName, UserMessage) values('Adam', 'Hi'); Query OK, 1 row affected (0.92 sec) mysql> insert into DemoTable(UserName, UserMessage) values('Chris', 'Awesome'); Query OK, 1 row affected (0.52 sec) mysql> insert into DemoTable(UserName, UserMessage) values('Robert', 'Nice'); Query OK, 1 row affected (0.65 sec) ... Read More

Advertisements