Ankith Reddy has Published 996 Articles

What do column flags mean in MySQL Workbench?

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 12:38:03

5K+ Views

In MySQL Workbench, column flags can be used with a column to maintain integrity. The column flags are as follows −PK − Primary KeyNN − NOT NULLBIN − BinaryUN − UnsignedUQ − UniqueZF − Zero FilledG − Generate ColumnAI − Auto IncrementLet us learn about them one by one −PKThis ... Read More

Fastest way to count number of rows in MySQL table?

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 12:23:37

1K+ Views

Let us first see an example to create a table, add records and display them. The CREATE command is used to create a table.mysql> CREATE table RowCountDemo -> ( -> ID int, -> Name varchar(100) > ); Query OK, 0 rows affected (0.95 sec)Records are inserted with the INSERT command.mysql>INSERT ... Read More

8085 Program to Add N numbers, of size 8 bits

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 12:10:37

7K+ Views

In this program, we will see how to add a block of data using the 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to add N 1-byte numbers. The value of N is provided.DiscussionIn this problem, we are using location 8000H to hold the length of the block. The main block ... Read More

Register codes of 8085 Microprocessor

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 11:57:12

2K+ Views

Using 16-bit address, 8085 can access one of the 216= 64K locations. As a single hexadecimal digit can be expressed in4-bit notation so, in 8085, memory address can be expressed using four hexadecimal digits. Similarly, for convenience, we can represent all 8085 CPU registers as A, B, C etc. using ... Read More

Interrupt mask register in 8259

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 10:58:17

1K+ Views

It stores the levels of interrupts to be masked by means of storing the bits of the interrupt level already masked. It differs from other registers by means of only masking of the bits. Other processes remained intact. Let’s take for the assumption that the requests to the IR4 AND ... Read More

8085 Program to convert ASCII to HEX

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 10:55:20

3K+ Views

Now let us see a program of Intel 8085 Microprocessor. This program will convert ASCII to HEXvalues.Problem StatementWrite 8085 Assembly language program to convert ASCII to Hexadecimal character values. DiscussionWe know that the ASCII of number 00H is 30H (48D), and ASCII of 09H is39H (57D). So all other numbers are ... Read More

Get floor value of a number using Math.floor in Java

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 10:03:57

561 Views

To get the floor value of a number, we use the java.lang.Math.floor() method. The Math.floor() method returns the largest (closest to positive infinity) double value which is less than or equal to the parameter and has a value which is equal to a mathematical integer on the number line. If ... Read More

Get square root of a number using Math.sqrt in Java

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 10:00:56

1K+ Views

In order to get the square root of a number in Java, we use the java.lang.Math.pow() method. The Math.pow(double a) method accepts one argument of the double data type and returns a value which is the square root of the argument.Declaration − The java.lang.Math.sqrt() method is declared as follows −public ... Read More

Get the base 10 logarithm of a value in Java

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 09:57:36

1K+ Views

To get the base 10 logarithm of value in Java, we use the java.lang.Math.log10() method. This method returns the log of value to the base 10 in the form of a double. If a number is 10n, then the result is n. If the value passed is NaN or negative, ... Read More

Terminate the timer in Java

Ankith Reddy

Ankith Reddy

Updated on 26-Jun-2020 09:47:44

2K+ Views

One of the methods of the Timer class is the cancel() method. It is used to terminate the current timer and get rid of any presently scheduled tasks.The java.util.Timer.cancel() method is declared as follows −public void cancel()Let us see a program which uses the cancel() methodExample Live Demoimport java.util.*; public class ... Read More

Advertisements