We will also learn how to use a single copy of phpMyAdmin to
manage multiple servers, and the usage of authentication types to fulfill the needs of
a users' group while protecting authentication credentials.
Preface
[ 2 ]
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. We'll
also see how to manage indexes (multi-field and full-text) and get feedback from
MySQL about which indexes are used in a specific query.
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.
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