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 on Trending Technologies
Technical articles with clear explanations and examples
How to check if data is NULL in MySQL?
You can use IF() to check if data is NULL. Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, Name varchar(200), Age int ); Query OK, 0 rows affected (0.44 sec)Insert records in the table using insert command −mysql> insert into DemoTable(Name, Age) values('John', 23); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(Name, Age) values('Sam', null); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(Name, Age) values('Mike', 23); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable(Name, Age) values('David', 21); Query OK, ...
Read MoreData file mode in 8085 Microprocessor
DATA FILE MODE in8085 MicroprocessorWe can refer to ‘X8085 cross-assembler’ manual for details.The format of Intel Hex: We have shown the MULT.HEX file to give a brief description at a glance.:01 C100 00 04 3A:01 C200 00 05 38:02 C300 00 00 00 3B:10 C000 00 21 00 C1 5E 16 00 21 00 C2 7E 21 00 00FE 00 CA 90:10 C010 00 17 C0 19 3D C2 12 C0 22 F7 FF 22 00C3 CD BC 06 D3:01 C020 00 76 A9:00 0000 01 FFThere are several lines which the file consists of which are termed as records. ...
Read MoreReset_in* and Reset_out pins in 8085
Intel 8085 consists of a RESET_IN* pin which is an active low input pin. We RESET 8085 by placing a logic 0 on this pin at least for 0.5μs, after that the power is supplied to Vcc pin of 8085. Moreover, in practice we place the RESET_IN* in logic 0 state for a few milliseconds. A typical reset circuit which we use in ALS 8085 kit, is shown in the following Fig.The moment when the power supply is switched on, the Vcc pin gets +5V power here the RESET_IN* pin stays in logic 0 state for a time dependency on the ...
Read MoreHow to check cursor array list is empty or not in Android sqlite?
Before getting into example, we should know what sqlite data base in android is. SQLite is an open source SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation. SQLite supports all the relational database features. In order to access this database, you don't need to establish any kind of connections for it like JDBC, ODBC etc.This example demonstrate about How to check cursor array list is empty or not in Android sqlite.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and ...
Read MoreHow to use rotate() for Listview in Android?
This example demonstrate about How to use rotate() for Listview 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 name and record number as Edit text, when user click on save button it will store the data into arraylist. Click on refresh button to ...
Read MoreCan we call functions using Callable Statements? Explain with an example in JDBC?
Like procedures, you can also create function in a database and store them.SyntaxFollowing is the syntax of creating a function in a(MySQL) database:CREATE FUNCTION Function_Name(input_arguments) RETURNS output_parameter BEGIN declare variables; statements . . . . . . . . . . return data_type; ENDExampleSuppose we have a table named Emp in the database with the following content:+--------+------------+----------------+ | Name | DOB | Location | +--------+------------+----------------+ | Amit | 1970-01-08 | Hyderabad | | Sumith | 1970-01-08 | Vishakhapatnam | | Sudha | 1970-01-05 | Vijayawada ...
Read MoreHow to use SUM () in Android sqlite?
Before getting into example, we should know what sqlite data base in android is. SQLite is an open source SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation. SQLite supports all the relational database features. In order to access this database, you don't need to establish any kind of connections for it like JDBC, ODBC etc.This example demonstrate about How to use SUM () in Android sqlite.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to ...
Read MoreC++ Program to Implement Hash Tables with Linear Probing
A hash table is a data structure which is used to store key-value pairs. Hash function is used by hash table to compute an index into an array in which an element will be inserted or searched.Linear probing is a collision resolving technique in Open Addressed Hash tables. In this method, each cell of a hash table stores a single key–value pair. If a collision is occurred by mapping a new key to a cell of the hash table that is already occupied by another key. This method searches the table for the following closest free location and inserts the ...
Read MoreHow to send data to previous activity in Android?
This example demonstrate about How to send data to previous activity 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. Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.app.Activity; import android.content.Intent; import android.content.SharedPreferences; import android.os.Bundle; import android.support.annotation.Nullable; import android.support.v7.app.AppCompatActivity; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.TextView; public class MainActivity extends AppCompatActivity { private final static int MY_REQUEST_CODE = 1; TextView textView; ...
Read MoreHow to get device make and model on iOS?
When we talk about the device make, we refer to the Phone manufacturer (e.g. Apple, Samsung, Nokia and so on) and device model is generally the specific product such as iPhone, iPad/TAB etc.Any mobile devices will be categorized using make and model only.Now let’s understand how do I get device make and model in iOS?There are two ways to get make and model the first way is to directly open your iOS device, navigate to setting, tap on general and in the about section you can find the details of your iOS deviceThe second way is getting make and model ...
Read More