Ayyan has Published 72 Answers

Which event occurs in JavaScript when an element is dragged completely?

Ayyan
Ayyan
Published on 26-Feb-2018 15:49:34
The ondragend event triggers when an element is dragged completely.ExampleYou can try to run the following code to learn how to implement ondragend event in JavaScript.<!DOCTYPE HTML> <html>    <head>       <style>          .drag {             float: left;         ... Read More

What is the role of scrollY property in JavaScript?

Ayyan
Ayyan
Published on 26-Feb-2018 15:02:11
The scrollY property in JavaScript works the same as pageYoffset property. If you want to get the pixels the document scrolled to from the upper left corner of the window, then use the scrollY property for vertical pixels.ExampleYou can try to run the following code to learn how to work ... Read More

How to convert Decimal to Binary in JavaScript?

Ayyan
Ayyan
Published on 26-Feb-2018 14:41:15
To convert Decimal to Binary in JavaScript, you can try to run the following code.Example<!DOCTYPE html> <html>    <body>       <script>          document.write("Decimal to Binary<br>");          document.write((-7 >>> 0).toString(2));       </script>    </body> </html>Read More

Is it a good practice to place all declarations at the top in JavaScript?

Ayyan
Ayyan
Published on 26-Feb-2018 14:09:13
Yes, it is a good practice to place all the JavaScript declarations at the top. Let’s see an example −Example<html>    <head>       <title>JavaScript String match() Method</title>    </head>    <body>       <script>          // all the variables declared at top   ... Read More

Match any string containing at most one p.

Ayyan
Ayyan
Published on 26-Feb-2018 12:24:24
To match any string containing zero or one p’s with JavaScript RegExp, use the p? Quantifier.ExampleYou can try to run the following code to match any string containing zero or one p. Here p is considered a number of occurrences −<html>    <head>       <title>JavaScript Regular Expression</title>   ... Read More

With JavaScript RegExp search a carriage return character.

Ayyan
Ayyan
Published on 26-Feb-2018 11:13:59
To find carriage return character with JavaScript Regular Expression, use the following −\rExampleYou can try to run the following code to find a carriage return character. It returns the position where the carriage return (\r) character is found −<html>    <head>       <title>JavaScript Regular Expression</title>    </head> ... Read More

How Can MySQL virtual GENERATED COLUMNS work with built-in functions?

Ayyan
Ayyan
Published on 22-Feb-2018 16:07:54
It can be illustrated with the help of an example in which we are creating a virtual generated column in the table named ‘employee_data’. As we know that virtual generated column can be generated with or without using the keyword ‘virtual’.Examplemysql> Create table employee_data(ID INT AUTO_INCREMENT PRIMARY KEY,     ... Read More

How can we modify a MySQL view with CREATE OR REPLACE VIEW statement?

Ayyan
Ayyan
Published on 22-Feb-2018 15:02:47
As we know that we can modify a view by using ALTER VIEW statement but other than that we can also use CREATE OR REPLACE VIEW to modify an existing view. The concept is simple as MySQL simply modifies the view if it already exists otherwise a new view would ... Read More

How can we create multiple MySQL triggers for the same trigger event and action time?

Ayyan
Ayyan
Published on 22-Feb-2018 12:06:35
MySQL 5.7.2+ allows us to create multiple triggers for the same event and action time in a table. Both the triggers will activate sequentially when the event occurs. It can be understood with the help of an example −ExampleIn this example,  we are creating multiple triggers for the same event ... Read More

What kind of output is returned by MySQL scalar subquery? What are the restrictions on using it with MySQL query?

Ayyan
Ayyan
Published on 21-Feb-2018 17:05:13
MySQL scalar subquery returns exactly one column value from one row and we can use it where a single column is permissible. Followings are the cases when scalar subqueries return value other than one row −Case1 − When it returns 0 rowsIn case if the subquery returns 0 rows then ... Read More
1 2 3 4 5 6 7 8 Next
Advertisements