Sequel Pro Help - Data Management

From fab9a6506cd04ec8f840c98772a80c44a79c74a7 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Wed, 10 Dec 2008 16:52:52 +0000 Subject: MERGED r262:266 from branches/stuart02 to trunk to include new project structure. --- English.lproj/english_help/topics/data.html | 92 ----------------------------- 1 file changed, 92 deletions(-) delete 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 deleted file mode 100755 index 14aaeb9f..00000000 --- a/English.lproj/english_help/topics/data.html +++ /dev/null @@ -1,92 +0,0 @@ - - -Sequel Pro 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