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 > Properties Device Manager Go to Universal Serial Bus Controller Go 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 device Finally Right click on hardware under the device manager and click the Scan for Hardware Changes Then 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 Id Gender Age Name 1 Male 18 Sam Anderson 2 Female 24 Samoel 3 Male 16 Jamen 4 Male 26 Kamel 5 Female 32 Jami 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

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 Id Gender Age Name 1 Male 18 Sam Anderson 2 Female 24 Samoel 3 Male 16 Jamen 4 Male 26 Kamel 5 Female 32 Jami 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 VALUE

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_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 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_name1 Column_name2 Column_name3 Column_name4 1 Male articles Sam 3 Male coding Jam 4 Male coding Kam 5 Female coding Jam 2 Female Database Sam DESCENDING ORDER   Query : "SELECT * from table_name ORDER BY Column_name3 DESC" If you execute the abo

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_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 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_name1 Column_name2 Column_name3 Column_name4 1 Male articles Sam OR Syntax Example Query : "SELECT *  from table_name WHERE  Column_name3='articles' OR  Column_name3 ='coding'" If you execute the above

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.

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

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_name1 Column_name2 Column_name3 Column_name4 1 Tech articles Sam 2 Mysql database Sam 3 Java coding Jam 4 J2ee coding Kam 5 Hibernate coding Jam 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_name4 Sam Jam Kam

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_name1 Column_name2 Column_name3 Column_name4 1 Tech articles Sam 2 Mysql database Sam 3 Java coding Jam 4 J2ee coding Kam 5 Hibernate coding Jam 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_name1 1 2 3 4 5 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_name1 Column_name3

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 Imporvements Ipad switch between 2G and 3G networks Air Play video playback Sync with Safari bookmarks Unable to purchase fix which comes after the purchase Update iOS device through iTunes 

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.com Click the settings icon (Gear symbol drop down menu) and click setup offline Google docs beta version Click Allow offline docs Click Install from chrome web store Click Add to Chrome That'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 account Account settings > Security's Click 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 disabled Delete your facebook account Login to your facebook account Click this official facebook link(http://www.facebook.com/help/contact.php?show_form=delete_account) in your browser to delete this account Click the delete my account   to delete your facebook account Facebook 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 automat

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 wise Alt + Shift + Tab - Switch between open window in anti clock wise Windows Logo Key + Tab - Windows Flip mode with clock wise Windows Logo Key + Shift + Tab - Window Flip mode with anti clock wise Windows Logo Key + D       - minimized all open windows application and show the desktop Windows Logo Key + Down Arrow - Minimize the window Windows Logo Key + Up  Arrow - Maximize the window Management of Windows Shortcut Windows Logo Key + Right Arrow or Left Arrow - Compare the windows Windows Logo Key + Shift + Right Arrow - Multitask with multiple windows Manage Task Shortcuts Ctrl + Shift + Esc - OPen task manager Windows Logo Key + L - Lock your PC Display Shortcuts Windows Logo Key + P - Presentation  mode Windows Logo Key + Plus Sign or Minus Sign - Zoom in and Zoom ou

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.net Download the zune software for your PC Accept if you agree the terms and conditions > Online installation > Launch Now 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 phone Click update now (Your phone may restart several times during the update) Again

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 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. 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. CD / DVD Burner Save your computer data's into CD / DVD

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 account Visit this - https://accounts.google.com/b/0/IssuedAuthSubTokens?hl=en_GB Connected Sites, Apps and Services Click the revoke access link on each third party site if you wish to cancel That's it. Revoke Third Party Access for Facebook Account First login to your facebook account Visit this -  http://www.facebook.com/settings?tab=applications You have authorized these apps to interact with your Facebook account Click the cancel button to reovke the access That's it. Revoke Third Party Access f