Sravani S has Published 86 Articles

How to force a number to display in exponential notation?

Sravani S

Sravani S

Updated on 23-Jun-2020 08:43:16

685 Views

Use the toExponential() method to force a number to display in exponential notation, even if the number is in the range in which JavaScript normally uses standard notation.The following is the parameter −fractionDigits - An integer specifying the number of digits after the decimal point. Defaults to as many digits ... Read More

How to access document properties using W3C DOM method?

Sravani S

Sravani S

Updated on 23-Jun-2020 07:06:52

84 Views

This IE4 document object model (DOM) introduced in Version 4 of Microsoft's Internet Explorer browser. IE 5 and later versions include support for most basic W3C DOM features.ExampleTo access document properties using W3C DOM method, you can try to run the following code −           ... Read More

How can I check if a JavaScript function is defined?

Sravani S

Sravani S

Updated on 23-Jun-2020 06:48:39

228 Views

To check if a JavaScript function is defined or not, checks it with “undefined”.ExampleYou can try to run the following example to check for a function is defined or not in JavaScript −                    function display() {       ... Read More

How can we fetch alternate even-numbered records from MySQL table?

Sravani S

Sravani S

Updated on 22-Jun-2020 12:26:48

249 Views

To understand this concept we are using the data from table ‘Information’ as follows −mysql> Select * from Information; +----+---------+ | id | Name    | +----+---------+ |  1 | Gaurav  | |  2 | Ram     | |  3 | Rahul   | |  4 | Aarav   ... Read More

How can we use MySQL SELECT without FROM clause?

Sravani S

Sravani S

Updated on 22-Jun-2020 11:42:35

1K+ Views

FROM clause after SELECT shows the references to a table. But if there is no reference to any table then we can use SELECT without the FROM clause. In other words, we can say that SELECT can be used to retrieve rows computed without reference to any table. Consider the ... Read More

What are the different MySQL prompts we have on the command line?

Sravani S

Sravani S

Updated on 22-Jun-2020 10:57:40

264 Views

As we know that after writing the first line of multiple-line queries, MySQL changes the prompt. The following table shows different MySQL prompts and it's meaning −PromptMeaning         mysql>It means MySQL is ready for a new command. →It means that MySQL is waiting for the next line of multiple-line ... Read More

Create a MySQL stored procedure, which takes the name of the database as its parameter, to list the tables with detailed information in a particular database.

Sravani S

Sravani S

Updated on 22-Jun-2020 06:49:30

308 Views

Suppose currently we are using a database named ‘query’ and it is having the following tables in it −mysql> Show tables in query; +-----------------+ | Tables_in_query | +-----------------+ | student_detail  | | student_info    | +-----------------+ 2 rows in set (0.00 sec)Now, following is a stored procedure, which will accept ... Read More

How can we see the list, along with complete information, of stored procedures in a particular MySQL database?

Sravani S

Sravani S

Updated on 22-Jun-2020 05:32:26

80 Views

We can use mysql.proc to see the list, along with complete information, of stored procedures in a particular MySQL database by the following query −mysql> Select * from mysql.proc where db = 'query' AND type = 'PROCEDURE' \G *************************** 1. row ***************************                 ... Read More

How can we establish MySQL database by using MySQL binary at commandprompt?

Sravani S

Sravani S

Updated on 20-Jun-2020 13:41:12

95 Views

You can establish the MySQL database using the mysql binary at the command prompt. It can be understood with the help of the following example −ExampleWe can use following statements to connect to the MySQL server from the command prompt −[root@host]# mysql -u root -p Enter password:******This will give us the mysql> ... Read More

How MySQL LENGTH() function measures the string length?

Sravani S

Sravani S

Updated on 20-Jun-2020 13:13:11

178 Views

MySQL LENGTH() function measures the string length in ‘bytes’ which means that it is not multibyte safe. The difference of the result between multi-byte safe functions, like CHAR_LENGTH() or CHARACTER_LENGTH(), and LENGTH() function especially relevant for Unicode, in which most of the characters are encoded in two bytes or relevant ... Read More

Advertisements