MySQL and mSQL
著者
書誌事項
MySQL and mSQL
O'Reilly, 1999
- タイトル別名
-
MySQL & mSQL
大学図書館所蔵 件 / 全4件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
Includes index
内容説明・目次
内容説明
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. Perhaps 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. This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material.
Topics include: Introductions to simple database design and SQL Building, installation, and configuration Basic programming APIs for C, C++, Java (JDBC), Perl, and Python CGI programming with databases in C and Perl Web interfaces: PHP, W3-mSQL, Lite, and mSQLPerl
目次
Preface. I. Getting Started with MySQL and mSQL 1. Introduction to Relational Databases What Is a Database? What Is a Relational Database? Applications and Databases MySQL and mSQL. 2. Database Design Database Design Normalization A Logical Data Modeling Methodology Physical Database Design. 3. Installation MySQL mSQL. 4. MySQL Design Installing MySQL Running MySQL Database Administration MySQL Utilities Performance Tuning. 5. mSQL Design mSQL Versions Installing mSQL Running mSQL Database Administration mSQL Utilities. 6. SQL According to MySQL and mSQL SQL Basics Creating and Dropping Tables SQL Datatypes Indices Sequences and Auto-Incrementing Managing Data Queries Extended Functionality. 7. Other Mid-Range Database Engines What Is "Free"? What MySQL and mSQL Lack PostgreSQL GNU SQL Beagle Making Comparisons II. Database Programming. 8. Database Application Architectures The Client/Server Architecture Data Processing Object/Relational Modeling The Three-tier Architecture. 9. CGI Programming What Is CGI? HTML Forms The CGI Specification Important Considerations for CGI Scripts CGI and Databases. 10. Perl DBI An Example DBI Application Msql.pm MysqlPerl. 11. Python Basic Connectivity Dynamic Connectivity 12. PHP and Other Support for Database-driven HTML Alternatives for Dynamic Content on the Web W3-mSQL PHP Embedded Perl. 13. C and C++ The Two APIs Object-oriented Database Access in C++. 14. Java and JDBC What Is JDBC? Simple Database Access Dynamic Database Access A Guest Book Servlet. III. Reference. 15. SQL Reference MySQL SQL mSQL SQL. 16. MySQL and mSQL System Variables MySQL System Variables mSQL System Variables. 17. MySQL and mSQL Programs and Utilities MySQL Utilities mSQL Utilities. 18. PHP and Lite Reference PHP Lite. 19. C Reference MySQL C API mSQL C API. 20. Python Reference Module: MySQL Module: mSQL. 21. Perl Reference Installation DBI.pm API Msql.pm API Mysql.pm API. 22. JDBC Reference Index.
「Nielsen BookData」 より