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 by Arjun Thakur
Page 61 of 75
How to count horizontal values on a MySQL database?
You can use aggregate function COUNT() from MySQL to count horizontal values on a database. Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstValue int, SecondValue int, ThirdValue int, FourthValue int ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(FirstValue, SecondValue, ThirdValue, FourthValue) values(-18, 45, 0, 155); Query OK, 1 row affected (0.22 sec) mysql> insert into DemoTable(FirstValue, SecondValue, ThirdValue, FourthValue) values(0, 235, null, 15); Query OK, 1 row affected (0.20 sec)Following is the query to display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following ...
Read MoreHow do you define multiple filters in JSP?
Your web application may define several different filters with a specific purpose. Consider, you define two filters AuthenFilter and LogFilter. Rest of the process will remain as explained above except you need to create a different mapping as mentioned below − LogFilter LogFilter test-param Initialization Paramter AuthenFilter AuthenFilter test-param Initialization Paramter LogFilter /* AuthenFilter /* Filters Application OrderThe order of filter-mapping elements ...
Read MoreDisplay all records except one in MySQL
You can use IN() to display all records except one in MySQL. Let us first create a table −mysql> create table DemoTable ( Id int, FirstName varchar(20) ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 'Larry'); Query OK, 1 row affected (0.31 sec) mysql> insert into DemoTable values(10, 'Chris'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable values(110, 'Robert'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(90, 'David'); Query OK, 1 row affected (0.20 sec)Following is the query ...
Read MoreHow to add +1 to existing MySQL values?
Let us see an example and create a table first.mysql> create table Add1ToExistingValue -> ( -> Value int -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into Add1ToExistingValue values(10); Query OK, 1 row affected (0.12 sec) mysql> insert into Add1ToExistingValue values(13); Query OK, 1 row affected (0.15 sec) mysql> insert into Add1ToExistingValue values(15); Query OK, 1 row affected (0.13 sec) mysql> insert into Add1ToExistingValue values(16); Query OK, 1 row affected (0.14 sec) mysql> insert into Add1ToExistingValue values(20); Query OK, 1 row affected (0.16 sec) mysql> insert into Add1ToExistingValue values(40); Query OK, 1 row affected (0.15 sec) mysql> insert into Add1ToExistingValue values(50); Query OK, 1 row affected (0.11 sec) mysql> insert into Add1ToExistingValue values(55); Query OK, 1 row affected (0.17 sec) mysql> insert into Add1ToExistingValue values(56); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement.The query is as followsmysql> select *from Add1ToExistingValue;The following is the output+-------+ | Value | +-------+ | 10 ...
Read MoreHow to get the maximum value from strings with integers in MySQL?
You can use CAST() with MAX() for this. Since the string is filled with string and integer, fir example, “STU201”, therefore we need to use CAST().Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentBookCode varchar(200) ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(StudentBookCode) values('STU201'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable(StudentBookCode) values('STU202'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable(StudentBookCode) values('STU203'); Query OK, 1 row affected (0.20 sec) mysql> ...
Read More8085 Program to add the contents of N word locations
Now let us see a program of Intel 8085 Microprocessor. In this program we will see how to add the contents of N word locations.Problem Statement:Write 8085 Assembly language program to add N 16-bit numbers stored into memoryDiscussion:The 16-bit numbers are stored into memory location 8001H onwards. The value of N is stored at location 8000H. After addition, the result will be stored at location 8050H onwards.In 8085 we have few number of registers. So we are storing the count into memory, when we need to update it, we will fetch it from memory, update it and then again store ...
Read MoreRunning the entire 8085 program in a single operation
In a single operation, we can run the entire program of 8085. We run the entire program in this mode so that we can get the accurate results. If the process is unsuccessful a single-stepping by the entire program is attempted.We type ‘G’ at the prompt ‘>’. By noticing the absence of change of address after G. The prompting of the system are as follows:The address of starting is: xxxx - yy/where the memory address is xxxx and the content of the memory location is yy. Which allows the user for responding with the desired address of starting. If ...
Read MoreHow to check android mobile supports dynamic sensor?
This example demonstrate about How to check android mobile supports dynamic sensorStep 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 dynamic sensor information.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.annotation.SuppressLint; import android.app.KeyguardManager; import android.app.usage.UsageEvents; import android.content.Context; import android.hardware.SensorManager; import android.hardware.fingerprint.FingerprintManager; import android.os.Build; import android.os.Bundle; import android.security.keystore.KeyGenParameterSpec; import android.security.keystore.KeyProperties; import android.support.annotation.RequiresApi; import android.support.v4.view.MotionEventCompat; import android.support.v7.app.AppCompatActivity; import ...
Read MoreHow do I put a border around an Android textview?
If you wants to see text view as 3D view as we seen in Microsoft power point 3d texts. This example demonstrate about how do I put a border around an Android text view.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 one text view with background as border so we need to create a file in drawable as boarder.xml and add the following content. ...
Read MoreRST5.5 and RST6.5 pins in 8085
Both the pins RST5.5 and RST6.5 pins are inputs which are level sensitive. RST6.5 is of higher priority than RST5.5 but the pin RST5.5 is of higher priority than INTR. RST5.5 and RST6.5 have similar functions. The point to be noted that these pins must remain high till the 8085 checks all the internal interrupt signals at the end of the instructions. As we can easily see from the Fig. We activate the RST5.5 and RST6.5 internal interrupt signals if and only if when the external interrupt pins are in logic 1 state;Flip-flop IE is in logic 1 state;SIM instructions ...
Read More