MAIN TOPIC: Opening a database
DETAIL: To open a database, use the File-> Open Database menu item and select a file from the file browser.||The file browser will be presented when a new window opens automatically.||You can also double-click a database built in MesaSQLite, and it will open a new window with a connection to that database.
MAIN TOPIC: Full file path of your database
DETAIL: To view the full file path of your database, mouse over the database selection popup in the toolbar and wait for the help tag to show. It will show the full system file path.
MAIN TOPIC: Preferences
DETAIL: MesaSQLite is built to make viewing and editing resident data a very quick process. Setting your preferences will help make your workflow as fast and natural as possible. The following are default settings: ||Window opens to the position it was in when last closed||Queries in the content screen are limited to 1000 records (just 10 records in DEMO mode)| |Your last 20 special queries are stored||Text encoding is set to Unicode8 (UTF8)
MAIN TOPIC: Table Content
DETAIL: Your content screen is designed to make creating various types of recordsets quickly.||All databases on the window's connection are available.||Once you select a table, you can build specific queries with the parameter controls directly beneath the table name. To add parameters, hit the most senior "+" button.||Keep in mind you can have recordsets returned upon selection of the table name if you like, as a setting in the preferences pane. You can also limit the size of the record sets in the preferences pane.||"Show All" will return all records from a table.||"Go" will return the record set defined by the parameters in front of it.||"Last XXX" will return the last XXX rows in a table. The last entry in the table will be at the bottom of the listbox.||Note that all of these buttons will create a query to the table. The query syntax can be read in the bottom of the window.
SUBTOPIC: Text Encoding
DETAIL: Depending on the text encoding of the actual database file you are opening in Mesa, some characters may not appear at all or be shown as incorrect characters.||You can mitigate this by setting your preferred text encoding using the popupmenu at the bottom of the Table Content screen.||When you first install MesaMySQL, the encoding will be set to UTF8, which is a unicode encoding.||Your database file may be encoded for example, in Win Latin 1 (ISO-8859-1). for text to appear correctly in the content listbox, Mesa encoding must be set to Win Latin 1.||You can set a preference in your preferences window to open Mesa with a given encoding every time a new window opens.||Recordsets shown in the Custom Query screen will be displayed using the encoding set on the Table Content popup.
SUBTOPIC: Loading Records
DETAIL: Select a table to view its records. Records will be presented in the text encoding indicated in the popup at the bottom of the content screen.||To change the encoding for viewing, simply change the value of the popup. The current recordset will reload in the new encoding.||To load records immediately upon table selection, set that preference in the preferences window.
SUBTOPIC: Limiting Records
DETAIL: The number of records can be limited by setting the returned row count directly in the content screen. ||A default setting can be made in the preferences window.||To view adjacent similar sized recordsets, click the arrow toggle as needed and hit the "Go" button.||You can get the most recent records added to the table by using the "Last XXX" button. The most recent record will be at the bottom of the table.
SUBTOPIC: Searching records
DETAIL: Add and specify as many search conditions as needed by hitting the most senior "add parameter button". Use the "Search" button to return the matching recordset. The number of rows returned is shown in the lower left area of the screen. Complex searches are not supported. You must use all "AND"s or "OR"s to set the parameters for your search.||Select a field for each parameter - after the table has been selected.||The popup for the input text field for the parameter will show you resident values in this field in the table IF the unique values do not exceed 250 in number.
SUBTOPIC: Hiding Columns
DETAIL: You can select the columns you want to view by hitting the "Limit Columns" button and using the checkboxes. Return to viewing all rows by hitting the "Select All" button next to it.|| You can also right-click or control-click a column header to quickly choose "hide column". To return it to visible, hit the "Select All" columns button.
SUBTOPIC: Drag Reorder Columns
DETAIL: To move a column next to another for viewing, grab the column on the header and drag it to the location you want.
SUBTOPIC: Sorting a recordset
DETAIL: Click on the title bar of a column to sort the recordset by that column. Click it again to sort it by descending order.
SUBTOPIC: Multiple Field Sort
DETAIL: To view a multiple sort, hit the "Sort Button" and select the fields in the order you would like to see the sort. This sort is not retained and needs to be redone each time you need it.
SUBTOPIC: Edit many rows at once
DETAIL: Select all the rows and hit the "Global Edit" button and specify the column and the data.||To select adjacent rows, shift-click the second row.||To add non-adjacent rows to the selection, use the command key-click on MAC and option-click on Windows.
SUBTOPIC: Auto-Set Column Widths
DETAIL: Make it easier to view tables with many columns by hitting the "Relax columns" button, which will stretch or shrink the column widths to a more natural width.||Text and Blob fields are left alone.
SUBTOPIC: Totaling Numeric Rows
DETAIL: Hit the calculator button to have Mesa add a row to the bottom of the table and populate it with the summation of the data in the column.||Only numeric columns are treated.
SUBTOPIC: Editing Cells
DETAIL: To edit a single cell, double click into it and make your change.||Cells with data longer than the cell itself will open in an new editor window for viewing ease. ||Cells edits are sent to the database when the selection changes from the row on which the cells were edited.||To run down a column of edits, click into a cell and to make the edit, hit the RETURN key to move to the next row in the same column.||Hit the ENTER key to render the change only.
SUBTOPIC: Drag Select Cells
DETAIL: Click and drag on the the cells to create a set of highlighted cells which can then be copied to the clipboard.
SUBTOPIC: Capture Cells to clipboard
DETAIL: To capture selected cells to the clipboard, the cells will be orange in color, not the normal row selection color.||Use Command-C on Mac and Control-C on Windows to place the cell contents on the clipboard. You can then paste into any other program. If you paste into Excel, rows and columns will be preserved.||You can also use the clipboard button to place selected cells on the clipboard.||Always check formatting of pasted data after you have pasted in excel. Columns with leading zeros are a particular issue with Excel. For instance a New Jersey zip code such as 08083 my arrive in Excel as 8083.
SUBTOPIC: Saving a content set as VIEW
DETAIL: You can save an Table Content set as a VIEW by hitting the Save as VIEW button on the bottom of the Table Content screen and giving the VIEW a name. The VIEW will be immediately available in the VIEWS tab.
MAIN TOPIC: Views
DETAIL: VIEWS are recordsets produced using sql SELECT statements you define. They are most likely queries you tend to want to see with some regularity. Views are stored in the database itself using a name you define. Make sure you don't use a table name for a VIEW.||Since VIEWS are created by select statements, their resulting rows are not in-line editable like the Table Content recorsets, which have their primary key available for unique identification. Also, VIEWS may contain data from any number of tables. As a result
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
MesaSQLite一个Mac电脑上很好用的sqlite可视化工具 (236个子文件)
rbframework.dylib 1.72MB
MySQLCommunityPlugin.rbx_0.dylib 1.68MB
RBREALSQLDatabase.rbx_0.dylib 566KB
CubeSQLPlugin.rbx_0.dylib 224KB
ElfData.rbx_1.dylib 151KB
MBS Real Studio JPEG Plugin.rbx_2.dylib 147KB
MBS Real Studio JPEG Plugin.rbx_1.dylib 126KB
RBAppearancePak.rbx_0.dylib 101KB
RBShell.rbx_0.dylib 61KB
MBS Real Studio MacOSX Plugin.rbx_18.dylib 41KB
MBS Real Studio Util Plugin.rbx_29.dylib 40KB
MBS Real Studio Util Plugin.rbx_51.dylib 39KB
MBS Real Studio Picture Plugin.rbx_17.dylib 35KB
MBS Real Studio Picture Plugin.rbx_22.dylib 35KB
MBS Real Studio MacOSX Plugin.rbx_12.dylib 34KB
ElfData.rbx_0.dylib 29KB
MBS Real Studio Util Plugin.rbx_35.dylib 29KB
MBS Real Studio Win Plugin.rbx_0.dylib 23KB
MBS Real Studio Util Plugin.rbx_14.dylib 23KB
MBS Real Studio Main Plugin.rbx_2.dylib 22KB
RBInternetEncodings.rbx_0.dylib 17KB
MesaSQLite.icns 243KB
REALSQLdb.icns 190KB
ImagePict.icns 83KB
ImageTiff.icns 83KB
ApplicationPdf.icns 83KB
ImageJpeg.icns 83KB
Preferences.icns 83KB
Text.icns 83KB
MesaSQLite 12.24MB
PkgInfo 8B
Info.plist 5KB
litelogo128.png 16KB
logo64.png 7KB
customquerymenubutton.png 6KB
litelogo128mask.png 6KB
addparameter.png 6KB
addparameterdown.png 6KB
subtractparameter.png 6KB
subtractparameterdown.png 6KB
menudbpopuplite.png 6KB
tableicon.png 6KB
footeremptytable.png 6KB
footerpassword.png 6KB
comboboxpopup.png 6KB
comboboxpopupdown.png 6KB
comboboxpopupdisabled.png 6KB
menudbpopuplitemask.png 6KB
parammask.png 6KB
comboboxpopupmask.png 6KB
ApertureTabs.png 5KB
aboutback.png 4KB
triggermenubutton.png 4KB
logo64mask.png 4KB
relationshipsmenubutton.png 4KB
structuremenubutton.png 3KB
contentmenubutton.png 3KB
contentwithprejudicedown.png 3KB
footerpopupright.png 3KB
viewsmenubutton.png 3KB
footerview.png 3KB
footerPopupleft.png 3KB
footerrefresh.png 3KB
footerprompt.png 3KB
greenCheckmarkmasklight.png 3KB
greenUnCheckmark.png 3KB
cocoabutton.png 3KB
listboxfooterbg.png 3KB
footerbarbg.png 3KB
footerresizecolumns.png 3KB
footerlimitcols.png 3KB
footerclipboard.png 3KB
triggermenubuttonmask.png 3KB
footersort.png 3KB
footerredo.png 3KB
footerundo.png 3KB
footerresizer.png 3KB
footersummation.png 3KB
footerduplicate.png 3KB
footerleftend.png 3KB
cocoabuttonpressmask.png 3KB
footerrightend.png 3KB
structuremenubuttonmask.png 3KB
acommitonmask.png 3KB
footershowallcols.png 3KB
undisclose.png 3KB
toolbarpopuparrow.png 3KB
footerglobalmask.png 3KB
toolbarpopuparrowmask.png 3KB
footeraddrecord.png 3KB
disclose.png 3KB
cocoabuttonmask.png 3KB
resizer.png 3KB
footerdeleterecord.png 3KB
contentmenubuttonmask.png 3KB
guttercorner.png 3KB
undisclosemask.png 3KB
footerbg.png 3KB
footerpopupbg.png 3KB
selectiongradient.png 3KB
共 236 条
- 1
- 2
- 3
资源评论
田宇的csdn
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 实现了7种排序算法.三种复杂度排序.三种nlogn复杂度排序(堆排序,归并排序,快速排序)一种线性复杂度的排序.zip
- 冒泡排序 直接选择排序 直接插入排序 随机快速排序 归并排序 堆排序.zip
- 课设-内部排序算法比较 包括冒泡排序、直接插入排序、简单选择排序、快速排序、希尔排序、归并排序和堆排序.zip
- Python排序算法.zip
- C语言实现直接插入排序、希尔排序、选择排序、冒泡排序、堆排序、快速排序、归并排序、计数排序,并带图详解.zip
- 常用工具集参考用于图像等数据处理
- 音乐展示网页、基于Stenography的图像数字水印添加与提取,以及基于颜色矩和Tamura算法的图像相似度评估算法py源码
- 基于EmguCV(OpenCV .net封装),图像数字水印加解密算法的实现,其中包含最低有效位算法,离散傅里叶变换算法+文档书
- 基于matlab+DWT的图像水印项目,数字水印+源代码+文档说明+图片+报告pdf
- (优秀毕业设计)基于python实现的数字图像可视化水印系统的设计与实现,多种数字算法实现+源代码+文档说明+理论演示pdf
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功