We can see only the list of stored procedures in a particular MySQL database by the following query −mysql> SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'query'AND ROUTINE_TYPE = 'PROCEDURE'// +--------------+------------------------+ | ROUTINE_TYPE | ROUTINE_NAME           | +--------------+------------------------+ | PROCEDURE    | allrecords     ... Read More

The multi-column column-rule property is used to specify the number of rules.You can try to run the following code to implement the column-rule property in CSS3 −ExampleLive Demo                    .multi {             /* Column count property ... Read More

To change MySQL user password with the help of UPDATE statement, we need to update the ‘user’ table of the ‘mysql’ database. Its syntax would be as follows −SyntaxUSE mysql; UPDATE user SET authentication_string = PASSWORD(‘new_password’) WHERE user = user_name AND host = host_name;The first two statements will be common ... Read More

As we know that BLOB is a binary large object that can hold a variable amount of data. The different TEXT objects offer a range of storage space from 255 bytes to 4 Gb. Following table shows the storage of different kinds of BLOB data type −Type of BLOBMaximum amount ... Read More

MySQL EXTRACT() function can use following compound units −SECOND_MICROSECONDMINUTE_MICROSECONDHOUR_MICROSECONDDAY_MICROSECONDMINUTE_SECONDHOUR_SECONDHOUR_MINUTEDAY_SECONDDAY_MINUTEDAY_HOURYEAR_MONTHSome of the examples of these compound units used in EXTRACT() function are as follows −mysql> Select EXTRACT(YEAR_MONTH from '2017-10-20'); +---------------------------------------+ | EXTRACT(YEAR_MONTH from '2017-10-20') | +---------------------------------------+ |                             ... Read More

The onmousemove event triggers when the mouse pointer moves.ExampleYou can try to run the following code to learn how to work with onmousemove event in JavaScript −                                         This is demo text for mousemove event.    

You can use the del function to delete a specific key or loop through all keys and delete them. For example, my_dict = {'name': 'foo', 'age': 28} keys = list(my_dict.keys()) for key in keys:    del my_dict[key] print(my_dict)This will give the output:{}You can also use the pop function to delete ... Read More

IS-A RelationshipIS-A is a way of saying − This object is a type of that object. Let us see how the extends keyword is used to achieve inheritance. public class Animal { } public class Mammal extends Animal { } public class Reptile extends Animal { } public class Dog extends ... Read More

Firstly convert your number to hexadecimal with leading zeros and then format it by adding dashes.ExampleYou can try to run the following code to format hexadecimal number −Live Demo                    var num = 32122;          var myHex ... Read More

To get current year in JavaScript, use the getFullYear() method.ExampleYou can try to run the following code to print current year −Live Demo           Click below to get the current year:       Display Year                      function display() {             var date = new Date();             var res = date.getFullYear();             document.getElementById("test").innerHTML = res;          }