Skip to main content

Posts

Showing posts from August, 2016

Cheap Tourist boat service in Alapuzha - Enjoy the beauty of Aleppey Back waters using govt owned Tourist boat services

Feasible Tourist boat services in Alapuzha
Aleppey / Alappuzha is one of the beautiful places in kerala. Aleppey district is famous for it amazing backwaters , you can enjoy house boat rides here. Kerala State Water transport department  (Kerala SWTD) provides facilities for tourists to enjoy the beauty of backwater by paying much less charge when compared to private boat services.There are boat services from Aleppey boat station which takes tourists to inner parts of the backwaters.

How to change SBI ATM Debit card Pin Number?

Follow the below given steps to Change your  SBI ATM / Debit Card PIN number online.

If you find any suspicious transactions happening with your SBI ATM / Debit card, first thing you have to do is block your ATM card. It is recommended to change your ATM card Pin number once in a while. Never disclose your pin number to others nor save it on your phone or email.


Take www.onlinesbi.com in your web browserlogin using your username and passwordOn the user home page, click on the e-Services tab on top menuOn left menu click on ATM Card ServicesForm the listed choices, click  on ATM Pin Generation

How to block your SBI ATM cum Debit Card

If your SBI card is lost or you feel like some unauthorized transactions happening, then first thing you have to do is block your  SBI ATM cum Debit Card

Follow the below given steps to block your  SBI ATM / Debit Card online.

Your SBI Debit card ending with XX0000 is deactivated only for Internet txn.

SBI account holders may have received an SMS with following message, supposed to be from State Bank of India (SBI).

Your SBI Debit card ending with XX0000  is deactivated only for Internet txn. To activate send SMS "SWON ECOM 0000" to 09223966666. No change for ATM/POS usage
** Replace the four Zeros with last 4 digits of your debit card number

Recently many of the SBI account holder has losed their money due to a hi-tech ATM robbery which happened in Thiruvananthapuram, capital city of Kerala.

MySQL Query to retrive all field names which belongs to a particular data type

MySQL Query to get the column names which are of a particular data type

To accomplish this , you should be familiar with how the data types are declared in the information schema table of the DB. To know the Data type name just run this query on your PHP admin or MySql Client:

SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'YOUR_DATABASE_NAME' AND TABLE_NAME = 'YOUR_TABLE_NAME'

This will return the result like:

COLUMN_NAME | DATA_TYPE
-----------------------------
Field1 | int
Field2 | int
Field3 | varchar
Field4 | text
Field5 | longtext
Field6 | float

So we will be keep the above query as the base and will add condition " AND DATA_TYPE = 'DATA_TYPE_NAME' ".



MySQL Query to get all fields in a table which are of Type INTEGER

SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'YOUR_DATABASE_NAME' AND TABLE_NAME = 'YOUR_TABLE_NAME'
AND DATA_TYPE = &#…


Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »
Member
Search This Blog