Add Column in MySQL Before Another Column

Sharon Christine
Updated on 30-Jun-2020 14:05:36

693 Views

No, you can easily add a column before another column using ALTER.Note − To add a column at a specific position within a table row, use FIRST or AFTER col_name Let us first create a table −mysql> create table DemoTable    -> (    -> Id int,    -> Name varchar(20),    -> CountryName varchar(100)    -> ); Query OK, 0 rows affected (0.67 sec)Let us check all the column names from the table −mysql> show columns from DemoTable;OutputThis will produce the following output −+-------------+--------------+------+-----+---------+-------+ | Field       | Type         | Null | Key ... Read More

Use addLast in Android LinkedBlockingDeque

Samual Sam
Updated on 30-Jun-2020 14:04:42

114 Views

Before getting into example, we should know what LinkedBlockingDeque is. It is implemented by Collection interface and the AbstractQueue class. It provides optional boundaries based on linked nodes.It going to pass memory size to constructor and helps to provide memory wastage in android.This example demonstrate about How to use addLast () in android LinkedBlockingDequeStep 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 ... Read More

Use addIfAbsent in Android CopyOnWriteArrayList

karthikeya Boyini
Updated on 30-Jun-2020 14:04:14

130 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 use addIfAbsent () 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 show CopyOnWriteArrayList elements.Step 3 − Add the following code to src/MainActivity.javapackage ... Read More

MySQL XOR Operator with IN Clause

Sharon Christine
Updated on 30-Jun-2020 14:03:58

727 Views

MySQL XOR returns TRUE if one or the other operand (or expression) but not both is TRUE. The IN clause is used to specify a condition with any other MySQL query.Let us first create a tablemysql> create table DemoTable -> ( -> Num1 int, -> Num2 int -> ); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(5, 5); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values(6, 6); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(7, 7); Query OK, ... Read More

Use ORDER BY NULL in MySQL

karthikeya Boyini
Updated on 30-Jun-2020 14:02:38

485 Views

Yes, we can do thatNote − Before MySQL 5.7, ORDER BY NULL was useful, but with MySQL 8.0, specifying ORDER BY NULL, for example, at the end to suppress implicit sorting is no longer necessary.Let us first create a table −mysql> create table DemoTable -> ( -> Name varchar(10) -> ); Query OK, 0 rows affected (1.01 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('John'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Bob'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('David'); Query OK, 1 ... Read More

Sort a Column in Descending Order in MySQL

karthikeya Boyini
Updated on 30-Jun-2020 14:01:35

93 Views

For this, use FIELD() function with DESC. Let us first create a table −mysql> create table DemoTable -> ( -> Number int -> ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values(20); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable values(30); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(40); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(50); Query OK, 1 row ... Read More

Use Add in Android PriorityBlockingQueue

Samual Sam
Updated on 30-Jun-2020 13:59:41

120 Views

Before getting into an example, we should know what PriorityBlockingQueueis. 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 How to use add() in android PriorityBlockingQueueStep 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 a text view to show PriorityBlockingQueue elements.Step 3 ... Read More

Use addAll in Android CopyOnWriteArraySet

karthikeya Boyini
Updated on 30-Jun-2020 13:59:14

122 Views

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 More

Display Records from Two Columns Based on Comparison in MySQL

Sharon Christine
Updated on 30-Jun-2020 13:59:02

513 Views

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 More

Update Element Based on Index in Android CopyOnWriteArrayList

Samual Sam
Updated on 30-Jun-2020 13:58:45

152 Views

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 More

Advertisements