Skip to main content

Posts

Showing posts from May, 2012

USB Device not Recognized : Windows OS

Learn how you can resolve the issue of "USB device is not recognized on windows operating system" .Most of devices are coming with USB connectivity and even some device charge itself with the power of USB.

All you have to do is reset your USB driver settings under the device manager by uninstalling the existing driver and performing the scan for new hardware changes.


Step by Step tutorial

My Computer > Right click > PropertiesDevice ManagerGo to Universal Serial Bus ControllerGo to each port of USB devices > Right Click > Uninstall > Click Ok button but don't check "Delete the driver software for the device"Repeat the same uninstall steps for other port of USB deviceFinally Right click on hardware under the device manager and click the Scan for Hardware ChangesThen windows system will automatically re install all default windows driver.Now plug your device and this time windows will recognize your devices.

Tablet can be used as a computer monitor

Learn how you can use your Android Tablet or iPad as your secondary external monitor for your windows pc or mac pc. To implement this you can download apps from Google play if you have android based tablets and from apple store if you have iOS device but you you don't need to jailbreak or root the device access.

Android Tablet 

Search iDisplay on Google Play or Android Market and download this app for android based tablet or android smart phone to extend your computer monitor or pc screen with your android devices.Its not a free app and its cost around $4.99.

It supports windows and mac pc but not the linux pc.



iOS Tablet
Search DisplayPad on Apple itunes and download this to your iPad to extend your computer monitor or pc screen with your iOS Devices. This app cost around $2.99 in apple itunes market.

Samsung Galaxy S III vs HTC One X vs Sony Xperia S vs Apple iPhone 4S vs Nokia Lumia 800 - Smartphone comparison

A Great comparison of  the most popular smartphone on the market like Samsung Galaxy S III vs HTC One X vs Sony Xperia S vs Apple iPhone 4S vs Nokia Lumia 800 their features and prices in india.

Android   : Galaxy S3, HTC One X, Xperia S Windows : Nokia Lumia  iOS         : iPhone 4s
After the huge success for Galaxy s2 again samsung made Galaxy s3 with more additional features.
AMOLED : Innovation display panels that will be visible even in the sunlights


Update Query example for Mysql Database

Update Query is used to modify the existing record of  table data.Update query can be performed in two ways

1.Multiple row updates
2.Single row update

Example Table : For your reference

Table Name : Human


Human
IdGenderAgeName1Male18Sam Anderson2Female24Samoel3Male16Jamen4Male26Kamel5Female32Jami
The above table name is Human and it has four columns likely named Id, Gender, Age and Name  and it has five rows or records and if you want to modify data then use mysql update query  Syntax
Query : UPDATE table_name SET column_name1=value1,column_name2=value2,...  WHERE column_name3=value3
1.Multiple Row Update- UPDATE QUERY
Query : UPDATE  human SET Age=20  WHERE Gender=Male

After executing the above query 3 records will be update because Gender column has 3 male record data and it is not a primary key column that's why its update multiple record.
Human
Id
Gender
Age
Name
1
Male
20
Sam Anderson
2
Female
24
Samoel
3
Male
20
Jamen
4
Male

INSERT Query Example for Mysql Database

Insert Query is used to create a new record  of data in your database table.Insert query can be performed in two ways

1.Without column names - Quick operation but problem when you add the new table columns
2.With column names- No problem when you add the new table columns

Example Table : For your reference

Table Name : Human



Human
IdGenderAgeName1Male18Sam Anderson2Female24Samoel3Male16Jamen4Male26Kamel5Female32Jami
The above table name is Human and it has four columns likely named Id, Gender, Age and Name  and it has five rows or records and if you want to insert new record then use Mysql Insert query
Syntax
Query : INSERT INTO table_name VALUES ( value1, value2,...)
or
Query : INSERT INTO table_name (Column1,Column2,...) VALUES ( value1, value2,...)
1.Without column names - INSERT QUERY
Query : INSERT INTO human VALUES ( 6, 'Male', 20, 'Blogger')


2.With column names - INSERT QUERY
Query : INSERT INTO human (Id,Gender,Age,Name)  VALUES ( 6, 'Male', 20, 'Blogger'…

ORDER BY Syntax for SELECT Query in MySQL

ORDER BY Syntax in Select Query can be used to arrange the data in Ascending or Descending order.

Example Table : For your reference

table_name
Column_name1Column_name2Column_name3Column_name41MalearticlesSam2FemaledatabaseSam3MalecodingJam4MalecodingKam5FemalecodingJam Table Name is : table_name
ASCENDING ORDER

Query : "SELECT * from table_name ORDER BY Column_name3"

or



Query : "SELECT * from table_name ORDER BY Column_name3 ASC"
If you execute the above query then Column_name3 data will be sorted in ascending order


table_name
Column_name1Column_name2Column_name3Column_name41MalearticlesSam3MalecodingJam4MalecodingKam5FemalecodingJam2FemaleDatabaseSam

DESCENDING ORDER

Query : "SELECT * from table_name ORDER BY Column_name3 DESC"
If you execute the above query then Column_name3 data will be sorted in descending order



table_name
Column_name1Column_name2Column_name3Column_name42FemaleDatabaseSam5FemalecodingJam4MalecodingKam3MalecodingJam1MalearticlesSam



AND & OR Syntax for SELECT Query in Mysql

AND & OR Syntax in Select Query can be used to filter the data from table column with multiple choices.

AND Syntax will show results only when both conditions are true but
OR  Syntax will show results even when one condition is true.

Example Table : For your reference

table_name
Column_name1Column_name2Column_name3Column_name41MalearticlesSam2FemaledatabaseSam3MalecodingJam4MalecodingKam5FemalecodingJam
Table Name is : table_name
AND Syntax Example

Query : "SELECT * from table_name WHERE Column_name3='articles' AND Column_name4='Sam'"
If you execute the above query then the first record will appear 

table_name
Column_name1Column_name2Column_name3Column_name41MalearticlesSam

OR Syntax Example

Query : "SELECT *  from table_name WHERE Column_name3='articles' OR Column_name3='coding'"

If you execute the above query then the records which contains coding and articles from column_name3 will be displayed


table_name
Column_name1Column_name2Colu…

What is Mysql Database ?

Database is used to store the information in a perfect manner so that it can be easily manage the data and can be easily retrieved by filtering it with the help queries.

There are two type of database

1. Relational Database - Human relations like parents and child
2. Flat Database          - Stores on hard disks like text files.

What is Mysql Database?


Mysql Database is a relational database, open source ( free of cost ) and its most popular database that can be used for web application and can be used for dynamic server side application.

Tutorial Index


Select Query in MySQL Database

Distinct Syntax for SELECT Query in Mysql

Where Syntax for SELECT Query in Mysql

AND & OR Syntax for SELECT Query in Mysql

ORDER BY Syntax for SELECT Query in MySQL


INSERT Query Example for Mysql Database

Update Query example for Mysql Database

Where Syntax for SELECT Query in Mysql

Where Syntax in Select Query can be used to filter the data from database.Suppose if you have 100 of data with different gender like male and female but you want the data of all male what you can do?

Simply use mysql select query with where condition to filter the data from table.


Example Table : For your reference



table_name
Column_name1
Column_name2
Column_name3
Column_name4
1
Male
articles
Sam
2
Female
database
Sam
3
Male
coding
Jam
4
Male
coding
Kam
5
Female
coding
Jam

Table Name is : table_name
Query : "SELECT * from table_name WHERE Column_name2='Male'"
If you execute the above query then all female records will disappears from the table data
table_name
Column_name1
Column_name2
Column_name3
Column_name4
1
Male
articles
Sam
3
Male
coding
Jam
4
Male
coding
Kam


Query : "SELECT Column_name3 , Column_name4  from table_name WHERE Column_name2=…

Distinct Syntax for SELECT Query in Mysql

If you have same data on the database table and you want to avoid duplication in your query result then you can use distinct word in mysql query to avoid duplication.

Example Table : For your reference


table_name
Column_name1Column_name2Column_name3Column_name41TecharticlesSam2MysqldatabaseSam3JavacodingJam4J2eecodingKam5HibernatecodingJam
Table Name is : table_name

The table table_name contains four column data but the column_name4 has 2 sam and 2 Jam but i want  to avoid sam and Jam with single results.


Query : "SELECT  DISTINCT Column_name4 from table_name"


If you execute the above query then the duplicate data from Column_name4 will be filtered.

table_name
Column_name4SamJamKam

Select Query in MySQL Database

Select Query in MySQL is used to select data from a database tables. Select Query can be performed with single column, multiple column and all column

Example Table : For your reference


table_name
Column_name1Column_name2Column_name3Column_name41TecharticlesSam2MysqldatabaseSam3JavacodingJam4J2eecodingKam5HibernatecodingJam
Table Name is : table_name
Default Syntax for SELECT Query in Mysql 

Query : "Select column_name1 from table_name"


If you execute the above query then the above table data will be displayed only column_name1


table_name
Column_name112345



Query : "Select column_name1,column_name3 from table_name"


If you execute the above query then the above table data will display column_name1 and column_name3

table_name

Column_name1Column_name31articles2database3coding4coding5coding


Query : "Select *from table_name"


If you execute the above query then the above table data will display all columns because * indicates all column.


table_name
Column_name1Column_name…

iOS 5.1.1 Updates for iPhone, iPad and iPod

Download the latest version of iOS 5.1.1 updates for your iPhone, iPad and iPod Touch devices.

This update comes with powerful improvement after fixing the several bug like

HDR ImporvementsIpad switch between 2G and 3G networksAir Play video playbackSync with Safari bookmarksUnable to purchase fix which comes after the purchase Update iOS device through iTunes 

Direct Download links for the updates from Apple Website



Download links for the updates are listed below:- Third-generation iPad: Wi-FiAT&T/GSMVerizon- iPad 2: Original Wi-FiNew Wi-Fi , AT&T/GSMVerizon/CDMAOriginal iPadiPhone 4S- iPhone 4: GSMCDMAiPhone 3GS- iPod touch: fourth-generationthird-generation
Find the Stolen iOS Device Connect iOS device on Linux Platforms

IRCTC Quick Booking Trick

Preregister your IRCTC reservation form to book the railway tickets immediately. IRCTC (Indian Railway Catering and Tourism Corporation) always begin ticket booking at 8 AM morning .

 If you have speed with keyboard then you can reserve book tickets quickly but what about others who are not having a good speed with keyborad?

Steps for Quick Booking Trick for IRCTC

Before 10 minutes of 8 Am that is exactly 7:50 Am or what ever time before ten minutes visit this website ctrlq.com/irctc  and fill all your reservation details in this form. Once you complete the registration forms click I am Feeling Lucky  button then you will seeing a new button called Magic Auto fillDrag this  Magic Auto fill  button to your browser bookmarkNow Login To IRCTC with your credential and find your train
Proceed to registration form and click  Magic Auto fill link from your Browser bookmarks Automatically it will place all your reservation details into IRCTC reservation form.That's It . Make the payment and g…

Save Gmail Files To Google Drive with one click

One click to Save you Gmail Attachment files into Google Drive. Every-time if you want to save your Gmail attachment then you do most probably clicking the view link from the gmail attachment and then you click the save button to save it into your Google drive but you can do this all stuff with one click.
Install the "Gmail Attachments To Drive" plugin for your chrome browser . Once you installed this plugin to your chrome browser then you will seeing a link called Save To Drive  in all your Gmail Attachments.

Google Drive Offline Access

Learn how you can access your Google Drive data while you don't have internet connection.To implement this setup you need to have internet connection then you don't require internet connection for accessing your Google drive data.

Google Drive offers only 5 GB data but SkyDrive is offering 25 GB free data.

Implementing this Google drive offline setup in your own personal computer is not a problem but if you implement this on public or shared computer then you data might be in risk.


Go to chrome browser Visit drive.google.comClick the settings icon (Gear symbol drop down menu) and click setup offlineGoogle docs beta versionClick Allow offline docsClick Install from chrome web storeClick Add to ChromeThat's It . Now you can access your Google drive in offline mode.

Facebook Account Delete or Deactivate or Reactivate

Facebook is the number one social media networking website. Using facebook is a waste of time and many of you is being addicted with facebook.

Deactivate your facebook account

Login to your facebook accountAccount settings > Security'sClick the Deactivate your account link and also give the reason for leaving and confirm it.Reactivate your facebook account Simply login with your facebook account to reactivate the account which is temporarly disabledDelete your facebook account Login to your facebook accountClick this official facebook link in your browser to delete this accountClick the delete my account  to delete your facebook accountFacebook will give a warning message to confirm it again and confirm it if you really want to delete it.In the next 14 days you dont have to use facebook to complete the facebook account deletion and if you suppose to do then account will automatically reactivate again.

Windows 7 Essential Shortcuts

If you are windows 7 then its must for you to know this essential shortcuts to make your computer life easier.



Manage Windows Shortcuts
Alt + Tab     - Switch between open windows in clock wiseAlt + Shift + Tab - Switch between open window in anti clock wiseWindows Logo Key + Tab - Windows Flip mode with clock wiseWindows Logo Key + Shift + Tab - Window Flip mode with anti clock wise Windows Logo Key + D       - minimized all open windows application and show the desktopWindows Logo Key + Down Arrow - Minimize the windowWindows Logo Key + Up  Arrow - Maximize the windowManagement of Windows Shortcut
Windows Logo Key + Right Arrow or Left Arrow - Compare the windowsWindows Logo Key + Shift + Right Arrow - Multitask with multiple windowsManage Task Shortcuts
Ctrl + Shift + Esc - OPen task managerWindows Logo Key + L - Lock your PCDisplay Shortcuts
Windows Logo Key + P - Presentation  modeWindows Logo Key + Plus Sign or Minus Sign - Zoom in and Zoom outBasic Shortcuts
Windows Logo Key + F - Se…

Nokia Lumia 900 Data Connectivity Problem

Solution for Data connectivity problem with Nokia Lumia 900 for Windows and Mac Platforms.

Nokia itself discovers the data connectivity problem after selling the Windows Nokia phone and also its clearly says the problem with software not with hardware or network.


To Resolve this issue Nokia & Microsoft launched an update and this tutorial will teach you step by step to update to your lumia 900 with latest patch for different platform.
Disclaimer : We are not responsible for the loss of your data, device . Try it on your own risk
Windows Platform

Visit zune.netDownload the zune software for your PCAccept if you agree the terms and conditions > Online installation > LaunchNow plug your Lumia device into the PC via USB (Do not unplug during the update)Follow the Wizard to configure your windows phone Click next so that zune will check is there any update for your phoneClick update now (Your phone may restart several times during the update)Again  Do not unplug your phone during th…

Open Source Application for Windows

Best Open Source Software like File Manager, Notepad Editor, Office Tool, CD/DVD Burner , Photo Editor and  Media player for Windows platform.

File Manager


7zip is the best file manager that supports most file formats compression and extraction technics and specially for 7z file format compression its does 100%.
Supports 79 Languages , Powerful GUI manager and also command line operation
Download Link

Notepad Editor


Notepad ++ is a powerful editor comes with plenty of features that you can't expect in normal windows notepad editor and even you can add plugin to this editor to make more and more powerful.

Notepad++ software written in C++ language so it will use less CPU usage and makes your PC performance more smooth.

Download Link

Office
Day to day use we need office tool like Word, Spreadsheets and Power point for our different purposes. Open office is an open source product from Apache comes with a lot of features.Download Link


CD / DVD Burner

Save your computer data's into CD / D…

Find Local Time of Any City on Google Maps

Find the local time of any city on Google Maps.There is a beautiful app found on internet called Qlock which uses real google maps to dispaly the city name, day, time, am or pm and GMT by your mouse direction.


Just mouse hover to see the the correct time of each time and suppose if you can't locate your city then in the bottom of the website there is an option called Find a city type there and enter it then the app will navigate to it.

This app is also available for iOS Device like iPhone and iPad.

Cancel third party account access from Google , Facebook And Twitter

Learn how you can cancel the third party account access from your Google, Facebook and Twitter.

Many of you when visit a new website simply makes the login with popular site like facebook, google and twitter login to save the time of new registartion but did you think that these third parties can do any thing because they are going to get your full account access with your password.

Revoke Third Party Access for Google Account




First login to your Google accountVisit this - https://accounts.google.com/b/0/IssuedAuthSubTokens?hl=en_GBConnected Sites, Apps and Services
Click the revoke access link on each third party site if you wish to cancelThat's it.Revoke Third Party Access for Facebook Account

First login to your facebook accountVisit this -  http://www.facebook.com/settings?tab=applicationsYou have authorized these apps to interact with your Facebook account
Click the cancel button to reovke the accessThat's it.Revoke Third Party Access for Twitter Account

First login to your twi…