
Mastering phpMyAdmin 3.1 for Effective MySQL Management
Subscription
Free Trial for 7 days
$12.99/m after trial
eBook + Subscription
$12.99
eBook
$22.99
Print + eBook
$38.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with eBook + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
Subscription
Free Trial for 7 days
$12.99/m after trial
eBook + Subscription
$12.99
eBook
$22.99
Print + eBook
$38.99
What do you get with a Packt Subscription?
What do you get with a Packt Subscription?
What do you get with eBook + Subscription?
What do you get with a Packt Subscription?
What do you get with eBook?
What do I get with Print?
What do you get with video?
What do you get with Audiobook?
-
Free ChapterIntroduction and Installation
-
Authentication and Security
-
Interface Overview
-
First Steps
-
Changing Data
-
Changing Table Structures
-
Exporting Structure and Data (Backup)
-
Importing Structure and Data
-
Searching Data
-
Table and Database Operations
-
The Relational System
-
Entering SQL Commands
-
The Multi-Table Query Generator
-
Bookmarks
-
System Documentation
-
MIME-Based Transformations
-
MySQL 5.0 and 5.1 Support
-
MySQL Server Administration
About this book
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.
- Publication date:
- March 2009
- Publisher
- Packt
- Pages
- 352
- ISBN
- 9781847197863