Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To SELECT from table A that does not exist in table B, you can use left join. Following is the syntax −select yourTableNameA.* from yourTableNameA left join yourTableNameB on yourTableNameA.yourColumnName = yourTableNameB.yourColumnName where yourTableNameB.yourColumnName IS NULL;Let us first create a table. Following is the query −mysql> create table table_A -> ( -> Value int -> ); Query OK, 0 rows affected (1.10 sec)Following is the query to insert records in the table using insert command −mysql> insert into table_A values(10); Query OK, 1 row affected (0.32 sec) mysql> insert into table_A values(15); Query OK, 1 row ... Read More
At first, we have set the mathematical expressions:String one = "10+15*20-5/5"; String two = "3+5-6"; String three = "9+2*(6-3+7)";To parse mathematical expression, use Nashorn JavaScript in Java i.e. scripting. Nashorn invoke dynamics feature, introduced in Java 7 to improve performance.For scripting, use the ScriptEngineManager class for the engine:ScriptEngineManager scriptEngineManager = new ScriptEngineManager(); ScriptEngine scriptEngine = scriptEngineManager.getEngineByName("Nashorn");Now for JavaScript code from string, use eval i.e. execute the script. Here, we are parsing mathematical expressions set above:Object expResult1 = scriptEngine.eval(one); Object expResult2 = scriptEngine.eval(two); Object expResult3 = scriptEngine.eval(three);Exampleimport javax.script.ScriptEngine; import javax.script.ScriptEngineManager; public class Demo { public static void main(String[] args) throws ... Read More
To turn ON the general log, you need to use SET command. Following is the syntax −set global general_log=ON;Let us check the general log status with the help of SHOW command −mysql> SHOW variables like '%general_log%';This will produce the following output −+------------------+---------------------+ | Variable_name | Value | +------------------+---------------------+ | general_log | OFF | | general_log_file | DESKTOP-QN2RB3H.log | +------------------+---------------------+ 2 rows in set ... Read More
The equality of two buffers can be checked using the method equals() in the class java.nio.IntBuffer. Two buffers are equal if they have the same type of elements, the same number of elements and same sequence of elements. The method equals() returns true if the buffers are equal and false otherwise.A program that demonstrates this is given as follows −Example Live Demoimport java.nio.*; import java.util.*; public class Demo { public static void main(String[] args) { int n = 5; try { IntBuffer buffer1 = IntBuffer.allocate(n); buffer1.put(8); ... Read More
In this program we will see how to transfer a block from one location to another location.Problem StatementWrite 8086 Assembly language program to transfer a block from one memory section to another memory section. The numbers are stored at memory offset 501 onwards. The block size is stored at memory offset 500.DiscussionHere we are initially setting up the source index register with the source of data blocks, then set the destination index register to store into another block. Then set the Data segment register and Extra Segment register to 0000H. By using MOVSB instruction, the entire block is transferred from ... Read More
This example demonstrates How to make a txt file and read txt file from internal storage 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 editext and button. When user click on button, it will take data from edittext and store in internal storage as /data/data//files/text/sample.txt. It going to append the data to textview from sample.txtStep 3 − Add the ... Read More
A custom tag is a user-defined JSP language element. When a JSP page containing a custom tag is translated into a servlet, the tag is converted to operations on an object called a tag handler. The Web container then invokes those operations when the JSP page's servlet is executed.JSP tag extensions let you create new tags that you can insert directly into a JavaServer Page. The JSP 2.0 specification introduced the Simple Tag Handlers for writing these custom tags.To write a custom tag, you can simply extend the SimpleTagSupport class and override the doTag() method, where you can place your ... Read More
The fn:endsWith() function determines if an input string ends with a specified suffix.SyntaxThe fn:endsWith() function has the following syntax −boolean endsWith(java.lang.String, java.lang.String)ExampleFollowing example explains the functionality of the fn:substring function − Using JSTL Functions String ends with 123 String ends with TEST You will receive the following result −String ends with 123
To check whether the list is empty or not, use the isEmpty() method. TRUE is returned if the list is empty, else FALSE is the return value.The syntax is as followsboolean isEmpty()To work with CopyOnWriteArrayList class, you need to import the following packageimport java.util.concurrent.CopyOnWriteArrayList;The following is an example to implement CopyOnWriteArrayList class isEmpty() method in JavaExample Live Demoimport java.util.concurrent.CopyOnWriteArrayList; public class Demo { public static void main(String[] args) { CopyOnWriteArrayList arrList = new CopyOnWriteArrayList(); arrList.add(30); arrList.add(40); arrList.add(60); arrList.add(70); arrList.add(90); ... Read More
An immutable copy of a duration where the required duration is added to it can be obtained using the plus() method in the Duration class in Java. This method requires two parameters i.e. the duration to be added and the TemporalUnit of the duration. Also, it returns the duration with the required duration added to it.A program that demonstrates this is given as follows −Example Live Demoimport java.time.Duration; import java.time.temporal.*; public class Demo { public static void main(String[] args) { Duration d = Duration.ofHours(10); System.out.println("The duration is: " + d); System.out.println("Duration ... Read More