When i try to open my hard drives, it pop ups "open with" window?

This isn't necessarily a virus.

Try this:

Start
Run
Type: regsvr32 /i shell32
Enter

If the problem exists,

Note: In conjunction with the fix suggested in this article, it's highly advisable to follow-up with a thorough Virus/Malware scan. The problem explained in theSymptoms section may be a result of a virus or Malware attack, or may be a remnant in the aftermath of virus or Malware removal.

• Download FixDrive.zip and save it to Desktop
• Unzip the file and extract the contents (FixDrive.exe and readme.txt) to a folder
• Double FixDrive.exe to run it
• Select the drive-letter from the list that's exhibiting the problem
• Click Fix

Screenshot

FixDrive (for Windows XP / Windows Vista)

Note: In case the problem reappears on restart after running this tool, it's possible that there is a Malware actively running in your system. It is suggested that you run a thorough scan using specialized anti-virus and anti-spyware utilities. This utility does not remove the Malware, but only repairs the settings that were probably added by Malware.

GET ALL FIELD NAMES FROM A GIVEN TABLE

To Retrieve All Column names from a given table using Mysql query

There are situation, we need to have retrieve column names associated with particular a particular table. For this so many techniques are available

here is the query

SELECT
COLUMN_NAME
FROM information_schema.COLUMNS
WHERE
table_name ='your table_name';

Here we are using simple select query to return the desired output

what is information schema

INFORMATION_SCHEMA provides access to database metadata. A schema is a database, so the information_schema provides information about databases. Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog.
more...

Here COLUMN_NAME is in the COLUMN associated with information schema.The entire query is direct and simple huh?

regards..