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. We'll also examine the modified
behavior of phpMyAdmin when relations are present, foreign keys, getting
information from the table, the Designer feature, and column-commenting.
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.
Pages:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25