Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Mastering phpMyAdmin 3.1 for Effective MySQL Management

Buy

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 and has been adopted by a number of open-source distributors. It is one of the 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 on fields, manage privileges, export data into various formats and is available in 52 languages. The powerful graphical interface of version 3.1 has made phpMyAdmin an indispensable tool for MySQL and web developers.

This is the first book that covers version 3.1, the latest version of phpMyAdmin. It has been fully updated from the previous version that covered phpMyAdmin Version 2.11. It is a comprehensive guide to unlocking the full potential of phpMyAdmin. It builds a solid understanding of the core capabilities of phpMyAdmin before walking you through every facet right from showing you how to set up and manage the database with clear, step-by-step instructions and screenshots to exploring the less well known and generally under-used features and capabilities of phpMyAdmin in depth. Along the way you'll build a more detailed understanding of SQL and how it works in MySQL.

Whether you are an experienced developer, system administrator, web designer or new to MySQL and phpMyAdmin, this book will show you how to increase 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 databases
  • Create better database tables and relational structures
  • Generate multiple SQL queries and build a more detailed understanding of SQL and its workings
  • Prepare better documentation of evolving table structures
  • Manage databases, table data and structures, and indexes to create efficient databases
  • Learn the different mechanisms involved in importing SQL and CSV files
  • Examine the modified behavior of phpMyAdmin to use the outstanding application to its full power
  • Perform day-to-day database and table management effectively with the new interface to ease your work

Approach

The book is a step-by-step tutorial for phpMyAdmin explaining and demonstrating the potential of this tool with clear instructions and screenshots. After covering installation and basic features of phpMyAdmin it goes on to show its less well known and generally under-used features and capabilities.

Who this book is written for?

phpMyAdmin is a must-have tool for everyone who needs to manage their MySQL databases and tables in an effective manner. This book is a must-read for every serious phpMyAdmin user who would like to use this outstanding application to its full power.

About the Author


Marc Delisle

Marc Delisle is a member of the MySQL Developers Guild - which regroups community developers - because of his involvement with phpMyAdmin. He started to contribute to this popular MySQL web interface in December 1998, when he made the first multi-language version. He has been actively involved with the phpMyAdmin project since 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 been teaching networking, security, Linux servers, and PHP/MySQL application development. In one of his classes, he was pleased to meet a phpMyAdmin user from Argentina.

(HTML tags aren't allowed.)

Just Listen: Discover the Secret to Getting Through to Absolutely Anyone
Just Listen: Discover the Secret to Getting Through to Absolutely Anyone

Offers listening tools and techniques to make employees, bosses, and clients more willing to agree with proposals.

...
Migrating to iPhone and iPad for .NET Developers
Migrating to iPhone and iPad for .NET Developers

Ever since I spotted and started reading my first computer book in 1981, I knew Information Technology (IT) was going to be an important part of my life. I feel privileged to have been able to make a career out of something I enjoy, and the fact that it changes on what seems to be a monthly basis means it never gets boring. It still...

Electronic Concepts: An Introduction
Electronic Concepts: An Introduction

Electronic Concepts provides a detailed introduction to modern microelectronics. Jerrold Krenz emphasizes analog and digital circuits, and describes applications of particular devices and circuits within the context of actual electronic systems. He begins with an overview of several important electronic systems, and discusses in detail the...


XPath Kick Start : Navigating XML with XPath 1.0 and 2.0
XPath Kick Start : Navigating XML with XPath 1.0 and 2.0
 XPath Kick Start provides the fastest path to productivity with XPath, and is fully up to date with the most recent XPath specification. Award-winning author Steven Holzner speeds through the basics so you'll be an XPath expert in no time. You'll master the XPath syntax and data model and understand the features of XPath 2.0, including new...
Assessing and Reforming Public Financial Management: A New Approach
Assessing and Reforming Public Financial Management: A New Approach
Over the past 15 years donors seeking to advance development and abate poverty have placed growing emphasis on the need for effective public expenditure management and financial accountability systems. Numerous trends explain this evolution, including the realization that aid resources are fungible, the shift toward policy-based adjustment lending,...
Beginning Ruby on Rails (Wrox Beginning Guides)
Beginning Ruby on Rails (Wrox Beginning Guides)
Ruby on Rails is the revolutionary online programming tool that makes creating functional e-commerce web sites faster and easier than ever. With the intuitive, straightforward nature of Ruby and the development platform provided by Rails, you can put together full-fledged web applications quickly, even if you're new to web programming.
...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy