auto-increment: This changes the auto-increment value. It is shown only if
the table's primary key has the auto-increment attribute.
Renaming, Moving, and Copying Tables
The Rename operation is the easiest to understand: the table simply changes its
name and stays in the same database.
The Move operation (shown in the following screen) can manipulate a table in two
ways: change its name and also the database in which it is stored:
Moving a table is not directly supported by MySQL, so phpMyAdmin has to create
the table in the target database, copy the data, and then finally drop the source table.
The Copy operation leaves the original table intact and copies its structure or data
(or both) to another table, possibly in another database. Here, the book-copy table
will be an exact copy of the book source table. After the copy, we will stay in the
Table view for the book table unless we selected Switch to copied table.
The Structure only copy is done to create a test table with the same structure.
???
???
Chapter 10
[ 167 ]
Appending Data to a Table
The Copy dialog may also be used to append (add) data from one table to another.
Both tables must have the same structure. This operation is achieved by entering the
table to which we want to copy the data of the current table and choosing Data only.
For example, we would want to append data when book data comes from various
sources (various publishers), is stored in more than one table, and we want to
aggregate all the data to one place.
Pages:
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167