Fendadis John has Published 98 Articles

How to print application base apk path in android?

Fendadis John

Fendadis John

Updated on 26-Jun-2020 12:40:23

This example demonstrate about How to print application base apk path in android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml.     In ... Read More

How to get longitude from Network provider in android?

Fendadis John

Fendadis John

Updated on 26-Jun-2020 12:20:09

This example demonstrate about How to get longitude from Network provider in android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml.     In ... Read More

What should be done with the left/ right edges of the content on overflow with JavaScript?

Fendadis John

Fendadis John

Updated on 23-Jun-2020 13:34:35

If the content overflows, the workaround with overflowX property to solve the left/ right edge issues and set a scroll. Adding a scroll allows visitors to easily read the entire content.ExampleYou can try to run the following code to learn what is to be done with the left/ right edges ... Read More

How to set the list-item marker type with JavaScript?

Fendadis John

Fendadis John

Updated on 23-Jun-2020 13:18:44

To set the type of the list-item marker type, use the listStyleType property. The marker type can be square, circle, dic, etc.ExampleYou can try to run the following code to set the list-item marker type with JavaScript −Live Demo                   ... Read More

How to set the style of the rule between columns with JavaScript?

Fendadis John

Fendadis John

Updated on 23-Jun-2020 12:19:00

Use the columnRuleStyle property to set the style of the rule. You can try to run the following code to set the style of the rule between columns with JavaScript −ExampleLive Demo                    #myID {           ... Read More

How MySQL stored GENERATED COLUMNS are different from MySQL virtual GENERATED COLUMNS?

Fendadis John

Fendadis John

Updated on 22-Jun-2020 14:27:03

Followings are some basic differences between MySQL stored GENERATED COLUMNS and MySQL virtual GENERATED COLUMNS −In terms of Disk SpaceIf we see the difference in terms of disk space then virtual generated columns would not take any disk space. On the other hand, the stored generated column would take disk ... Read More

How VIEWS can be used to emulate CHECK CONSTRAINT?

Fendadis John

Fendadis John

Updated on 22-Jun-2020 14:16:24

As we know that MySQL supports foreign key for referential integrity but it does not support CHECK constraint. But we can emulate them by using triggers. It can be illustrated with the help of an example given below −ExampleSuppose we have a table named ‘car1’ which can have the fix ... Read More

What are the advantages, disadvantages and restrictions of using MySQL triggers?

Fendadis John

Fendadis John

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

We must have to understand the advantages, disadvantages, and restrictions of using MySQL triggers so that we can use it effectively.AdvantagesFollowings are the advantages of using MySQL triggers −Integrity of data − With the help of MySQL trigger we can check the integrity of data in the table. In other words, ... Read More

Which function in MySQL is used to reverse a particular string?

Fendadis John

Fendadis John

Updated on 22-Jun-2020 06:53:08

MySQL REVERSE() function can be used to reverse a string. Following example will demonstrate it −mysql> Select REVERSE('Tutorialspoint'); +---------------------------+ | REVERSE('Tutorialspoint') | +---------------------------+ | tniopslairotuT            | +---------------------------+ 1 row in set (0.00 sec) mysql> Select Reverse('10-11-12'); +---------------------+ | Reverse('10-11-12') | +---------------------+ | 21-11-01   ... Read More

How MySQL NULL-safe equal operator performs when used with row comparisons?

Fendadis John

Fendadis John

Updated on 22-Jun-2020 06:20:25

When we use NULL-safe operator with row comparisons like (A, B) (C, D) then its performance is equivalent to (A C) AND (B D). Following example will demonstrate it −mysql> Select (100, 50) (50, 100); +-----------------------+ | (100, 50) (50, 100) | +-----------------------+ |   ... Read More

Advertisements