A wonderful competition in the Windows environment for MySQL Databases

This article mainly tells you about the MySQL database in Windows. It is the reason for a wonderful competition. We all know that the usage of MySQL database is getting wider and wider, what is the situation of MySQL database in Windows?

This morning, a blog from Gerardo Narvaja, a senior sales expert from the MySQL database user Seminar

In Bruam's article, he used a metaphor to compare the competition between Microsoft and MySQL (the best combination with PHP) to a "wonderful and beautiful competition ", it is also called jogo bonito as Brazilians like to say ". Next, I will try to illustrate the entire situation. I will be based on his speech http://www.MySQL (the best combination of PHP and MySQL) at the Conference on user discussion (the best combination of PHP) conf.com/cs/MySQL (the best combination of PHP) uc2007/view/e_sess/13874.

Status quo: Do you often want to know whether the neat and huge electronic data tables can be quickly imported into the database for query and data operations outside of the Excel function? Or, how many times have we initially used Excel as a prototype to provide solutions to existing problems? But now we need to recreate the database to start developing our own applications?

Q: To illustrate this problem, I chose to use the data generated by the Nike + iPod attachment. The data is stored in the iPod File System in xml (standardization is getting closer and closer) format and can be easily imported to Excel. In order to make the problem simple, I only extracted some data and did not convert fields into enough data types. Please refer to the architecture at the end of the article ). At the same time, I skipped the data import steps to simplify the process. After all, there are many such examples on the Internet.

Solution: The following are a series of steps to quickly convert a simple Excel table to an actual database using Microsoft and MySQL Databases in Windows. This document assumes that the DSN for connecting to MySQL (the best combination with PHP) has been configured. Otherwise, please check the relevant articles on the Port25 website and continue with the subsequent content.

1) First, we see a table. Its first line shows the names of the fields corresponding to each column, and then each row in a row is the values corresponding to each field. (Best combination with PHP): Figure 1 of a wonderful and beautiful competition) "width =" 450 "height =" 189 "/>

2) ensure that the MySQL (best combination with PHP) server has run and enabled the system tray monitor of the MySQL (best combination with PHP) tool.

3) convert the Data range to a List using the menu Data à List à Create List and save the workbook.

4) Start Access, import an Excel worksheet from the menu File à Open, and enter the form name. After completing these steps, various options for creating a database table will appear in the Link Spreadsheet Wizard (Link Form Wizard. (The best combination with PHP): a wonderful and beautiful game, Fig 2) "width =" 450 "height =" 361 "/>

5) Go to File à Export to Export the database to MySQL (the best combination with PHP), and select ODBC Databases from the drop-down menu.

6) in the Machine Data Source, select the correct DSN to connect to the MySQL (the best combination with PHP) server. If Access cannot identify the correct primary key value, it will report an error message. You can ignore it. (The best combination with PHP): Figure 3 of a wonderful game. "width =" 450 "height =" 396 "/>

7) you can use a browser in the MySQL database toolbox to create the required primary key value. (Best combination with PHP): a wonderful and beautiful match "width =" 450 "height =" 203 "/>

8. You still need to use this browser to ensure that all data is cleared. This is because the last row of the list in Excel may contain all the items that are empty, So delete them if they exist.

9. Finally, open a created database table, and you can use Access and ODBC to select a data subset and form. The page is used to create a query and edit data and reports.

At the beginning, the data complexity will not exceed 30 minutes. The next step is to normalize the database and expand the database architecture. You can use Access to quickly develop concept-based prototypes. At the same time, MySQL (the best combination with PHP) servers can also pass. . NET connector.

Conclusion: most of the time, we usually use a set of data to describe the problem when developing IT solutions. Using the Microsoft tool described above, you can easily describe the database data and quickly create a necessary tool to solve the problem. Using MySQL (the best combination with PHP) server and MySQL database tools, you can create a customer/Server backend to convert the initial database prototype into a final solution. All these operations are completed in Windows.