【文章內(nèi)容簡介】 4]　　(第五版)[M].北京:清華大學(xué)出版社，2008：11~215[5]　　王珊，(第四版)[M].北京：高等教育出版社，2007：16~265[6]　　Rasmus Lerdorf,Kevin PHP[M].O＇Reilly Media，2006：11~281[7]　　陳湘揚(yáng)，+MySQL網(wǎng)頁系統(tǒng)開發(fā)設(shè)計(jì)[M].北京：電子工業(yè)出版社，2007：22~327[8]　　[M].北京：清華大學(xué)出版社，2007：48~537[9]　　:Apache+PHP+MySQL[J].計(jì)算機(jī)工程與設(shè)計(jì)，2007年04期：32~167[10]　　[美] amp。 MySQL Programming Design(第3版)[M].北京：人民郵電出版社，2009：10~620致　　謝我四年的大學(xué)生活即將結(jié)束，帶著不舍和好奇即將走進(jìn)另一種生活。畢業(yè)設(shè)計(jì)和論文的順利完成多虧劉海博老師的悉心教導(dǎo)和身邊同學(xué)的熱心幫助。在此向劉海博老師和幫助過我的同學(xué)們表示真誠的謝意。我還要感謝傳授我知識(shí)的老師，你們傳授了我知識(shí)的同時(shí)教會(huì)了我為人處世的道理。感謝這所大學(xué)——我的母校，你使我走上社會(huì)更有勇氣，更多一份堅(jiān)持。在即將畢業(yè)的時(shí)刻，我還要謝謝我的父母，是你們的愛護(hù)和照顧，我才能健康的長大，也是你們的關(guān)心和支持，我才能順利走過生活遇到的坎坷。最后，再次向幫助過我的老師和同學(xué)們表示衷心的感謝。附　　錄MySQL HistoryMySQL history goes back to 1979 when Monty Widenius, working for a small panycalled TcX, created a reporting tool written in BASIC that ran on a 4 Mhzputer with 16 KB RAM. Over time, the tool was rewritten in C and ported to run on Unix. It was still just a lowlevel storage engine with a reporting front end. The tool was known by the name of Unireg.Working under the adverse conditions of little putational resources, and perhaps building on his Godgiven talent,Monty developed a habit and ability to write very efficient code naturally. He also developed, or perhaps was gifted from the start,with an unusually acute vision of what needed to be done to the code to make it useful in future development—without knowing in advance much detail about what that future development would be.In addition to the above, with TcX being a very small pany and Monty being one of the owners, he had a lot of say in what happened to his code. While there are perhaps a good number of programmers out there with Monty’s talent and ability, for a number of reasons, few get to carry their code around for more than 20 years. Monty did.Monty’s work, talents, and ownership of the code provided a foundation upon which the Miracle of MySQL could be built.Some time in the 1990s, TcX customers began to push for an SQL interface to their data. Several possibilities were considered. One was to load it into a mercial was not satisfied with the speed. He tried borrowing mSQL code for the SQL part and integrating it with his lowlevel storage engine. That did not work well,either. Then came the classic move of a talented,driven programmer: “I’ve had enough of those tools that somebody else wrote that don’t work! I’m writing my own!”Thus in May of 1996 MySQL version was released to a limited group, followed by a public release in October 1996 of version . The initial public release provided only a binary distribution for Solaris. A month later, the source and the Linux binary were released.In the next two years, MySQL was ported to a number of other operating systems as the feature set gradually increased. MySQL was originally released under a special license that allowed mercial use to those who were not redistributing it with their software. Special licenses were available for sale to those who wanted to bundle it with their product. Additionally, mercial support was also being sold. This provided TcX with some revenue to justify the further development of MySQL,although the purpose of its original creation had already been fulfilled.During this period MySQL progressed to version . It supported a decent subset of the SQL language, had an optimizer a lot more sophisticated than one would expect could possibly be written by one person, was extremely fast, and was very APIs were contributed, so one could write a client in pretty much any existing programming language. However, it still lacked support for transactions,subqueries, foreign keys, stored procedures, and views. The locking happened only at a table level, which in some cases could slow it down to a grinding halt. Some programmers unable to get around its limitations still considered it a toy, while others were more than happy to dump their Oracle or SQL Server in favor of MySQL, and deal with the limitations in their code in exchange for improvement in performance and licensing cost savings.Around 1999–2000 a separate pany named MySQL AB was established. It hired several developers and established a partnership with Sleepycat to provide an SQL interface for the Berkeley DB data files. Since Berkeley DB had transaction capabilities,this would give MySQL support for transactions, which it previously some changes in the code in preparation for integrating Berkeley DB,version was released.Although the MySQL developers could never work out all the quirks of the Berkeley DB interface and the Berkeley DB tables were never stable, the effort was not a result, MySQL source became equipped with hooks to add any type of storage engine, including a transactional one.Version was released as alpha in April of 2003, and was declared beta in June of 2004. Unlike version , it added a number of significant improvements. Perhaps the most significant was subqueries, a feature longawaited by many users. Spatial indexing support was added to the MyISAM storage engine. Unicode support was implemented. The client/server protocol saw a number of changes. It was made more secure against attacks, and supported prepared statements.In parallel with the alpha version of , work progressed on yet another development branch: version , which would add stored procedures, serverside cursors,triggers, views, XA transactions, significant improvements in the query optimizer,and a number of other features. The decision to create a separate development branch was made because MySQL developers felt that it would take a long time to stabilize if, on top of all the new features that they were adding to it, they had to deal with the stored procedures. Version was finally released as alpha in December 2003. For a while this created quite a bit of confusion—there were two branches in the alpha stage. Eventually stabilized (October 2004), and the confusion was resolved.Version stabilized a year later, in October of 2005.The first alpha release of follow