
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Arjun Thakur has Published 1025 Articles

Arjun Thakur
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

Arjun Thakur
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

Arjun Thakur
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

Arjun Thakur
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

Arjun Thakur
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

Arjun Thakur
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

Arjun Thakur
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

Arjun Thakur
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

Arjun Thakur
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

Arjun Thakur
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