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 62 of 75
How to SELECT all values from a table only once if they're duplicated?
You can use distinct keyword to select all values from a table only once if they are repeated.The syntax is as followsselect distinct yourColumnName from yourTableName;To understand the above syntax, let us create a table. The query to create a table is as follows.mysql> create table displayOnlyDistinctValue -> ( -> UserId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> UserName varchar(100), -> UserAge int -> ); Query OK, 0 rows affected (0.47 sec)Insert some records in the table using insert command.The query is as follows.mysql> insert into displayOnlyDistinctValue(UserName, UserAge) values('Larry', 23); Query OK, 1 row affected ...
Read MoreMultiple memory address range in 8085 Microprocessor
Suppose we have the chip select circuit as shown in the below figure, then what is the address range for the RAM?Fig. Chip selection that results in multiple address range.A15 and A14 pins are used for the selection of Random Access Memory, and pins ranging from A10 to A0 are used for the selection of location in RAM. But the value of the pins A13, A12 and A11 have non-dependent value. They play no role for selection of chip or location on RANDOM ACCESS MEMORY. Hence they are termed as don't cares and called x for more signification.We have eight ...
Read MoreNeed for masking in 8085
Let us say that the 8085 which is interrupted because of RST6.5 pin and has been branched to the ISS for the pin RST6.5. Then, except the DI instruction at the beginning of this ISS, all the interrupts gets disabled except TRAP. So, even if RST7.5 pin is in activated state in the middle of the execution of RST6.5 ISS, the interruption of 8085 will not occur due to RST7.5. Actually a higher priority interrupt is RST7.5, but the lower priority interrupt ISS cannot be interrupted by it of RST6.5. We solve this problem by specifically having the instruction which ...
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 MoreHow to set all values in a single column MySQL Query?
To set all values in a single column MySQL query, you can use UPDATE command.The syntax is as follows.update yourTableName set yourColumnName =yourValue;To understand the above syntax, let us create a table. The query to create a table is as follows.mysql> create table setAllValuesDemo -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Name varchar(20), -> Amount int -> ); Query OK, 0 rows affected (0.64 sec)Now you can insert some records in the table using insert command.The query is as follows.mysql> insert into setAllValuesDemo(Name, Amount) values('John', 2345); Query OK, 1 row affected ...
Read MoreHow to check android mobile supports STEP COUNTER sensor?
This example demonstrate about How to check android mobile supports STEP COUNTER 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 a text view to show STEP COUNTER sensor information.Step 3 − Add the following code to src/MainActivity.javapackage com.example.myapplication; import android.annotation.SuppressLint; import android.content.Context; import android.hardware.Sensor; import android.hardware.SensorManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.widget.TextView; public class MainActivity extends AppCompatActivity { ...
Read MoreInterfacing 7(Seven) Segment Display to 8085 Microprocessor
An output device which is very common is, especially in the kit of 8085 microprocessor and it is the Light Emitting Diode consisting of seven segments. Moreover, we have eight segments in a LED display consisting of 7 segments which includes ‘.’, consisting of character 8 and having a decimal point just next to it. We denote the segments as ‘a, b, c, d, e, f, g, and dp’ where dp signifies ‘.’ which is the decimal point. Moreover, these are LEDs or together a series of Light Emitting Diodes. We have shown the internal circuit comprising of a display ...
Read MoreMySQL: Testing connection with query?
Use any predefined function with select query or you can print some words with the select query in order to test connection with query.The syntax is as follows.SELECT yourValue;The select query with predefined function is as follows.The syntax is as follows.SELECT anyPredefinedFunctionName();Now you can implement the above syntax in order to test connection with query.Case 1 -The query is as follows.mysql> select "This is MySQL" as Display;The following is the output.+---------------+ | Display | +---------------+ | This is MySQL | +---------------+ 1 row in set (0.00 sec)Case 2 -The query is as follows.mysql> select ...
Read MoreI/O Write (IOW) machine cycle in 8085 Microprocessor
The last three clock cycles in the OUT 25H instruction is an example for IOW machine cycle. Waveforms for IOW machine cycle are shown in the figure below: The point to be noted that in an IOW machine cycle, Wand Z registers have identical 8-bit port address. There is also a definite advantage because of address duplication on the addresses ranging from A15-8 and AD7-0 when we are using 8755 (2K × 8 EPROM and two 8-bit ports) and 8155 which is a combination of 256 × 8 RAM, 3 Input Output ports, and 14-bit timer. We can form a 8085-based ...
Read MoreHow to select most recent date out of a set of several possible timestamps in MySQL?
You can select most recent date out of a set of several possible timestamps with the help of ORDER BY clause.The syntax is as followsSELECT yourColumnName1, yourColumnName2, ...N FROM yourTableName ORDER BY yourTimestampColumnName DESC LIMIT 1;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table MostRecentDateDemo - > ( - > Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, - > Name varchar(10), - > ShippingDate timestamp - > ); Query OK, 0 rows affected (0.65 sec)Insert some records in the table using insert command. ...
Read More