作者：Marc Delisle
出版日期：March 13, 2009
出版社：其它
页数：352
ISBN：ISBN-10: 1847197868 ISBN-13: 978-1847197863
文件格式：PDF


Product Description
Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1Covers version 3.1, the latest version of phpMyAdminAdminister your MySQL databases with phpMyAdminManage users and privileges with MySQL Server Administration toolsGet to grips with the hidden features and capabilities of phpMyAdminIn Detail
MySQL has gained wide popularity because of its open-source nature,performance, reliability, robustness, and support for various platforms.
phpMyAdmin is a web-based front-end to manage MySQL databases andhas been adopted by a number of open-source distributors. It is one ofthe most widely used open-source applications written in PHP.phpMyAdmin supports a wide range of operations with MySQL. Currently,it can create and drop databases, create/drop/alter tables,delete/edit/add fields, execute any SQL statement, manage keys onfields, manage privileges, export data into various formats and isavailable in 52 languages. The powerful graphical interface of version3.1 has made phpMyAdmin an indispensable tool for MySQL and webdevelopers.
This is the first book that covers version 3.1, the latest versionof phpMyAdmin. It has been fully updated from the previous version thatcovered phpMyAdmin Version 2.11. It is a comprehensive guide tounlocking the full potential of phpMyAdmin. It builds a solidunderstanding of the core capabilities of phpMyAdmin before walking youthrough every facet right from showing you how to set up and manage thedatabase with clear, step-by-step instructions and screenshots toexploring the less well known and generally under-used features andcapabilities of phpMyAdmin in depth. Along the way you’ll build a moredetailed understanding of SQL and how it works in MySQL.
Whether you are an experienced developer, system administrator, webdesigner or new to MySQL and phpMyAdmin, this book will show you how toincrease your productivity and control when working with your MySQL.
What you will learn from this book?
Administer MySQL users and get statistics about MySQL servers and databasesCreate better database tables and relational structuresGenerate multiple SQL queries and build a more detailed understanding of SQL and its workingsPrepare better documentation of evolving table structuresManage databases, table data and structures, and indexes to create efficient databasesLearn the different mechanisms involved in importing SQL and CSV filesExamine the modified behavior of phpMyAdmin to use the outstanding application to its full powerPerform day-to-day database and table management effectively with the new interface to ease your workApproach
The book is a step-by-step tutorial for phpMyAdmin explaining anddemonstrating the potential of this tool with clear instructions andscreenshots. After covering installation and basic features ofphpMyAdmin it goes on to show its less well known and generallyunder-used features and capabilities.
Who this book is written for?
phpMyAdmin is a must-have tool for everyone who needs to managetheir MySQL databases and tables in an effective manner. This book is amust-read for every serious phpMyAdmin user who would like to use thisoutstanding application to its full power.
About the Author
Marc Delisle
Marc Delisle is a member of the MySQL Developers Guild – whichregroups community developers – because of his involvement withphpMyAdmin. He started to contribute to this popular MySQL webinterface in December 1998, when he made the first multi-languageversion. He has been actively involved with the phpMyAdmin projectsince May 2001 as a developer and project administrator.
He has worked since 1980 at Collège de Sherbrooke, Québec, Canada,as an application programmer and network manager. He has also beenteaching networking, security, Linux servers, and PHP/MySQL applicationdevelopment. In one of his classes, he was pleased to meet a phpMyAdminuser from Argentina.