Arjun Thakur has Published 1025 Articles

Can someone give one exact example of webview implementation in android

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

272 Views

Before getting into webview implementation we should know what is webview. Webview is a extended of a view and it is used to show HTML content or web pages.Methods are available in webview.clearHistory() − it is used to clear webview historydestroy() − It is used to destroy internal state of ... Read More

Pass array to MySQL stored routine?

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

5K+ Views

We need to create a stored procedure to display how to pass array to MySQL stored routine. Let us first create a table for our example. Creating a table mysql> create table FindDemo -> ( -> name varchar(100) -> ); ... Read More

Infrared Transmission

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

3K+ Views

Infrared waves are those between the frequencies 300GHz and 400THz in the electromagnetic spectrum. Their wavelengths are shorter than microwaves but longer than visible light. Infrared propagation is line of sight. They cannot penetrate walls and sun’s infrared rays interfere with these rays. So cannot be used for long – ... Read More

How to make an existing field Unique in MySQL?

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

8K+ Views

To make an existing field unique in MySQL, we can use the ALTER command and set UNIQUE constraint for the field. Let us see an example. First, we will create a table. mysql> create table AddingUnique -> ( -> Id int, ... Read More

How to display all tables in MySQL with InnoDB storage engine?

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

557 Views

To display all table names with ENGINE as InnoDB, implement the following query mysql> SELECT TABLE_SCHEMA as DATABASENAME ,TABLE_NAME as AllTABLENAME ,ENGINE as ENGINETYPE FROM information_schema.TABLES -> WHERE ENGINE = 'innoDB' -> AND TABLE_SCHEMA NOT IN('mysql', 'information_schema', 'performance_schema'); The following is the ... Read More

What is search view in android?

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

275 Views

Before getting into searchview example, we should know what is search view in android, search view is just like search box in HTML. we can search anything from particular list items.This example demonstrate about how to integrate search view in android.Step 1 − Create a new project in Android Studio, ... Read More

How to access unique Android device ID?

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

2K+ Views

If you want to check unique device id like IMEI number through programmatically we can do this by telephonic manger as shown below example −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 ... Read More

How to prepend a string to a column value in MySQL?

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

5K+ Views

To prepend a string to a column value in MySQL, we can use the function CONCAT. The CONCAT function can be used with UPDATE statement. Creating a table. mysql> create table PrependStringOnCOlumnName   -> (   -> Id int,   -> Name varchar(200)   -> ); Query OK, 0 ... Read More

How do I see what character set a MySQL database  / table / column is?

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

5K+ Views

To check what character set a MySQL database/ table/ column is, let us see an example: A database which has the name ‘business’ and table name is ‘student’ which is already present in the database is used. Syntax in order to check the table character set. SELECT CCSA.character_set_name ... Read More

Get digits from a record in MySQL?

Arjun Thakur

Arjun Thakur

Updated on 30-Jul-2019 22:30:23

257 Views

Use the function CONVERT() or Regular Expression. The CONVERT() method converts a value from one datatype to another. This will ecnetually fetch digits for us. Let us see an example. Firstly, we will create a table. mysql> create table textIntoNumberDemo   -> (   -> Name varchar(100)   -> ... Read More

Advertisements