Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Let us first see how we can perform NAND/NOR operations in MySQL. The concept is as follows −NAND= NOT( yourColumnName1 AND yourColumnName2) NOR=NOT( yourColumnName1 OR yourColumnName2)Let us first create a table −mysql> create table DemoTable ( Value1 boolean , Value2 boolean ); Query OK, 0 rows affected (0.72 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(true, true); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(false, false); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values(false, true); Query OK, 1 row affected (0.10 sec) mysql> insert ... Read More
Let us first create a table −mysql> create table DemoTable ( BookingDate date ); Query OK, 0 rows affected (0.67 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-09-21'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable values('2018-09-10'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable values('2019-09-10'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('2019-09-08'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values('2016-09-18'); Query OK, 1 row affected (0.17 sec)Display all records from the table using select statement −mysql> select ... Read More
Use GROUP BY with the COUNT() method. Group the names with GROUP BY and count using the COUNT() method. Let us first create a table −mysql> create table DemoTable ( Name varchar(30) ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Chris'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values('Mike'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable values('Robert'); Query OK, 1 row affected (0.07 sec) mysql> insert into ... Read More
To populate autocomplete, use the LIKE clause in MySQL. Let us first create a table −mysql> create table DemoTable ( SchoolName varchar(100) ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('Horce Greeley'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable values('Conestoga Senior'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values('Adlai E.Stevenson'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values('Thomas Jefferson'); Query OK, 1 row affected (0.07 sec)Display all records from the table using select statement :mysql> ... Read More
For this, use GROUP_CONCAT() along with GROUP BY. Here, the GROUP_CONCAT() is used to concatenate data from multiple rows into one field.Let us first create a table −mysql> create table DemoTable ( PlayerId int, ListOfPlayerName varchar(30) ); Query OK, 0 rows affected (0.52 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(100, 'Chris'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable values(101, 'David'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable values(100, 'Bob'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable values(100, 'Sam'); Query ... Read More
Functional TestingAll the user requirements as specified by the business should be well tested as a part of functional testing. Functional Testing demands Testing in the environment similar to that of client’s requirement. All the boundary conditions, negative scenario are accounted for. Each functionality of the application should be working well with minimal probability of any bug.Objective of Functional TestingThe basic requirement which is expected out of a well running application should be tested. The UI should be user friendly and easy to navigate. Error messages should pop-up in case any unwanted entry is entered.A bug free application with the ... Read More
To ensure smooth, speedy and effective testing and delivery of a project, automation plays a crucial role. It becomes very essential in this digital business that continuous testing and delivery are ensured.Automation requires tools which control and compare the actual and the expected results. Repetitive execution as a part of Regression is also considered when Automation is talked about.While handling a huge project, automation plays a key role where few areas needs to be tested again and again in periodic interval. End-to-end testing result ensure the robust working of the application.When Automation is considers, it becomes very significant to identify ... Read More
IntroductionAmong the four flavors of Selenium, Selenium Grid is one such flavor. The facility to run multiple tests on multiple machines, on multiple browsers simultaneously is made possible by Selenium Grid. It also allows running test cases on multiple browsers in parallel.Selenium Grid has 2 versions- older Grid 1 and older Grid 2. Old Grid 1 is obsolete now, hence Grid 2 is used.Selenium 2 is bundled with Selenium Server jar file. There is no need to install Apache Ant unlike Grid 1.How it worksSelenium Grid consists of hub and multiple nodes. Test runs on single machine called Hub and ... Read More
Here we will see the data memory structures of 8051 microcontroller. The internal data memory of 8051 is divided into two groups. These are a set of eight registers, and a scratch pad memory. These eight registers are R0 to R7. The address range 00H to 07H is used to access the registers, and the rest are scratch pad memory.8051 Provides four register bank, but only one register bank can be used at any point of time. To select the register bank, two bits of PSW (Program Status Word) are used.So the following addressing can be used to select register ... Read More
Here we will see the division operation. This operation will be used to divide two 8-bit numbers using this 8051 microcontroller. The register A and B will be used in this operation. No other registers can be used for division. The result of the division has two parts. The quotient part and the remainder part. Register A will hold Quotient, and register B will hold Remainder.We are taking two number 0EH and 03H at location 20H and 21H, After dividing the result will be stored at location 30H and 31H.AddressValue …20H0EH21H03H …30H00H31H00H …Program MOV R0, #20H ; set source address 20H ... Read More