
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Jennifer Nicholas has Published 291 Articles

Jennifer Nicholas
3K+ Views
To download a video from a URL in swift we need to perform a few steps while keeping a few things in mind.Points to be noted here are, We’ll be making use of internet to download video, hence we need to allow permissions for App transport security in our Info.plistWe’ll ... Read More

Jennifer Nicholas
2K+ Views
As a DIP package Intel 8253 is a 24-pin programmable IC available. IChas three counters which work independently and whose width is of16-bits. In addition, we have a control port to decide what is the mode of working of the three counters. The physical and functional pin diagrams of them ... Read More

Jennifer Nicholas
3K+ Views
Now let us see a program of Intel 8085 Microprocessor. This program will convert binary or hexadecimal number to ASCII values.Problem StatementWrite 8085 Assembly language program to convert binary or Hexadecimal characters to ASCII values. DiscussionWe know that the ASCII of number 00H is 30H (48D), and ASCII of 09H is39H ... Read More

Jennifer Nicholas
6K+ Views
You will get this type of error when your MySQL version is below 5.5.3. This is because “utf8mb4” introduced in MySQL version 5.5.3.Firstly, you need to check the current version. If its less than 5.5.3, then you need to upgrade to solve the above error.Check the current version −mysql> select ... Read More

Jennifer Nicholas
177 Views
You can find the highest number in a column with the help of aggregate function MAX. The syntax is as follows −select max(yourColumnName) as anyVariableName from yourTableName;To understand the above concept, let us create a table with an int column. The following is the query to create a table.mysql> create ... Read More

Jennifer Nicholas
549 Views
To list all triggers in a MySQL database, you can use the SHOW command. The query is as follows −mysql> show triggers;The following is the output −+----------------+--------+----------------------+--------------------------------------------------------------------+--------+------------------------+--------------------------------------------+---------+----------------------+----------------------+--------------------+ | Trigger | Event | Table | Statement ... Read More

Jennifer Nicholas
11K+ Views
You can set primary key on an existing column in MySQL with the help of alter command.The syntax is as follows to add primary key to an existing column.ALTER TABLE yourTableName ADD PRIMARY KEY(yourColumnName);To set existing column as primary key, let us first create a table. The query to create ... Read More

Jennifer Nicholas
98 Views
To achieve this with LIKE operator, the following is the syntax −CREATE TABLE yourTableName2 LIKE yourTableName1;To understand the syntax, let us create a table and insert some records into it. The following is the query to create a table −mysql> create table Employee −> ( −> EmployeeId int ... Read More

Jennifer Nicholas
6K+ Views
To add leading zero to some value, use the LPAD() function of MySQL. The syntax is as follows −select lpad(yourColumnName, lengthofColumnValue+1, 0) from yourTableName;Here is an example of LPAD().mysql> select lpad('98765432', 9, 0);The following is the output −+----------------------+ | lpad('98765432', 9, 0) | +----------------------+ | 098765432 ... Read More

Jennifer Nicholas
330 Views
To create a wobble animation effect with CSS, you can try to run the following code −ExampleLive Demo .animated { background-image: url(/css/images/logo.png); background-repeat: no-repeat; ... Read More