Abhinaya has Published 75 Articles

What are the document properties of IE4 DOM method?

Abhinaya

Abhinaya

Updated on 23-Jun-2020 07:28:02

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.ExampleThe following are the document properties of IE4 DOM method −Sr.NoProperty & Description1activeElementA read-only property that refers to the input element that is ... Read More

With JavaScript how can I find the name of the web browser, with version?

Abhinaya

Abhinaya

Updated on 23-Jun-2020 07:01:42

To find the name of the web browser, with version, you need to try the following code −Example           Browser Detection Example                                  

How do you launch the JavaScript debugger in Google Chrome?

Abhinaya

Abhinaya

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

To launch JavaScript debugger in Google Chrome, try any of the following ways,Press Ctrl + Shift + JGo to Settings and click More Tools. After that, click Developer Tools.For more, refer the official website of  Chrome Dev Tool,

How to return an object from a JavaScript function?

Abhinaya

Abhinaya

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

To return an object from a JavaScript function, use the return statement, with this keyword.ExampleYou can try to run the following code to return an object from a JavaScipt function − Live Demo                    var employee = {             ... Read More

How can we simulate the MySQL INTERSECT query having WHERE clause?

Abhinaya

Abhinaya

Updated on 22-Jun-2020 12:49:51

Since we cannot use INTERSECT query in MySQL, we will use IN operator to simulate the INTERSECT 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

What is the use of the LIMIT keyword in MySQL query?

Abhinaya

Abhinaya

Updated on 22-Jun-2020 11:47:45

LIMIT keyword in MySQL can specify the number of records to be returned in the output. LIMIT clause restricts the number of rows to be returned. It can be understood with the help of the following example −Examplemysql> Select * from Student_info; +------+---------+------------+------------+ | id   | Name    | ... Read More

How can I display MySQL query result vertically?

Abhinaya

Abhinaya

Updated on 22-Jun-2020 11:03:30

With the use of ego, \G option at end of a statement, we can get the result set in vertical format. Consider the following example −mysql> Select * from Student where name = 'Aarav'\G *************************** 1. row ***************************   Name: Aarav RollNo: 150  Grade: M.SC 1 row in set (0.00 sec)

How can MySQL IF ELSEIF ELSE statement be used in a stored procedure?

Abhinaya

Abhinaya

Updated on 22-Jun-2020 05:45:27

MySQL IF ELSEIF ELSE execute the statements based on multiple expressions Its syntax is as follows −IF expression THEN    statements; ELSEIF elseif-expression THEN    elseif-statements; … … … … ELSE   else-statements; END IF;The statements must end with a semicolon.To demonstrate the use of IF ELSEIF ELSE statement within MySQL ... Read More

How can I change the storage engine of a MySQL table?

Abhinaya

Abhinaya

Updated on 20-Jun-2020 13:57:52

MySQL ALTER TABLE statement can change the storage engine of a table as follows −mysql> ALTER TABLE Student ENGINE = 'InnoDB'; Query OK, 0 rows affected (0.90 sec) Records: 0 Duplicates: 0 Warnings: 0Now with the help of the following statement, we can check that the storage engine has been ... Read More

How MySQL prevents unauthorized clients from accessing the database system?

Abhinaya

Abhinaya

Updated on 20-Jun-2020 11:51:30

MySQL implements a sophisticated access control and privilege system that allows us to create comprehensive access rules for handling client operations and effectively preventing unauthorized clients from accessing the database system.The MySQL access control has two stages when a client connects to the server −Connection verification A client, which connects to ... Read More

Advertisements