tailieunhanh - Hướng dẫn sử dụng MySQL part 1

Nó không phải là quá dài trước đó bạn đã được đơn giản trong may mắn nếu bạn muốn xây dựng một ứng dụng được hỗ trợ bởi một cơ sở dữ liệu mạnh mẽ trên một ngân sách nhỏ. Lựa chọn của bạn đã được khá đơn giản: hàng ngàn vỏ ngoài hoặc thậm chí hàng chục, hàng trăm ngàn-đô la cho Oracle hoặc Sybase hoặc xây dựng ứng dụng chống lại "đồ chơi" cơ sở dữ liệu như truy cập và FileMakerPro. Nhờ cơ sở dữ liệu như MSQL, ProgreSQL, và MySQL, tuy nhiên, bây giờ bạn có. | DRAFT 8 20 01 1 MySQL It was not too long ago that you were simply out of luck if you wanted to build an application backed by a robust database on a small budget. Your choices were quite simple shell out thousands or even tens or hundreds of thousands of dollars on Oracle or Sybase or build the application against toy databases like Access and FileMakerPro. Thanks to databases like mSQL ProgreSQL and MySQL however you now have a variety of choices that suit different needs. This book of course is the story of MySQL. The History of MySQL This story actually goes back to 1979 when MySQL s inventor Michael Widenius . Monty developed an in-house database tool called UNIREG for managing databases. UNIREG is a tty interface builder that uses a low-level connection to an ISAM storage with indexing. In the years that have followed UNIREG has been rewritten in several different languages and extended to handle big databases. It is still available today but it is largely supplanted by MySQL. The Swedish company TcX began developing Web-based applications in 1994 and used UNIREG to support this effort. Unfortunately UNIREG created too much overhead to be successful in dynamically generating Web pages. TcX thus began looking at alternatives. TcX looked at SQL and mSQL. mSQL was a cheaply available database management system that gave away its source code with database licenses almost Open Source. At the time mSQL was still in its releases and had even fewer features For most of its existence TcX had a single employee Monty. Copyright 2001 O Reilly Associates Inc. 12 DRAFT 8 20 01 than the currently available version. Most important to Monty it did not support any indices. mSQL s performance was therefore poor in comparison to UNIREG. Monty contacted David Hughes the author of mSQL to see if Hughes would be interested in connecting mSQL to UNIREG s B ISAM handler to provide indexing to mSQL. Hughes was already well on his way to mSQL 2 however and had his indexing .