Ayyan has Published 57 Articles

Which MySQL function is used to find first non-NULL value from a list of values?

Ayyan

Ayyan

Updated on 20-Jun-2020 12:02:11

138 Views

We can use MySQL COALESCE() function to get the first non-NULL value as output from a list of values. In other words, this function will check all the values until non-null value found. It can take one or more than one argument. It is having the following syntax:COALESCE(value1, value2, …, ... Read More

What MySQL returns if we use NULL, as both the arguments, as one of the argument and as a separator, in CONCAT_WS() function?

Ayyan

Ayyan

Updated on 20-Jun-2020 08:37:20

51 Views

NULL as both argumentsMySQL returns blank output if we will use NULL as both of the arguments in CONCAT_WS() function.Examplemysql> Select CONCAT_WS('', NULL, NULL); +-------------------------+ | CONCAT_WS('', NULL, NULL) | +-------------------------+ |                         | +-------------------------+ 1 row in set ... Read More

How can we fetch a particular row as output from a MySQL table?

Ayyan

Ayyan

Updated on 20-Jun-2020 06:20:28

2K+ Views

For fetching a particular row as output, we need to use WHERE clause in the SELECT statement. It is because MySQL returns the row based on the condition parameter given by us after WHERE clause.ExampleSuppose we want to fetch a row which contains the name ‘Aarav’ from student table then ... Read More

The C++ Standard Template Library (STL)

Ayyan

Ayyan

Updated on 18-Jun-2020 12:31:43

417 Views

The Standard Template Library is a software library for the C++ programming language that influenced several parts of the C++ Standard Library. It provides four components called algorithms, containers, functions, and iterators. Note that the term "STL" or "Standard Template Library" does not show up anywhere in the ISO 14882 ... Read More

How to define getter and setter functions in JavaScript?

Ayyan

Ayyan

Updated on 16-Jun-2020 08:11:42

172 Views

GetterWhen a property is accessed, the value gets through calling a function implicitly. The get keyword is used in JavaScript. An identifier, either a number or a string is allowed for set.SetterWhen a property is set, it implicitly call a function and the value is passed as an argument. With ... Read More

What are the latest operators added to JavaScript?

Ayyan

Ayyan

Updated on 16-Jun-2020 08:10:14

54 Views

The latest operators added to JavaScript are spread operator and rest.Rest operatorWith rest parameter, you can represent number of arguments as an array. ES6 brought rest parameter to ease the work of developers. For arguments objects, rest parameters are indicated by three dots … and preceds a parameter.ExampleLet’s see the ... Read More

How to convert a Boolean to Integer in JavaScript?

Ayyan

Ayyan

Updated on 15-Jun-2020 07:11:35

234 Views

Yes, it is possible to convert Boolean to Integer in JavaScript, using the Ternary Operator.ExampleYou can try to run the following code to convert Boolean to Integer −Live Demo           JavaScript Boolean                        var answer = true;          document.write(answer);          var pass_marks = answer ? 90 : 40;          document.write("Passing Marks: "+pass_marks);          

How to declare a boolean in JavaScript?

Ayyan

Ayyan

Updated on 15-Jun-2020 06:24:05

2K+ Views

To declare a Boolean in JavaScript, you need to assign true or false value.var answer = true;ExampleTo learn about the working of Boolean, let’s see the following example −Live Demo           JavaScript Boolean                        var num1 = 10;          var num2 = 20;          document.write(num1 > num2);          

What are Java JVM Run-time Data Areas?

Ayyan

Ayyan

Updated on 13-Jun-2020 13:48:58

363 Views

 Following are the runtime data areas of JVM.Class Area − Storage areas for a class elements structure like fields, method data, code of method etc.Heap − Runtime storage allocation for objects.Stack − Storage for local variables and partial results. A stack contains frames and allocates one for each thread. Once ... Read More

How to Set Temporary Path of JDK in Windows?

Ayyan

Ayyan

Updated on 13-Jun-2020 12:43:08

697 Views

Following are the required steps −Open a command prompt.Type following commands:C:\> set path=C:\Program Files\Java\jdk1.8.0_23\bin

Advertisements