Databases Reference
In-Depth Information
•
delay_key_write
: This instructs MySQL not to write the index updates
immediately but to queue them for later, which improves performance.
Available for
MyISAM
only.
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
topic
source table. After the copy, we will stay in the
Table view for the
topic
table unless we selected
Switch to copied table
.
The
Structure only
copy is done to create a test table with the same structure.
Search WWH ::
Custom Search