|
Free ebooks
 Free database ebooks SQL Mastering phpMyAdmin 2.11 for Effective MySQL Management
|
 Chapter 1 will take a look at how the Web has evolved as a means to deliver applications and why we should use PHP/MySQL to develop these applications. We'll also take a look at how phpMyAdmin is recognized as a leading application to interface MySQL from the Web, the history of phpMyAdmin, and a brief list of its features.Chapter 2 will take a look at the common reasons for installing phpMyAdmin, the steps for downloading it from the main site, the basic configuration, and uploading it to our web server. Chapter 3 will take a look at the phpMyAdmin interface in detail. Chapter 4 will cover how to create a database and tables, and how to enter data, manually, in the tables. We'll also see how to confirm the presence of data by using the browse mode; including the SQL query links, navigation bar, sorting options, and row marking. Chapter 5 will examine concepts like editing data, including the null field and using the Tab key, applying a function to a value, duplicating rows of data, and deleting data, tables, and databases. Chapter 6 will cover how to add fields, including special field types like TEXT, BLOB, ENUM, and SET, how to use a calendar popup for DATE, DATETIME, and TIMESTAMP fields, and how to upload binary data into a BLOB field. Chapter 7 will examine the various ways to trigger an export: from the Database view, the Table view, or a results page. We'll also take a look at the various available export formats, their options, the possibility of compressing the export file, and the various places where it might be sent. Chapter 8 will look at the various options in phpMyAdmin that allow us to import data, the different mechanisms involved in importing SQL and CSV files, the limits that we might hit when trying a transfer, and ways to bypass these limits. Chapter 9 will cover single-table searches with query by example criteria and additional criteria specification, selecting displayed values, and ordering results. We'll also look at wildcard searches and full database search. Chapter 10 will cover the operations we can perform on whole tables or databases. We'll take a look at table maintenance operations for table repair and optimization, changing various table attributes, table movements, including renaming and moving to another database, and multi-table operations. Chapter 11 will take a look at the installation of the necessary infrastructure for keeping special metadata (data about tables), and we'll learn how to define relations between both InnoDB and non-InnoDB tables. Chapter 12 will take a look at the purpose of query boxes and where they can be found. We'll also look at query window options, multi-statement queries, how to use the field selector, how to use the SQL Validator, and how to get a history of the typed commands. Chapter 13 will cover various aspects such as opening the query generator, choosing tables, entering column criteria, sorting and showing columns, and altering the number of criteria rows or columns. Chapter 14 will take a look at how to record bookmarks (after or before sending a query), how to manipulate them, and how some bookmarks can be made public. We'll learn about the default initial query for Browse mode. Chapter 15 will cover the documentation features offered by phpMyAdmin—the print view for a database or a table, and the data dictionary for a complete column list. We'll also see PDF relational schemas. Chapter 16 will examine how we can improve the browsing experience by transforming data using various methods. We'll see thumbnail and full-size images of .jpeg and .png BLOB fields, generate links, format dates, display only parts of texts, and execute external programs to reformat each cell's contents. Chapter 17 will cover the use of language files in phpMyAdmin. We'll look at UTF-8 and the impact of switching from one character set to another. We also see how phpMyAdmin has to recode data when the version of MySQL is earlier than 4.1.x, and take a look at the character set and collation features of MySQL version 4.1.x and later. Chapter 18 will cover how phpMyAdmin permits to manage the main features of MySQL 5.0. Chapter 19 will discuss how a system administrator can use the phpMyAdmin server management features for day-to-day user account maintenance, server verification, and server protection. Chapter 20 proposes guidelines for solving some common problems, and gives hints on how to avoid them. It also explains how to interact with the development team for support, bug reports, and contributions. Download free pdf ebooks for sql:Mastering phpMyAdmin 2.11 for Effective MySQL Management
|
