Ankith Reddy has Published 1132 Articles

What is difference between Boolean and tinyint(1) in MySQL?

Ankith Reddy

Ankith Reddy

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

3K+ Views

The basic difference between Boolean and tinyint(1) is only in the naming convention. If we say that we need true or false values then Boolean comes to our mind, instead of tinyint(1). These data types are synonyms. It is up to us which data type we want to use- values ... Read More

How to create a custom listview in android?

Ankith Reddy

Ankith Reddy

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

3K+ Views

Before getting into listview example, we should know about listview, Listview is a collection of items pulled from arraylist, list or any databases. Most uses of listview is a collection of items in vertical format, we can scroll up/down and click on any item.What is custom listview?Custom listview works based ... Read More

Wireless Transmission

Ankith Reddy

Ankith Reddy

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

1K+ Views

In wireless transmission media, data is transmitted in the form of electromagnetic waves that do not require any physical conductors for transmission. The waves are broadcast through free space and any device who has permission to connect can receive them. The three ways in which unguided signals travel are ... Read More

How do I list all the columns in a MySQL table?

Ankith Reddy

Ankith Reddy

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

6K+ Views

To list all columns in a table, we can use the SHOW command. Let us first create a table. mysql> create table ColumnsList -> ( -> id int, -> Firstname varchar(200), -> LastName varchar(100), ... Read More

Enhancing your logging experience with Timber in Android

Ankith Reddy

Ankith Reddy

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

295 Views

Timber library is a extended library of android Log's. While developing android applications, most of developers prefer Android Logs. But here problem is about clean logs while deploy android project. To avoid this process using Timber library.This example demonstrate about how to integrate Timber in android.Step 1 − Create a ... Read More

How to handle fragmentation of auto increment ID column in MySQL?

Ankith Reddy

Ankith Reddy

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

245 Views

Whenever we renumber, there might be a problem. There is a need to declare a unique ID for a column. In MySQL version 5.6 InnoDB, we can reuse the auto_increment ID by including the ID column in an INSERT statement and we can give any specific value that we want. ... Read More

strchr() function in PHP

Ankith Reddy

Ankith Reddy

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

119 Views

The strchr() function is used to search for the first occurrence of a string inside another. Note − This function is case-sensitive. Syntax strchr(str, search, before_search) Parameters str − The string to search search − The string to search for before_search − If TRUE, ... Read More

How do I get the current time zone of MySQL?

Ankith Reddy

Ankith Reddy

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

5K+ Views

The following is the syntax to get the current time zone of MySQL. mysql> SELECT @@global.time_zone, @@session.time_zone; The following is the output. +--------------------+---------------------+ | @@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | SYSTEM | SYSTEM ... Read More

Handler in android ?

Ankith Reddy

Ankith Reddy

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

11K+ Views

We cant touch background thread to main thread directly so handler is going to collect all events which are available in main thread in a queue and posses this queue to looper class.In android Handler is mainly used to update the main thread from background thread or other than main ... Read More

strrchr() function in PHP

Ankith Reddy

Ankith Reddy

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

109 Views

The strrchr() function is used to find the last occurrence of a character in a string. Syntax strrchr(str, char) Parameters str − The string to search char − The character to find in the string. If char contains more than one character, then only the ... Read More

Advertisements