Priya Pallavi has Published 70 Articles

What would be effect of negative value of second argument, which specifies the number of decimal places, on the output of MySQL ROUND() function?

Priya Pallavi

Priya Pallavi

Updated on 10-Feb-2020 10:37:50

889 Views

If we specify the negative value of the second argument then the digits before the decimal point would be deleted and rounded off. The number of digits to be deleted depends upon the value of the negative second argument. Following examples will demonstrate the change, depending upon the negative value ... Read More

What is the synonym statement of SHOW DATABASES with the help of which we can see the list of MySQL databases?

Priya Pallavi

Priya Pallavi

Updated on 10-Feb-2020 08:13:51

55 Views

As we know that with the help of SHOW DATABASES statement we can see the list of MySQL databases. Similarly, we can use SHOW SCHEMAS as the synonym of SHOW DATABASES to get the list of databases.Examplemysql> SHOW DATABASES; +--------------------+ | Database           | +--------------------+ | ... Read More

Java constructor return a value but, what?

Priya Pallavi

Priya Pallavi

Updated on 04-Feb-2020 10:54:52

717 Views

No. Java constructor cannot return a value. If required, just create a method which calls the required constructor and returns the required value. See the example below.public class Tester {    public Tester(){}    public static Tester getInstance(){       Tester tester = new Tester();        return tester;    } }

Add or subtract space between the words of a sentence with CSS

Priya Pallavi

Priya Pallavi

Updated on 31-Jan-2020 06:03:17

287 Views

The word-spacing property is used to add or subtract space between the words of a sentence. Possible values are normal or a number specifying space. ExampleYou can try to run the following code to implement word-spacing property.                             Asia is a continent.          

Shorthand property to set the font with CSS

Priya Pallavi

Priya Pallavi

Updated on 30-Jan-2020 10:17:39

138 Views

The font property is used as shorthand to specify the number of other font properties, such as font family, size, style, etc.ExampleYou can try to run the following code to learn how to work with font property:                            Applying all the properties on the text at once.          

How can I use TIME_FORMAT() function to offload time/date values in MySQL?

Priya Pallavi

Priya Pallavi

Updated on 30-Jan-2020 05:39:56

87 Views

TIME_FORMAT() function can be used in a similar fashion as DATE_FORMAT() function but it can only be used for offloading time values. MySQL returns a NULL value if TIME_FORMAT() function is used for offloading date values.For example, when we pass the time format units as arguments to MySQL TIME_FORMAT() function ... Read More

How to get the first day of the current month in MySQL?

Priya Pallavi

Priya Pallavi

Updated on 28-Jan-2020 12:19:18

1K+ Views

With the help of following MySQL query, we can get the first day of the current month −mysql> SELECT DATE_SUB(LAST_DAY(NOW()), INTERVAL DAY(LAST_DAY(NOW()))- 1 DAY) AS 'FIRST DAY OF CURRENT MONTH'; +----------------------------+ | FIRST DAY OF CURRENT MONTH | +----------------------------+ | 2017-10-01                 | ... Read More

What is a segmentation fault in C/C++?

Priya Pallavi

Priya Pallavi

Updated on 27-Jan-2020 12:35:13

9K+ Views

A segmentation fault occurs when your program attempts to access an area of memory that it is not allowed to access. In other words, when your program tries to access memory that is beyond the limits that the operating system allocated for your program.Seg faults are mostly caused by pointers ... Read More

What is arguments object in JavaScript?

Priya Pallavi

Priya Pallavi

Updated on 08-Jan-2020 11:02:11

144 Views

Arguments object in JavaScript is an object, which represents the arguments to the function executing. Its syntax has two arguments:[function.]arguments[p]ExampleYou can try to run the following code to learn what are arguments object in JavaScriptLive Demo                    function functionArgument(val1, val2, val3) ... Read More

What was the name of JavaScript when it was created?

Priya Pallavi

Priya Pallavi

Updated on 02-Jan-2020 07:59:07

811 Views

JavaScript launched in May 1995 by Brendan Eich, who used to work at Netscape. Initially, it wasn’t called JavaScript; it was given the name Mocha.The name Mocha was chosen by Marc Andreessen, a Netscape founder. The name was changed to LiveScript in September 1995. In the same year, December, it ... Read More

Advertisements