From 0f586da34dac2c764a12055158e4929cf69340a1 Mon Sep 17 00:00:00 2001 From: abhibeckert Date: Fri, 4 Apr 2008 11:37:36 +0000 Subject: Initial import from (slightly modified) CocoaMySQL v0.7b4 --- English.lproj/english_help/topics/data.html | 92 +++++++++++++++++++++++++++++ 1 file changed, 92 insertions(+) create mode 100755 English.lproj/english_help/topics/data.html (limited to 'English.lproj/english_help/topics/data.html') diff --git a/English.lproj/english_help/topics/data.html b/English.lproj/english_help/topics/data.html new file mode 100755 index 00000000..109e7b0c --- /dev/null +++ b/English.lproj/english_help/topics/data.html @@ -0,0 +1,92 @@ + + +CocoaMySQL Help - Data Management + + + + + + + + +
+ + + + + + + + + +
+ +

Data Management

+
+ +
+ +
+ + Back to the main menu +
+
+ + In order to view, add, modify, or change data (rows) in your database tables you must either be in the "Content" tab or the "Custom Query" tab. +
+
+Adding and editing fields + + + + +
+ +
    +
  • Add or remove entries with the plus- and minus-buttons. You can select more than one entry and remove them together.
    • +
  • Edit entries by double-clicking on the value you want to change. If the button with the three lines on it is clicked, double clicking on a value opens a sheet where you can edit it. This is preferred to edit large entries or entries with multiple lines.
    • +
  • Use the value specified in the preferences (NULL by default) to enter NULL-values.
    • +
  • Changes aren't written to the database until you deselect the row!
    • +
  • It is recommended that you edit only tables which have a primary key.
    • +
+
+ +
+
+Sorting and filtering the table content + + + + +
+ +
    +
  • To sort a table by a field, click on the header of the appropriate column in the content-view.
    • +
  • Click on it twice to sort the table in descending order.
    • +
  • Select a field and operator and enter a keyword to filter a table. Click on the Show All-button to disable filtering.
    • +
  • As wildcards use % and _ (% matches any number of characters, even zero characters; _ matches exactly one character)
    • +
  • If you have selected "Limit result..." in the Preferences, you can specify the first row to be returned and hit "Go".
    • +
+
+ +
+
+Binary Data (Images, Strings, Hex Representations) + + + + +
+ +
    +
  • Field type should be Blob or Longblob
    • +
  • To edit/enter the data, double select the field in the Content tab
    • +
  • Click on Open and load an image
    • +
  • Change to image and hex view
    • +
+
+ + + + + \ No newline at end of file -- cgit v1.2.3