bookstore_mysql.sql

一个简单的网上书店例子

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Programming Perl (3rd Edition)', 'Larry Wall, Tom Christiansen, Jon Orwant', 39.96, 'http://www.amazon.com/exec/obidos/ASIN/0596000278/yessoftware', 'images/books/0596000278.jpg', 'Perl is a powerful programming language that has grown in popularity since it first appeared in 1988. The first edition of this book, Programming Perl, hit the shelves in 1990, and was quickly adopted as the undisputed bible of the language. Since then, Perl has grown with the times, and so has this book.
Programming Perl is not just a book about Perl. It is also a unique introduction to the language and its culture, as you might expect only from its authors. Larry Wall is the inventor of Perl, and provides a unique perspective on the evolution of Perl and its future direction. Tom Christiansen was one of the first champions of the language, and lives and breathes the complexities of Perl internals as few other mortals do. Jon Orwant is the editor of The Perl Journal, which has brought together the Perl community as a common forum for new developments in Perl. ', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Perl and CGI for the World Wide Web: Visual QuickStart Guide', 'Elizabeth Castro', 15.19, 'http://www.amazon.com/exec/obidos/ASIN/020135358X/yessoftware', 'images/books/020135358X.gif', 'Taking a visual approach, this guide uses ample screen stills to explain the basic components of Perl, and show how to install and customize existing CGI scripts to build interactivity into Web sites.', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(2, 'MySQL (OTHER NEW RIDERS)', 'Paul DuBois', 39.99, 'http://www.amazon.com/exec/obidos/ASIN/0735709211/yessoftware', 'images/books/0735709211.jpg', 'In MySQL, Paul DuBois provides you with a comprehensive guide to one of the most popular relational database systems. As an important contributor to the online documentation for MySQL, Paul uses his day-to-day experience answering questions users post on the MySQL mailing list to pinpoint the problems most users and administrators encounter.', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'PHP and MySQL Web Development', 'Luke Welling, Laura Thomson', 39.99, 'http://www.amazon.com/exec/obidos/ASIN/0672317842/yessoftware', 'images/books/0672317842.jpg', 'PHP3 and MySQL Web Development introduces you to the advantages of implementing both MySQL and PHP3. These advantages are detailed through the provision of both statistics and several case studies. A practical web application is developed throughout the book, providing you with the tools necessary to implement a functional online database. Each function is developed separately, allowing you the choice to incorporate only those parts that you would like to implement. Programming concepts of the PHP3 language are highlighted, including functions which tie MySQL support into a PHP3 script and advanced topics regarding table manipulation.', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'MySQL & PHP From Scratch', 'Wade Maxfield', 23.99, 'http://www.amazon.com/exec/obidos/ASIN/0789724405/yessoftware', 'images/books/0789724405.jpg', 'Apache, MySQL, PHP3, and IMP the pieces exist. Each piece has been described ad nauseam. What does not exist is a guide to the marriage of these software technologies into a useful book, until now. This book puts together information on installing, setting up, and troubleshooting each of these technologies into one complete volume. You also learn how each piece is part of a whole by learning, step-by-step, how to create a web-based e-mail system. Learn to run the Linux equivalent of Active Server Pages (ASP) using PHP3, set up an e-commerce site using a database and the Apache web server, and create a data entry system (such as sales, product quality tracking, customer preferences, etc) that requires no installation in the PC.', 1);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(2, 'MySQL and mSQL', 'Randy Jay Yarger, George Reese, Tim King', 27.96, 'http://www.amazon.com/exec/obidos/ASIN/1565924347/yessoftware', 'images/books/1565924347.jpg', 'MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and UNIX systems. Both products are free for non-profit use and cost a small amount for commercial use. 

Even a small organization or Web site has uses for a database. Prehaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your Web site''s visitors for their interests and preferences and put up a fresh Web page that tallies the results. 

Unlike commercial databases, MySQL and mSQL are affordable and easy to use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with your database. In addition, you can embed queries and updates right in an HTML file so that a Web page becomes its own interface to the database.', 1);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(3, 'Flash 4 Magic (WITH CD-ROM)', 'David J. Emberton, J. Scott Hamlin, David Emberton', 36, 'http://www.amazon.com/exec/obidos/ASIN/0735709491/yessoftware', 'images/books/0735709491.jpg', 'Flash has moved beyond Java and even Shockwave because it''s inexpensive, accessible, and powerful. If you need a specific Flash solution or you learn best by getting your hands dirty, the project-based Flash 4 Magic will work well for you. The authors have assembled 15 utilities-based projects (a calculator and an online book search animation, for example) and six games (one of which is a memory/match game similar to those found all over the Web these days). Each project is presented step by step and includes text and complementary screen shots. At the end of each lesson, a "How It Works" section gives insight into the software mechanisms and serves as a review. A brief discussion of how the project can be modified to fit the readers'' needs follows. All the files, libraries, images, and even finished Flash .fla files and .swf movies are provided on the accompanying CD-ROM, helping readers follow along and debug their multimedia experiments.', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Web Application Development with PHP 4.0 (with CD-ROM)', 'Tobias Ratschiller, Till Gerken', 36, 'http://www.amazon.com/exec/obidos/ASIN/0735709971/yessoftware', 'images/books/0735709971.jpg', 'PHP is an open-source Web scripting language that''s gaining steam in the development community, especially in the Apache Web server realm. With a syntax that draws heavily on C, PHP appeals to advanced programmers who are moving to the Web from traditional software development.
Web Application Development with PHP 4.0 isn''t your run-of-the-mill language tutorial. Authors Ratschiller and Gerken purposely designed its content to appeal to coders who already are proficient in PHP, but in need of advanced programming techniques and high-level application-development skills. Assuming a strong programming foundation, this book can be considered a next-level PHP tutorial.', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(2, 'Beginning ASP Databases', 'John Kaufman, Thearon Willis, David Buser, Kevin Spencer, kauffman, John Kauffman', 39.99, 'http://www.amazon.com/exec/obidos/ASIN/1861002726/yessoftware', 'images/books/1861002726.jpg', 'As a tutorial, Beginning ASP Databases offers an entry point to one of the most crucial aspects of Microsoft-oriented Web development--database integration with Active Server Pages. In Beginning ASP Databases, a trio of authors covers the basics of working with databases from ASP--especially using ActiveX Database Objects (ADO).
The book is quite substantive in content but is written in a somewhat light-hearted style that makes readers new to the technology comfortable. The authors begin with a discussion of the benefits of ASP and ADO, and then explain how to configure the technology on the various flavors of Windows. From there, they show how to access databases using ADO, demystify how it all works, and focus on several key areas, including debugging, SQL, and stored procedures.', 1);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(2, 'Oracle8i Web Development', 'Bradley D. Brown, Brad Brown', 41.99, 'http://www.amazon.com/exec/obidos/ASIN/0072122420/yessoftware', 'images/books/0072122420.jpg', 'Although this title doesn''t include the "Tips & Techniques" label like some of the other Oracle Press installments do, it falls into that category. Oracle8i Web Development is a collection of diverse overviews, specific techniques, and recommendations for the wide range of interrelated Oracle tools for creating professional Web applications.
This is not a start-to-finish tutorial but rather a tool for developers already familiar with the Oracle architecture and Oracle Application Server (OAS). It is fast moving, with targeted discussions of issues ranging from hardware preparations to HTML/JavaScript/XML coding to miscellaneous development tools. There are plenty of useful tidbits in here for experienced Oracle Web coders, but those newer to the technology platform will likely find the presentation a bit choppy.

One of the most useful sections of this book is its coverage of the WebServer Generator and Oracle Designer packages. Here the reader will learn about the generated procedures and the WebServer Generator''s key preferences. Other key chapters on Perl and Java are also useful, albeit rather brief.

An appendix of useful reference Web sites does a good job of rounding out this utilitarian guide. While this title is primarily a compendium of key information and not a comprehensive manual for Web site development, it ties together content about various products that isn''t usually found in a single source. --Stephen W. Plain', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Black Belt Web Programming Methods; Servers, Security, Databases and Sites', '', 27.96, 'http://www.amazon.com/exec/obidos/ASIN/0879304979/yessoftware', 'images/books/0879304979.gif', 'Use this book to build a robust infrastructure for powerful Web sites. Master programmers who write for Web Techniques, Dr. Dobb''s Journal, Interactivity, Data Base Management Systems, Network, and Software Development have joined forces to tackle the latest round of web programming puzzles for you. Learn airtight security procedures and hypertext transaction designs. Build databases that are easy to use. Whether you need to create distributed objects or automate Web site maintenance, these seasoned programmers explain how to do it right, and they give you the code to do the job. The companion code disk includes detailed, reusable code for each of the applications presented. Programming languages include C/C++ and Java. The book''s four main sections (Servers, Sites, Databases, and Security (illustrate generic techniques for web configuration management and for server performance tuning. You''ll learn time-saving new tips to use with database servers and applications, high performance graphics, security options, and transaction encryption.', 1);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Web Development with Java Server Pages', 'Duane K. Fields, Mark A. Kolb', 35.96, 'http://www.amazon.com/exec/obidos/ASIN/1884777996/yessoftware', 'images/books/1884777996.jpg', 'Dynamic content-personalized, customized, and up-to-the-minute-is a key component of site development on the World Wide Web today. Java Server Pages (JSP) is a new server-side technology for generating dynamic content in Web pages and other on-line applications. This guide to JSP covers all aspects of development and includes comparisons to similar dynamic content systems such as CGI, Active Server Pages, Cold Fusion, and PHP. Included is a discussion of the use of component centric design via Java Beans and custom tag libraries for separating the presentation of dynamic data (the layout, look, and feel) from its implementation (the code that generates it).', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Professional Java Server Programming J2EE Edition', 'Wrox Multi Team', 47.99, 'http://www.amazon.com/exec/obidos/ASIN/1861004656/yessoftware', 'images/books/1861004656.jpg', 'Rather than a simple update of the existing Professional Java Server Programming book, the J2EE edition represents an evolution of the content to reflect the changing state of server-side Java development. Whereas the first edition can be seen as an introduction to Java on the server, the new edition is a more tightly integrated vision of how to combine the Java technologies to develop n-tier applications in Java based primarily around J2EE. Since the release of the first edition in the fall of ''99, probably the single most significant change in the Java server-side landscape has been the release of the Java 2 Platform, Enterprise Edition (J2EE). Although we covered many of the elements of J2EE in the first edition of the book, many things have changed.
J2EE represents a serious attempt by Sun to make Java not just a viable language, but more importantly a viable platform for enterprise development. This book is about how to use Java for enterprise development, using the J2EE runtime architecture. 
Wide range of technologies including: J2EE, RMI, JDBC, JNDI, LDAP, XML, XSLT, Servlets, JSP, EJB, JMS, JavaMail, CORBA, Performance, Scalability, Unit Testing, and Debugging 
Benefits and limits of the typical real-world vendor implementations of the J2EE specification 
The resulting practical aspects of real-word design using the J2EE technologies', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Mastering ColdFusion 4.5', 'Arman Danesh, Kristin Aileen Motlagh, Kristin Motlagh', 39.99, 'http://www.amazon.com/exec/obidos/ASIN/0782127738/yessoftware', 'images/books/0782127738.jpg', 'Allaire''s ColdFusion is one of the most robust server-side scripting solutions for Web developers, offering the notable advantage of cross-platform deployment. Mastering ColdFusion 4.5 is a comprehensive exploration of this powerful product that makes migration to the language quick and first exposure to server-scripting easy to follow.
With more than 1000 pages, this book provides a step-by-step education in ColdFusion and plenty of examples for hands-on learning. The first chapters immediately give the reader a feel for how ColdFusion templates interact with HTML. Then the text steps back to begin presenting more details systematically. One of ColdFusion''s key features--database interaction with the CFQUERY tag and SQL--is addressed early on with simple examples.
Once it hooks the reader on the power of ColdFusion, the book illustrates the product''s flexibility in dealing with e-mail, FTP, LDAP servers, and custom tags. It goes on to cover the ColdFusion Studio integrated-development environment--though not in depth. The real focus of this book is how the ColdFusion language works.
Developers familiar with other scripting environments such as Microsoft Active Server Pages will immediately feel at home with the subject matter and quickly move through this hefty book. Those with only HTML knowledge will find all the details they need to learn about server-side scripting and may only need a supplemental study of SQL.', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Teach Yourself ColdFusion in 21 Days (Teach Yourself -- 21 Days)', 'Charles Mohnike', 31.99, 'http://www.amazon.com/exec/obidos/ASIN/0672317966/yessoftware', 'images/books/0672317966.jpg', 'Sams Teach Yourself ColdFusion in 21 Days quickly empowers you to create your own dynamic database-driven Web applications using Allaire''s ColdFusion. Using client-proven methods, and the success of his popular ColdFusion tutorial for Wired, expert author Charles Mohnike provides you with an understanding of the ColdFusion Server and guides you through the use of the ColdFusion Studio, enabling you to create your own ColdFusion applications quickly and easily. Topics such as installing and configuring the ColdFusion Server, working with the ColdFusion Studio, working with SQL, optimizing your datasource, understanding templates and ColdFusion Markup Language (CFML), using ColdFusion tags, manipulating data, creating e-commerce solutions with ColdFusion, and debugging ColdFusion applications.', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'ColdFusion Fast & Easy Web Development', 'T. C., III Bradley', 19.99, 'http://www.amazon.com/exec/obidos/ASIN/0761530169/yessoftware', 'images/books/0761530169.jpg', 'Allaires ColdFusion is a powerful solution for developers wanting to build secure, scalable, and manageable Web applications. ColdFusion Fast & Easy Web Development takes a visual approach to learning this Web application server. It combines easy-to-understand instructions and real screen shots for a truly unique learning experience. This book covers topics from ColdFusion basics to retrieving data to building dynamic queries and applications with ColdFusion. The innovative, visual approach of the Fast & Easy Web Development series provides a perfect format for programmers of all levels.', 0);

insert into items (category_id, name, author, price, product_url, image_url, notes, is_recommended)
       values(1, 'Beginning Active Server Pages 3.0', 'David Buser, Chris Ullman, Jon Duckett