Export MySQL Table to a CSV File

SELECT * FROM DatabaseName.DesireTable
INTO OUTFILE 'd:\\output.csv' 
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

Microsoft WebMatrix 2

WebMatrix is a free and lightweight web development tool. Create, publish, and maintain your website with ease... more

Capturing Mouse Wheel event in C#

Microsoft chose not to display the MouseWheel event in the Event box. However, it is easy to hook it through the editor.

In the constructor of the Form / custom control, type - "MouseWheel+=", and press TAB twice. Once for completing the statement, and again to insert the handler in the class.

to catch the wheel rotation, if the value of e.Delta >0 then it scrolls up and if the value of e.Delta <0 then it scrolls down:

if (e.Delta < 0)
    x--;
else
    x++;

TeamViewer

TeamViewer connects to any PC or server around the world within a few seconds. You can remote control your partner's PC as if you were sitting right in front of it... more

Create Duplicate Table in MySQL

MySQL provides many methods to create duplicate table with its data or without its data. The following is a simple example to create a duplicate table along-with data of the original table:

CREATE TABLE new_table_name SELECT * FROM old_table_name; 

An important point to note is that this query will not create column attributes and indexes as defined in the original table.

If you also want to have such attributes, this can be done with another easy way. Below queries will create a copy of the original table with all its constraints and attributes and also insert entire data from the original table to the new on:

CREATE TABLE new_table_name LIKE old_table_name;

INSERT INTO new_table_name SELECT * FROM old_table_name;

Access To MySQL

Access to MySQL is a small program that will convert Microsoft Access Databases to MySQL... more

Web Standards Update For Visual Studio 2010 and Activating HTML5/CSS3 intellisense/validation

Web Standard Update for Visual Studio 2010
Web Standards Update provides the much wanted HTML5 & CSS3 support to Visual Studio 2010 SP1. It brings VS 2010 intellisense & validation as close to W3C specification as we could get via means of an extension... more

Activating HTML5/CSS3 intellisense/validation for Visual Studio 2010
VS2010 was originally released without HTML5 support with VS2010 SP1 to some extend. The entire HTML5 specification isn’t supported but most of the new elements and attributes are. That means you get both intellisense and validation for HTML5 with SP1... more