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
Articles by Chandu yadav
Page 30 of 81
How to insert current date/time in MySQL?
To insert current date/ time in MySQL, use the now() function. Let us now see an example.At first, we will create a table. The CREATE command is used to create a table.mysql > create table CurrentDateTime -> ( -> CurrentTime datetime -> ); Query OK, 0 rows affected (1.14 sec)Syntax to insert the current date/time with the help of insert command and now()mysql> insert into CurrentDateTime values(now()); Query OK, 1 row affected (0.11 sec)To check that the current date/ time is inserted in the table or not, use the select command.mysql> select *from CurrentDateTime; The following is the output that ...
Read MoreIs it possible to use UPDATE query with LIMIT in MySQL?
Yes, it is possible to use UPDATE query with LIMIT in MySQL. Let us see how.For our example, we will first create a table. The CREATE command is used to create a table.mysql>CREATE table tblUpdateLimit -> ( -> id int, -> name varchar(100) -> ); Query OK, 0 rows affected (0.53 sec)Records are inserted with the help of INSERT command.mysql>INSERT into tblUpdateLimit values(1, 'John'); Query OK, 1 row affected (0.54 sec) mysql>INSERT into tblUpdateLimit values(2, 'Carol'); Query OK, 1 row affected (0.12 sec) mysql>INSERT into tblUpdateLimit values(3, 'Smith'); Query OK, 1 row affected (0.10 sec) mysql>INSERT into ...
Read MoreHow to escape single quotes in MySQL?
We can escape single quotes with the help of the SELECT statement. For instance, when single quotes are encountered in a name, eg. “Carol’s”.Let us see the syntax.SELECT ‘SomeValue’;Here is an example that display how to include text with single quotes.mysql> SELECT 'Carol's Taylor.'; The following is the output.+-------------------+ | Carol's Taylor | +-------------------+ | Carol's Taylor | +-------------------+ 1 row in set (0.00 sec)
Read MoreIntel 8259A Programmable Interrupt Controller
8085 microprocessor, consists of five interrupt input pins named as RST 5.5, RST 6.5, RST7.5, INTR, and TRAP respectively. When there are a maximum of five I/O devices they want to perform driven interrupt data transfer, which is connected to the five interrupt input pins. Now considering the case where there are more than five I/O devices which would like to perform an interrupt driven data transfer scheme. Here for some pins termed as an interrupt, we use more than one I/O device to the process. Most of the microprocessors nowadays have the configuration of these interrupt input pins. There ...
Read MoreSlave register in 8259
It is also an 8-bit register. The processor here writes to SLR but cannot read. The content of this register here implies a different meaning for Master8259 and Slave 8259. Through Master 8259 information is carried through the IR inputs to which Slave 8259s are connected. If the SLR of Master 8259 is loaded with the value 00001111, then it signifies that:The Slave exists on 8259 namely called as IR0, IR1, IR2 and IR3.No Slave exists on 8259 on this registers IR4, IR5, IR6 and IR7.A Slave 8259 serves information about the IR input of Master 8259 to which the ...
Read More8085 Program to find Square of a number using look up table
Now let us see a program of Intel 8085 Microprocessor. This program is mainly for finding a square of a number.Problem StatementWrite 8085 Assembly language program to find the square of a number using Look-Up Table. DiscussionIn this example, we are using Look-Up table to find the square of a number. The main limitation of this program is that it can find a square in range 0-F. When the input is above F, it will fail. We are storing the square result into the memory. When the number is greater than F, we are storing FFH into memory to indicate an ...
Read More8085 Program to Subtract two 8 Bit numbers
In this program, we will see how to subtract two 8-bit numbers using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to subtract two 8-bit numbers and store the result at locations 8050H and 8051H.DiscussionIn 8085, the SUB instruction is used 2’s complemented method for subtraction. When the first operand is larger, the result will be positive. It will not enable the carry flag after completing the subtraction. When the result is negative, then the result will be in 2’s complemented form and carry flag will be enabled. We are using two numbers at location 8000H and 8001H. When the numbers are ...
Read More8085 Program to Divide two 8 Bit numbers
In this program, we will see how to divide two 8-bit numbers using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to divide two 8-bit numbers and store the result at locations 8020H and 8021H.DiscussionThe 8085 has no division operation. To get the result of the division, we should use the repetitive subtraction method. By using this program, we will get the quotient and the remainder. 8020H will hold the quotient, and 8021H will hold the remainder.We are saving the data at location 8000H and 8001H. The result is storing at location 8050H and 8051H.InputThe Dividend: 0EHThe Divisor 04HThe Quotient will be ...
Read MoreCheck if the String contains only unicode letters in Java
In order to check if a String has only Unicode letters in Java, we use the isDigit() and charAt() methods with decision-making statements.The isLetter(int codePoint) method determines whether the specific character (Unicode codePoint) is a letter. It returns a boolean value, either true or false.Declaration −The java.lang.Character.isLetter() method is declared as follows −public static boolean isLetter(int codePoint)Here, the parameter codePoint represents the character to be checked.The charAt() method returns a character value at a given index. It belongs to the String class in Java. The index must be between 0 to length()-1.Declaration −The java.lang.String.charAt() method is declared as follows −public ...
Read MoreSet printing double-sided documents with CSS
When printing double-sided documents, the page boxes on the left and right pages should be different.ExampleIt can be expressed through two CSS pseudo-classes as follows −
Read More