Comparison between reading excel Data and mysql database data (1)-win environment preparation, mysql-win

Comparison between reading excel Data and mysql database data (1)-win environment preparation, mysql-win

To operate excel and mysql, you must first install python, and then install the excel and mysql plug-ins;

Step 1 install python;

Search Baidu directly and download and install it.

Step 2 install the excel plug-in;

First download the plug-in at http://pypi.python.org/pypi/xlrdnet;

Because this website is slow to open (a common problem in China), you can download it from my online Disk: Download

After downloading, decompress the package to a fixed directory, for example, decompress it to d: \ excel.

Then press ctrl + c to open and run cmd to enter the decompressed directory (disk c is used by default, and disk d can be entered directly :)

Go to the extract Directory: d: \ excel \ xlrd-0.9.4 directory. Run python setup. py install to install python.

Step 3 install the mysql plug-in;

Official Website: http://dev.mysql.com/downloads/connector/python/:download

After the download, you only need to proceed to the next step, which is very simple.

Finally, how can I determine whether the excel and mysql plug-ins have been successfully installed and open the IDLE environment directly.

Enter import pymysql, xlrd

If no error is reported, the installation is successful.

At this point, the preliminary environment is ready.

Continue next time