Jennifer Nicholas has Published 291 Articles

How to download a video using a URL and save it in an photo album using Swift?

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 14:07:25

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

Description of 8253 timer

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 14:00:28

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

8085 code to convert binary number to ASCII code

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 13:34:04

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

How to resolve the ERROR 1115 (42000): Unknown character set: 'utf8mb4'?

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 08:03:49

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

How to find the highest number in a column?

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 07:44:16

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

How to list all triggers in a MySQL database?

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 07:30:33

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

Set existing column as Primary Key in MySQL?

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 07:24:28

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

Create a new table with the properties of an old table and without duplicates using MySQL LIKE Operator?

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 07:22:13

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

How to add a leading zero to some values in a column in MySQL?

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 07:16:38

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

Wobble Animation Effect with CSS

Jennifer Nicholas

Jennifer Nicholas

Updated on 29-Jun-2020 07:16:24

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

Advertisements