Abhinaya has Published 69 Articles

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

Abhinaya

Abhinaya

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

241 Views

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

183 Views

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

6K+ Views

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

132 Views

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

180 Views

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

501 Views

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

9K+ Views

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

93 Views

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

163 Views

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

How GET_FORMAT() function can combine with DATE_FORMAT() and STR_TO_DATE() function?

Abhinaya

Abhinaya

Updated on 20-Jun-2020 07:03:53

96 Views

It is very useful to combine GET_FORMAT() function with DATE_FORMAT() and STR_TO_DATE() function.Combining with DATE_FORMAT()When it is combined with DATE_FORMAT() then it would arrange a particular date or time or datetime in a format obtained from GET_FORMAT() function.mysql> Select DATE_FORMAT('2017-10-22', GET_FORMAT(date, 'USA'))AS 'DATE IN USA FORMAT'; +-------------------+ | DATE IN ... Read More

Advertisements