Nitya Raut has Published 278 Articles

With JavaScript how to change the width of a table border?

Nitya Raut

Nitya Raut

Updated on 23-Jun-2020 10:58:32

687 Views

To change the width of a table border, use the DOM border property. You can try to run the following code to change the width of a table border in JavaScript −Example                    function borderFunc(x) {             document.getElementById(x).style.border = "5px dashed blue";          }                                             One             Two                                 Three             Four                                 Five             Six                                          

How to apply a function simultaneously against two values of the array from right-to-left?

Nitya Raut

Nitya Raut

Updated on 23-Jun-2020 08:31:18

43 Views

Use the reduceRight() method in JavaScript to apply a function simultaneously against two values of the array from right-to-left as to reduce it to a single value.The following are the parameters −callback − Function to execute on each value in the array.initialValue − Object to use as the first argument to the ... Read More

How to list down all the plug-in installed in your browser?

Nitya Raut

Nitya Raut

Updated on 23-Jun-2020 06:55:20

699 Views

To list down all the plug-on installed in the web browser, use the JavaScript navigator object. The JavaScript navigator object includes a child object called plugins. This object is an array, with one entry for each plug-in installed on the browser.ExampleYou can try to run the following code to list ... Read More

How can we delete an existing MySQL table by using PHP script?

Nitya Raut

Nitya Raut

Updated on 22-Jun-2020 13:43:01

81 Views

As we know that PHP provides us the function named mysql_query to delete an existing MySQL table.ExampleTo illustrate this we are deleting a table named ‘Tutorials_tbl’ with the help of PHP script in the following example −           Creating MySQL Tables                  

What is the meaning of ‘empty set’ in MySQL result set?

Nitya Raut

Nitya Raut

Updated on 22-Jun-2020 11:53:16

4K+ Views

If there is ‘empty set’ in the result set of MySQL query then it means that MySQL is returning no rows and no error also in the query. It can be understood with the help of the following example −mysql> Select * from Student_info WHERE Name = 'ABCD'; Empty set ... Read More

In MySQL, how we can write Multiple-line statement?

Nitya Raut

Nitya Raut

Updated on 22-Jun-2020 08:46:50

3K+ Views

We can write multiple-line statements because MySQL determines the end of a statement by looking for the termination semicolon, not by looking for the end of the input line.Examplemysql> Select *     -> from     -> stock_item; +------------+-------+----------+ | item_name  | Value | Quantity | +------------+-------+----------+ | Calculator ... Read More

What are the different steps in using MySQL cursor?

Nitya Raut

Nitya Raut

Updated on 22-Jun-2020 07:34:45

297 Views

Followings are the different steps in using MySQL cursor −DECLARATION − First of all we must have to declare a cursor by using a DECLARE statement. The cursor declaration must be after the variable declaration. The syntax for declaring MySQL cursor can be as follows −DECLARE cursor_name CURSOR FOR SELECT-statement;OPENING ... Read More

What are the advantages and disadvantages of using MySQL stored procedures?

Nitya Raut

Nitya Raut

Updated on 22-Jun-2020 05:19:43

2K+ Views

There are numerous advantages and disadvantages of using MySQL stored procedures which are as follows −MySQL Stored Procedure AdvantagesFollowings are the advantages of using MySQL Stored Procedures −Increasing the performance of applications − As we know that after creating the stored procedure it is compiled and stored in the database. ... Read More

Which MySQL query can be used with the help of which we can see the list of MySQL databases?

Nitya Raut

Nitya Raut

Updated on 20-Jun-2020 12:56:32

52 Views

With the help of following MySQL query, we can see the list of MySQL database −mysql> SELECT schema_name FROM information_schema.schemata; +--------------------+ | schema_name        | +--------------------+ | information_schema | | gaurav             | | mysql              | | ... Read More

How MySQL LEFT JOIN can be used to simulate the MySQL MINUS query?

Nitya Raut

Nitya Raut

Updated on 20-Jun-2020 11:31:04

734 Views

Since we cannot use MINUS query in MySQL, we will use LEFT JOIN to simulate the MINUS query. It can be understood with the help of the following example:ExampleIn this example, we are two tables namely Student_detail and Student_info having the following data −mysql> Select * from Student_detail; +-----------+---------+------------+------------+ | ... Read More

Previous 1 ... 3 4 5 6 7 ... 28 Next
Advertisements