Managing & Using MySQL

Managing & Using MySQL

《Managing & Using MySQL》是2002年Oreilly & Associates Inc出版的圖書,作者是Reese George。

基本介紹

  • 中文名:Managing & Using MySQL
  • 裝幀:Pap
  • 定價:45.19 美元
  • 作者:Reese George
  • 出版社:Oreilly & Associates Inc
  • 出版日期:2002年4月
  • ISBN:9780596002114
  • 副標題:Open Source SQL Databases for Managing Information & Web Sites
作者簡介,目錄,

作者簡介

George Reese is well known for his superb O'Reilly book, Database Programming with JDBC and Java . He specializes in the development of Internet-oriented Java enterprise systems, and he is the author of the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently works as an enterprise systems architect in Minneapolis. Randy Jay Yarger is a senior solutions developer at US Web/CKS in Southfield, Michigan. He combines expertise in database construction and interaction with extensive knowledge of the Internet to create world-class web applications. Tim King is a software consultant in San Francisco, specializing in database and web technologies.

目錄

Part I Introduction - MySQL - relational databases, the history of MySQL, MySQL design, MySQL features, MySQL applications, what you get; installation - preparation, Unix installation, Windows installation; SQL according to MySQL - SQL basics database creation, table management, MySQL data types, indexing, managing data, queries, SQL operators, advanced features; database administration - configuration server startup and shutdown, logging, backup, recovery, table maintenance and crash recovery. Part II MySQL administration: performance tuning - an approach to performance tuning, application tuning, database server tuning, operating system/hardware tuning; security - database security, system security, application security; database design - database design primer, normalization, a logical data-modelling methodology, physical database design. Part III MySQL programming: database applications - architecture connections and transactions, object/relational modelling; Perl - introduction to DBI, DBI and CGI, a general model for maintainable Perl programs; Python - DB-API, proprietary operations, applied DB-API; PHP - introducing PHP, installing PHP, accessing the MySQL DBMS with PHP, securing user data, managing sessions - writing data with PHP, using the HTML format environment, where to find out more; C API - API overview, the C API in practice, advanced issues; Java - the JDBC API, simple database access, dynamic database access, a guest book servlet; extending MySQL - user-defined functions, alternative character sets. Part IV MySQL reference: SQL syntax for MySQL - basic syntax, SQL commands, MySQL data types, numeric data types string data types, date data types, complex data types; operators and functions - operators, functions; MySQL PHP API reference - data types functions; C reference - data types, functions; the Python DB-API Module - MySQLdb.

相關詞條

熱門詞條

聯絡我們