Author: tbedford
Date: 2010-04-14 15:46:27 +0200 (Wed, 14 Apr 2010)
New Revision: 20009
Log:
Updates for 5.2.17
Modified:
trunk/workbench/table-editor.xml
Modified: trunk/workbench/table-editor.xml
===================================================================
--- trunk/workbench/table-editor.xml 2010-04-14 10:03:59 UTC (rev 20008)
+++ trunk/workbench/table-editor.xml 2010-04-14 13:46:27 UTC (rev 20009)
Changed blocks: 7, Lines Added: 110, Lines Deleted: 22; 5992 bytes
@@ -606,7 +606,7 @@
</para>
<para>
- Subpartitioning is not yet enabled. For more information about
+ Subpartitioning is also available. For more information about
partitioning see <xref linkend="partitioning"/>.
</para>
@@ -617,11 +617,48 @@
<title>The Options Tab</title>
<para>
- The <guilabel>Options</guilabel> tab allows you to set the general
- options and row options.
+ The <guilabel>Options</guilabel> tab allows you to set several
+ types of options. These are grouped into the following frames:
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ General Options
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Row Options
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Storage Options
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Merge Table options
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<para>
+ Each of these is discussed in more detail in the following
+ sections.
+ </para>
+
+ <para>
+ <emphasis role="bold">General Options</emphasis>
+ </para>
+
+ <para>
In the <guilabel>General Options</guilabel> frame, choose a pack
keys option. The options are <literal>Default</literal>,
<literal>Pack None</literal>, and <literal>Pack All</literal>. You
@@ -631,6 +668,10 @@
</para>
<para>
+ <emphasis role="bold">Row Options</emphasis>
+ </para>
+
+ <para>
To set the row format, choose the desired row format from the
drop-down list. See <xref linkend="myisam-table-formats"/> for
more information about the different row formats that are
@@ -691,6 +732,10 @@
</para>
<para>
+ <emphasis role="bold">Storage Options</emphasis>
+ </para>
+
+ <para>
The <literal>Storage Options</literal> section is used to
configure a custom path to the table storage and data files. This
option can help improve data integrity and server performance by
@@ -699,6 +744,10 @@
</para>
<para>
+ <emphasis role="bold">Merge Table Options</emphasis>
+ </para>
+
+ <para>
The <literal>Merge Table</literal> Options section is used to
configure MERGE tables in MyISAM. To create a MERGE table, select
MERGE as your storage engine and then specify the tables you wish
@@ -722,29 +771,68 @@
<para>
Use the <literal>Inserts</literal> tab to insert records into the
- table. Clicking the <guibutton>Open Editor ...</guibutton> button
- on the lower right hand side opens the <literal>Standard
- Inserts</literal> editor. Use this editor to add records to the
table.
</para>
<para>
- When you have finished adding records, press
- <guibutton>OK</guibutton>. The records you have added are
- displayed in the <literal>Inserts</literal> tab. Reopening the
- editor displays all the records shown in the
- <literal>Inserts</literal> tab. To edit a record simply click on
- the field you wish to change and enter the new data. To delete a
- record, click the button on the left beside the desired row and
- then press the <keycap>Delete</keycap> key. You can select and
- delete all records by clicking in the top left hand column of the
- editor and then pressing the <keycap>Delete</keycap> key. Your
- changes will not be applied until you press the
- <guibutton>OK</guibutton> button. To back out of an operation,
- press the <guibutton>Cancel</guibutton> button.
+ To edit a record simply click on the field you wish to change and
+ enter the new data. Right-clicking on a row displays a menu with
+ the following items:
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ Set Field(s) to NULL -
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Delete Row(s) -
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Copy Row Content - Copies the row to the clipboard. Strings
+ are copied quoted, and NULLs are preserved.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Copy Row Content (unquoted) - Copies the row to the clipboard.
+ Strings are not quoted and NULLs are copied as a space.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Copy Field Content - Copies the value of the selected field to
+ the clipboard. Strings are quoted.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Copy Field Content (unquoted) - Copies the value of the
+ selected field to the clipboard. Strings are not quoted.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<para>
+ Note the insert editor features a toolbar. This has the same
+ functionality as explained in
+ <xref linkend="wb-sql-editor-results-tabsheets"/> and
+ <xref linkend="wb-sql-editor-live-editing-tabsheets"/>. You can
+ also hover the cursor over the toolbar to display tooltips.
+ </para>
+
+ <para>
Any records you add will be inserted when you forward engineer the
database (if you choose the <literal>Generate INSERT statements
for tables</literal> option).
@@ -889,9 +977,9 @@
</itemizedlist>
You can choose to assign all privileges to a specific user or any
- other privilege listed in the preceding. Privileges irrelevant to
- a specific table, the <literal>FILE</literal> privilege for
- example, are not shown.
+ other privilege as listed previously. Privileges irrelevant to a
+ specific table, the <literal>FILE</literal> privilege for example,
+ are not shown.
</para>
<para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r20009 - trunk/workbench | tony.bedford | 14 Apr |
