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 Trade your cryptocurrency?
When you talk about trading of Cryptocurrency, the following transactions will come under that category.Buying new cryptocurrency using your fiat currencySelling your cryptocurrency for fiat currencyExchanging one type of cryptocurrency for another digital currencyTo make these transactions, there are Cryptocurrency Exchanges.If you just want to make the occasional, straightforward trade, there are also platforms that you can use that do not require an account.Cryptocurrency ExchangeThese are the websites which allow you to buy, sell or exchange the digital currency. All you have to do is to choose an exchange, create an account and get your id verified, and you are ...
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 Morea 8085 Program to perform bubble sort based on choice
Now let us see a program of Intel 8085 Microprocessor. In this program we will see how to perform bubble sort in based on choice.Problem Statement:Write 8085 Assembly language program to perform bubble sorting operation on a set of data, and arrange them into ascending or descending order based on choice.Discussion:In this program we are arranging some numbers into ascending or descending order based on some choice. We are storing the choice at location A000H. If the choice value is 00H, then data will be sorted in ascending order, otherwise it will be sorted in descending order. The 8000H is ...
Read MoreWhat are copy elision and return value optimization in C++?
The Copy Elision is also known as the Copy Omission. This is one of the compiler optimization technique. It avoids the unnecessary copying of objects. Almost any current compiler uses this Copy Elision technique.Let us see how it works by the help of one example code.Example Code#include using namespace std; class MyClass { public: MyClass(const char* str = "\0") { //default constructor cout
Read MoreHow to sort Listview in Android?
This example demonstrate about How to sort Listview in Android using collections.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 MoreHow to implement click event on toolbar icon?
This example demonstrates How to implement click event on toolbar icon.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 text view to action bar icon status.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.annotation.SuppressLint; import android.app.ActivityManager; import android.app.admin.DevicePolicyManager; import android.content.ComponentName; import android.content.Context; import android.content.Intent; import android.net.wifi.WifiInfo; import android.net.wifi.WifiManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.view.MenuItem; import android.view.View; ...
Read MoreHow to SELECT min and max value from the part of a table in MySQL?
To select min and max value from the part of a table in MySQL, use the following syntax −select min(yourColumnName) as yourAliasName1, max(yourColumnName) as yourAliasName2 from (select yourColumnName from yourTableName limit yourLimitValue) tbl1;Let us first create a table. Following is the query −mysql> create table MinAndMaxValueDemo -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Value int -> ); Query OK, 0 rows affected (0.52 sec)Insert records in the table using insert command. Following is the query −mysql> insert into MinAndMaxValueDemo(Value) values(10); Query OK, 1 row affected (0.16 sec) mysql> insert into MinAndMaxValueDemo(Value) ...
Read MoreWhat happens to Bitcoin after all the 21 Million Coins are mined?
Bitcoins are created by Satoshi Nakamoto, in 2008 whose identity is still a mystery, whether it is one person or a group of persons. Satoshi Nakamoto proposed Bitcoin as a means of exchange, independent and secure and also a limited number.Now the question comes, Why limited supply?The most important feature of Bitcoin is that it is decentralized. No Central authority will keep a check on its demand or supply. Satoshi has created an open source code which is maintained by a group of volunteer programmers and runs as a distributed network with nodes spread across the world. We know that ...
Read MoreHow to convert date YYYYMMDD to YY-MM-DD in MySQL query?
To convert date YYYYMMDD to YY-MM-DD in MySQL, use the below syntax −select date_format(str_to_date(yourColumnName, '%Y%m%d'), '%Y-%m-%d') from yourTableName;Let us first create a table −mysql> create table DemoTable ( ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientProjectDeadline varchar(200) ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command. We have inserted dates in the YYYYMMDD format −mysql> insert into DemoTable(ClientProjectDeadline) values('20121221'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable(ClientProjectDeadline) values('20190416'); Query OK, 1 row affected (0.53 sec) mysql> insert into DemoTable(ClientProjectDeadline) values('20160624'); Query OK, 1 row affected (0.20 sec) mysql> ...
Read MoreCan you now ask Amazon Alexa to make playlists for you?
Now you can command "Alexa, Create a new playlist " or "Alexa, add this to my playlist" and Alexa will obey your orders.Here is the know how ...You need Amazon music, as Alexa recognizes only Amazon music.Say "Alexa, create a new playlist" and Alexa will ask you to give the name of the playlist. Name the list. Now your playlist is created and ready.Now you have to add the required songs to the playlists with commands "Alexa, add this song to the playlist".You can even edit a playlist by taking the name of an already existing playlist.As of now deleting a ...
Read More