Alankritha Ammu has Published 59 Answers

How to use floating image in HTML page?

Alankritha Ammu

Alankritha Ammu

Updated on 22-Dec-2021 10:35:43

To use a floating image in HTML, use the CSS property float. It allows you to float an image left or right. More property values include the following:Sr.No.Property Value & Description1noneNot floated2leftFloats to the left3rightFloats to the right4initialDefault valueExampleYou can try to run the following code to use floating image ... Read More

How to return a number indicating the Unicode value of the character?

Alankritha Ammu

Alankritha Ammu

Updated on 23-Jun-2020 08:41:29

The charCodeAt() method returns a number indicating the Unicode value of the character at the given index. Unicode code points range from 0 to 1, 114, 111. The first 128 Unicode code points are a direct match of the ASCII character encoding.The following parameter is supported by charCodeAt(index) −index − An integer ... Read More

Set the minutes for a specified date according to universal time.

Alankritha Ammu

Alankritha Ammu

Updated on 23-Jun-2020 08:07:23

JavaScript date setUTCMinutes() method sets the minutes for a specified date according to universal time.The following are the parameters for setUTCMinutes(minutesValue[, secondsValue[, msValue]]) method −minutesValue − An integer between 0 and 59, representing the minutes.secondsValue − An integer between 0 and 59, representing the seconds. If you specify the secondsValue ... Read More

Match Unicode character specified by the hexadecimal number XXXX.

Alankritha Ammu

Alankritha Ammu

Updated on 23-Jun-2020 07:56:14

To match a Unicode character specified by the hexadecimal number xxx with JavaScript Regular Expression, use the following −\uxxxxExampleYou can try to run the following code to match the hexadecimal number character xxxx. It matches the hexadecimal number 53 i.e. S −           JavaScript Regular Expression ... Read More

How can we create a MySQL view with RIGHT JOIN?

Alankritha Ammu

Alankritha Ammu

Updated on 22-Jun-2020 13:56:44

To illustrate the making of MySQL view with RIGHT JOIN we are using the following data from ‘Customers’ and ‘Resreve’ tables −mysql> Select * from Customers; +-------------+----------+ | Customer_Id | Name     | +-------------+----------+ | 1           | Rahul    | | 2     ... Read More

What is MySQL event and how it is related to trigger?

Alankritha Ammu

Alankritha Ammu

Updated on 22-Jun-2020 12:19:01

A MySQL event is a task that rums based on a predefined schedule therefore sometimes it is referred to as a scheduled event. In other words, we can say that the MySQL event schedule is a process that runs in the background and constantly looks for the events to execute. ... Read More

How can we use a subquery that contains a reference to a table that also appears in the outer query?

Alankritha Ammu

Alankritha Ammu

Updated on 22-Jun-2020 08:24:37

A subquery that contains a reference to a table that also appears in the outer query is called a correlated subquery. In this case,  MySQL evaluates from inner query to the outer query. To understand it we are having the following data from table ‘cars’ −mysql> Select * from Cars; ... Read More

What are MySQL group functions?

Alankritha Ammu

Alankritha Ammu

Updated on 22-Jun-2020 08:04:31

Group functions are the function which applied to a group of rows or in other words group functions operate on sets of values. The following table gives the Description of MySQL group functions −Sr.No.Name & Description1AVG()It returns the average value of the argument.2BIT_AND()It returns bitwise AND.3BIT_ORIt returns bitwise OR.4BIT_XOR()It returns ... Read More

What MySQL returns if we provide value larger than 255 as argument to MySQL CHAR() function?

Alankritha Ammu

Alankritha Ammu

Updated on 22-Jun-2020 06:10:54

MySQL converts the arguments of CHAR() function which is greater than 255 to multiple result bytes. For example, CHAR(260) is equivalent to CHAR(0, 1, 0, 4). It can be more clear with the help of following statements −mysql> Select HEX(CHAR(256)), HEX(CHAR(1, 0)); +----------------+----------------+ | HEX(CHAR(256)) | HEX(CHAR(1, 0)) | +----------------+----------------+ ... Read More

How can we add day/s in the date stored in a column of MySQL table?

Alankritha Ammu

Alankritha Ammu

Updated on 22-Jun-2020 04:57:37

Two functions can be used for this purpose and in both the functions we need to provide column name as an argument along with INTERVAL keyword. The functions are as follows −DATE_ADD() functionThe syntax of this function is DATE_ADD(date, INTERVAL expression unit). It can be demonstrated by following the example ... Read More

Advertisements