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 find strings with a given prefix in MySQL?
You can use LIKE operator to find strings with a given prefix.The syntax is as followsselect *from yourTableName where yourColumnName LIKE 'yourPrefixValue%';To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table findStringWithGivenPrefixDemo -> ( -> UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> UserMessage text -> ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into findStringWithGivenPrefixDemo(UserMessage) values('Hi Good Morning !!!'); Query OK, 1 row affected (0.17 sec) mysql> insert into findStringWithGivenPrefixDemo(UserMessage) values('Hey ...
Read MoreHow to make a background 20% transparent on Android
If you want to give transparent background for your view, This example demonstrate about How to make a background 20% transparent on Android.All hex value from 100% to 0% alpha100% — FF99% — FC98% — FA97% — F796% — F595% — F294% — F093% — ED92% — EB91% — E890% — E689% — E388% — E087% — DE86% — DB85% — D984% — D683% — D482% — D181% — CF80% — CC79% — C978% — C777% — C476% — C275% — BF74% — BD73% — BA72% — B871% — B570% — B369% — B068% — AD67% — AB66% — A865% ...
Read MoreWhat are Blocks in a Block Chain?
Bitcoins or any other cryptocurrency for that matter, trade at different values. These values are based on supply and demand and most importantly on speculation. The Block chain is the chain of block that stores the information of the transactions of a Bitcoin. Satoshi Nakamoto created the first block in 2009, which is called the Genesis Block.Block Chain is a distributed ledger which stores the data in Hash values. Every digital currency has its own block chain that keeps a record of all transactions ever done using that currency.Peer to Peer Network or P2P Network allows everyone to have a ...
Read MoreUse of 74138 in ALS-SDA-85M kit
In the ALS-SDA-85M kit, we have 74138 EPROM of minimum size 16K x 8 and size of RAM IS 2K x 8, there are empty sockets for the EPROM to get expanded. The selection of these four chips is done by the integrated circuit 74138. Every time the selection of 74138 is done when IO/M* turns to 0, the election of 27138 is done when A15A14 turns to 0. 27138 have the lowest address range likeLowest address: 00 00000000000000 is 0000H.Highest address: 00 11111111111111 is 3FFFH.Whereas in 74138 the address ranges are as follows -Lowest address: 11 xxx 00000000000Highest Address: 11 xxx 11111111111.The ...
Read MoreHow to get current location provider information in android?
This example demonstrate about How to get current location provider information 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 a text view to show the current network location provider.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.Manifest; import android.content.pm.PackageManager; import android.location.Address; import android.location.Geocoder; import android.location.Location; import android.location.LocationManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v4.app.ActivityCompat; import android.support.v7.app.AppCompatActivity; import android.widget.TextView; ...
Read MoreHow to use pollFirst() in android ConcurrentLinkedDeque?
Before getting into an example, we should know what ConcurrentLinkedDeque is, it is unbounded deque based on linked nodes. Multiple threads can access deque elements with safety.This example demonstrates about How to use pollFirst() in android ConcurrentLinkedDequeStep 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 ConcurrentLinkedDeque elements.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.os.Build; import android.os.Bundle; ...
Read MoreWhat are Hash Functions in block chain?
We know that bitcoins enter into the digital market only through mining. It is a cryptocurrency created as a peer-to-peer currency which can be traded without using any Bank or Payment gateway. When these transactions are made, they are accounted for using a publicly distributed ledger which keeps a record of all the transactions made to every Bitcoin.Every time a transaction is made, a new block is created. Every new block will be verified and added into the block chain by the miners. Here comes the purpose of hash functions to make the block chain secure.What is a Hash?Hash is ...
Read MoreCompile 32-bit program on 64-bit gcc in C and C++
Nowadays the compiler comes with default 64-bit version. Sometimes we need to compile and execute a code into some 32bit system. In that time, we have to use thisS feature.At first, we Shave to check the current target version of the gcc compiler. To check this, we have to type this command.gcc –v Using built-in specs. COLLECT_GCC=gcc COLLECT_LTO_WRAPPER=/usr/lib/gcc/x86_64-linux-gnu/7/lto-wrapper OFFLOAD_TARGET_NAMES=nvptx-none OFFLOAD_TARGET_DEFAULT=1 Target: x86_64-linux-gnu ........... ........... ...........Here it is showing that Target is x86_64. So we are using the 64-bit version of gcc. Now to use the 32-bit system, we have to write the following command.gcc –m32 program_name.cSometimes this command may generate ...
Read MoreControl port of 8255
In 8255, there are two types of command words or control word are available. And they are −Mode definition control word andPort C bit set/reset control word.Both these are written to the control port only. From the point of view of the microprocessor there is a single 8-bit control port, which is selected when CS* = 0, WR* = 0, A1 = 1 and A0 = 1. But if we consider the architecture of 8255, internally there are two control ports, one for mode definition control and another for Port C bit set/reset control. The contents of the control port ...
Read MoreHow to get duplicate records from 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 get duplicate records from Android sqliteStep 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to ...
Read More