CLICurrent database: %1當前資料庫:%1No current working database is set.目前未設定操作的資料庫。Type %1 for help輸入 %1 獲取幫助Database passed in command line parameters (%1) was already on the list under name: %2透過命令列引數傳入的資料庫(%1)已在清單中,名為:%2Could not add database %1 to list.未將資料庫“%1”新增到清單。closed已關閉CliCommandUsage: %1%2用法:%1%2CliCommandAddCould not add database %1 to list.未將資料庫“%1”新增到清單。Database added: %1已新增資料庫:%1adds new database to the list新增新的資料庫到清單Adds given database pointed by <path> with given <name> to list the databases list. The <name> is just a symbolic name that you can later refer to. Just pick any unique name. For list of databases already on the list use %1 command.新增指定<路徑>的資料庫到資料庫清單,用指定的<名稱>。<名稱>是您之後可以用來引用它的名稱。選擇一個不重複的名稱。查閱已在資料庫清單中的資料庫,請用 %1 命令。nameCLI command syntax名稱pathCLI command syntax路徑CliCommandCdChanged directory to: %1目錄已改為:%1Could not change directory to: %1未能切換到目錄:%1changes current working directory更改當前的工作目錄Very similar command to 'cd' known from Unix systems and Windows. It requires a <path> argument to be passed, therefore calling %1 will always cause a change of the directory. To learn what's the current working directory use %2 command and to list contents of the current working directory use %3 command.非常類似 Unix 和 Windows 系統中的 'cd' 命令。需要傳入一個<路徑>引數,因此呼叫 %1 將始終導致目錄的更改。 要了解當前工作目錄,請使用 %2 命令並使用 %3 命令列出當前工作目錄的內容。pathCLI command syntax路徑CliCommandCloseCannot call %1 when no database is set to be current. Specify current database with %2 command or pass database name to %3.沒有設定當前資料庫時無法呼叫 %1。使用 %2 命令指定當前資料庫,或者傳遞資料庫名稱到 %3。Connection to database %1 closed.資料庫 %1 的連線已關閉。No such database: %1. Use %2 to see list of known databases.沒有這樣的資料庫:%1。使用 %2 檢視已知資料庫清單。closes given (or current) database關閉指定的或當前的資料庫Closes database connection. If the database was already closed, nothing happens. If <name> is provided, it should be name of the database to close (as printed by %1 command). The the <name> is not provided, then current working database is closed (see help for %2 for details).關閉資料庫連線。如果資料庫已關閉,什麼也不做。如果提供了<名稱>,則表示需要關閉的資料庫的名稱(見 %1 命令的結果)。如果沒有提供<名稱>。則關閉當前操作的資料庫(詳見 %2 的幫助)。nameCLI command syntax名稱CliCommandDbListNo current working database defined.目前未定義操作的資料庫。Databases:資料庫:NameCLI db name column名稱OpenCLI connection state column開啟ClosedCLI connection state column關閉ConnectionCLI connection state column連線Database file path資料庫檔案路徑prints list of registered databases列印已註冊資料庫清單Prints list of databases registered in the SQLiteStudio. Each database on the list can be in open or closed state and %1 tells you that. The current working database (aka default database) is also marked on the list with '*' at the start of its name. See help for %2 command to learn about the default database.列出在 SQLiteStudio 中註冊的資料庫的清單。清單中的每個資料庫都可以處於開啟或關閉狀態,用 %1 檢視狀態。 當前工作資料庫(又名預設資料庫)也在清單中,在它名字的開頭用'*'標記。請參閱 %2 命令的幫助以瞭解預設資料庫。CliCommandDescNo working database is set.
Call %1 command to set working database.
Call %2 to see list of all databases.沒有設定操作的資料庫。
呼叫 %1 命令操作的資料庫。
呼叫 %2 查閱資料庫清單。Database is not open.資料庫未被開啟。Cannot find table named: %1無法找到名為 %1 的表shows details about the table顯示一個表的詳細資訊table表Table: %1表:%1Column name欄位名Data type資料型別Constraints約束條件Virtual table: %1虛擬表:%1Construction arguments:構造引數:No construction arguments were passed for this virtual table.沒有為此虛擬表傳遞結構引數。CliCommandDirlists directories and files in current working directory列出當前工作目錄中的目錄與檔案This is very similar to 'dir' command known from Windows and 'ls' command from Unix systems.
You can pass <pattern> with wildcard characters to filter output.這非常類似 Windows 中的 'dir' 命令與 Unix 中的 'ls' 命令。
可以傳入一個帶有萬用字元的<模式>來過濾輸出內容。pattern模式CliCommandExitquits the application退出本程式Quits the application. Settings are stored in configuration file and will be restored on next startup.退出本程式。設定已儲存在設定檔檔案,將在下一次啟動時恢復。CliCommandHelpshows this help message顯示這個幫助資訊Use %1 to learn about certain commands supported by the command line interface (CLI) of the SQLiteStudio.
To see list of supported commands, type %2 without any arguments.
When passing <command> name, you can skip special prefix character ('%3').
You can always execute any command with exactly single '--help' option to see help for that command. It's an alternative for typing: %1 <command>.使用 %1 瞭解 SQLiteStudio 的命令列介面(CLI)所支援的特定命令。
輸入 %2 不帶任何引數來檢視支援的命令清單。
傳入<命令>名稱時,您可以跳過特殊的字首字元('%3')。
您可以為任何命令指定 '--help' 選項並執行來檢視特定命令的幫助。另一種方法:%1 <命令>。commandCLI command syntax命令No such command: %1沒有這個命令:%1Type '%1' for list of available commands.輸入 '%1' 列出所有可用的命令。Usage: %1%2用法:%1%2Aliases: %1別名:%1CliCommandHistoryCurrent history limit is set to: %1當前歷史記錄限制為:%1prints history or erases it列出歷史或擦除When no argument was passed, this command prints command line history. Every history entry is separated with a horizontal line, so multiline entries are easier to read.
When the -c or --clear option is passed, then the history gets erased.
When the -l or --limit option is passed, it sets the new history entries limit. It requires an additional argument saying how many entries do you want the history to be limited to.
Use -ql or --querylimit option to see the current limit value.沒有傳入引數時,此命令列出命令列歷史。每條歷史以水平線隔開,以使多行單條更易閱讀。
傳入 -c 或 --clear 選項,歷史記錄將被清空擦除。
傳入 -l 或 --limit 選項,設定歷史記錄條數限制。需要附上額外引數,指明將歷史記錄限制為最多多少條。
使用 -ql 或 --querylimit 選項,可檢視當前的限制值。number數值Console history erased.控制檯歷史已擦除。Invalid number: %1無效數值:%1History limit set to %1歷史記錄限制已設為 %1CliCommandModeCurrent results printing mode: %1當前結果列印模式:%1Invalid results printing mode: %1無效結果列印模式:%1New results printing mode: %1新結果列印模式:%1tells or changes the query results format詢問或更改查詢結果的格式When called without argument, tells the current output format for a query results. When the <mode> is passed, the mode is changed to the given one. Supported modes are:
- CLASSIC - columns are separated by a comma, not aligned,
- FIXED - columns have equal and fixed width, they always fit into terminal window width, but the data in columns can be cut off,
- COLUMNS - like FIXED, but smarter (do not use with huge result sets, see details below),
- ROW - each column from the row is displayed in new line, so the full data is displayed.
The CLASSIC mode is recommended if you want to see all the data, but you don't want to waste lines for each column. Each row will display full data for every column, but this also means, that columns will not be aligned to each other in next rows. The CLASSIC mode also doesn't respect the width of your terminal (console) window, so if values in columns are wider than the window, the row will be continued in next lines.
The FIXED mode is recommended if you want a readable output and you don't care about long data values. Columns will be aligned, making the output a nice table. The width of columns is calculated from width of the console window and a number of columns.
The COLUMNS mode is similar to FIXED mode, except it tries to be smart and make columns with shorter values more thin, while columns with longer values get more space. First to shrink are columns with longest headers (so the header names are to be cut off as first), then columns with the longest values are shrinked, up to the moment when all columns fit into terminal window.
ATTENTION! The COLUMNS mode reads all the results from the query at once in order to evaluate column widths, therefore it is dangerous to use this mode when working with huge result sets. Keep in mind that this mode will load entire result set into memory.
The ROW mode is recommended if you need to see whole values and you don't expect many rows to be displayed, because this mode displays a line of output per each column, so you'll get 10 lines for single row with 10 columns, then if you have 10 of such rows, you will get 100 lines of output (+1 extra line per each row, to separate rows from each other).When called without argument, tells the current output format for a query results. When the <mode> is passed, the mode is changed to the given one. Supported modes are:
- CLASSIC - columns are separated by a comma, not aligned,
- FIXED - columns have equal and fixed width, they always fit into terminal window width, but the data in columns can be cut off,
- COLUMNS - like FIXED, but smarter (do not use with huge result sets, see details below),
- ROW - each column from the row is displayed in new line, so the full data is displayed.
The CLASSIC mode is recommended if you want to see all the data, but you don't want to waste lines for each column. Each row will display full data for every column, but this also means, that columns will not be aligned to each other in next rows. The CLASSIC mode also doesn't respect the width of your terminal (console) window, so if values in columns are wider than the window, the row will be continued in next lines.
The FIXED mode is recommended if you want a readable output and you don't care about long data values. Columns will be aligned, making the output a nice table. The width of columns is calculated from width of the console window and a number of columns.
The COLUMNS mode is similar to FIXED mode, except it tries to be smart and make columns with shorter values more thin, while columns with longer values get more space. First to shrink are columns with longest headers (so the header names are to be cut off as first), then columns with the longest values are shrinked, up to the moment when all columns fit into terminal window.
ATTENTION! The COLUMNS mode reads all the results from the query at once in order to evaluate column widths, therefore it is dangerous to use this mode when working with huge result sets. Keep in mind that this mode will load entire result set into memory.
The ROW mode is recommended if you need to see whole values and you don't expect many rows to be displayed, because this mode displays a line of output per each column, so you'll get 10 lines for single row with 10 columns, then if you have 10 of such rows, you will get 100 lines of output (+1 extra line per each row, to separate rows from each other).CliCommandNullValueCurrent NULL representation string: %1當前表示 NULL 的字串:%1tells or changes the NULL representation string詢問或更改表示 NULL 的字串If no argument was passed, it tells what's the current NULL value representation (that is - what is printed in place of NULL values in query results). If the argument is given, then it's used as a new string to be used for NULL representation.如果不傳入任何引數,則會告知當前的 NULL 值表示方法(即查詢結果中以什麼代表 NULL 值)。如果提供了引數,則引數將作為新的代表 NULL 值的字串。CliCommandOpenCannot call %1 when no database is set to be current. Specify current database with %2 command or pass database name to %3.沒有設定當前資料庫時無法呼叫 %1。使用 %2 命令指定當前資料庫,或者傳遞資料庫名稱到 %3。Could not add database %1 to list.未能將資料庫“%1”新增到清單。File %1 doesn't exist in %2. Cannot open inexisting database with %3 command. To create a new database, use %4 command.檔案 %1 不存在於 %2。無法使用 %3 命令開啟不存在的資料庫。使用 %4 命令建立一個新資料庫。Database %1 has been open and set as the current working database.已開啟資料庫 %1 並將其設為當前操作的資料庫。opens database connection開啟資料庫連線Opens connection to the database. If no additional argument was passed, then the connection is open to the current default database (see help for %1 for details). However if an argument was passed, it can be either <name> of the registered database to open, or it can be <path> to the database file to open. In the second case, the <path> gets registered on the list with a generated name, but only for the period of current application session. After restarting application such database is not restored on the list.開啟到資料庫的連線。如果不提供額外的引數,則開啟到當前的預設資料庫(詳見 %1)的連線。如果提供一個引數,它可以是已註冊的資料庫的<名稱>,也可以是要開啟的資料庫檔案的<路徑>。第二種情況下,<路徑>將使用自動生成的名稱臨時註冊到資料庫清單,並在應用程式退出時從清單中消失。nameCLI command syntax名稱pathCLI command syntax路徑CliCommandPwdprints the current working directory列出當前的工作目錄This is the same as 'pwd' command on Unix systems and 'cd' command without arguments on Windows. It prints current working directory. You can change the current working directory with %1 command and you can also list contents of the current working directory with %2 command.這與 Unix 系統上的 'pwd' 命令以及 Windows 系統上沒有引數的 'cd' 命令作用相同。將列出當前的工作目錄。使用 %1 命令可以更改當前的工作目錄,您也可以用 %2 命令列出當前工作目錄的內容。CliCommandRemoveNo such database: %1沒有這樣一個數據庫:%1Database removed: %1資料庫已移除:%1New current database set:新的當前資料庫設為:removes database from the list從清單中移除資料庫Removes <name> database from the list of registered databases. If the database was not on the list (see %1 command), then error message is printed and nothing more happens.從已註冊資料庫清單中移除名為<名稱>的資料庫。如果清單(見 %1 命令)中沒有所指定的資料庫 ,會給出錯誤訊息。nameCLI command syntax名稱CliCommandSqlNo working database is set.
Call %1 command to set working database.
Call %2 to see list of all databases.沒有設定操作的資料庫。
呼叫 %1 命令操作的資料庫。
呼叫 %2 查閱資料庫清單。Database is not open.資料庫沒有開啟。executes SQL query執行 SQL 查詢This command is executed every time you enter SQL query in command prompt. It executes the query on the current working database (see help for %1 for details). There's no sense in executing this command explicitly. Instead just type the SQL query in the command prompt, without any command prefixed.您每次在命令列提示符中輸入 SQL 查詢時會執行此命令。它負責在當前操作的資料庫(詳見 %1)上執行查詢。專門執行此命令沒有任何意義。您可以在命令列提示符中直接輸入 SQL 查詢,無需新增命令字首。sqlCLI command syntaxsqlToo many columns to display in %1 mode.在 %1 模式下有太多列需要顯示。Row %1行 %1Query execution error: %1查詢執行錯誤:%1CliCommandTablesNo such database: %1. Use %2 to see list of known databases.沒有這樣一個數據庫:%1。使用 %2 檢視已知的資料庫清單。Cannot call %1 when no database is set to be current. Specify current database with %2 command or pass database name to %3.沒有設定當前資料庫時無法呼叫 %1。用 %2 命令指定當前資料庫,或者傳遞資料庫名稱到 %3。Database %1 is closed.資料庫 %1 已關閉。Database資料庫Table表prints list of tables in the database列出資料庫中的所有表Prints list of tables in given <database> or in the current working database. Note, that the <database> should be the name of the registered database (see %1). The output list includes all tables from any other databases attached to the queried database.
When the -s option is given, then system tables are also listed.列出指定的<資料庫>或當前操作的資料庫的表。注意,<資料庫>應是已註冊的資料庫的名稱(見 %1)。輸出的清單同時包含已附加到被查詢資料庫的其他資料庫的所有表。
提供 -s 選項時,將同時列出系統表。databaseCLI command syntax資料庫CliCommandTreeNo current working database is selected. Use %1 to define one and then run %2.目前沒有選擇要操作的資料庫。使用 %1 定義一個,然後執行 %2。Tables表Views檢視Columns列Indexes索引Triggers觸發器prints all objects in the database as a tree將資料庫中的所有物件列為一個樹Prints all objects (tables, indexes, triggers and views) that are in the database as a tree. The tree is very similar to the one that you can see in GUI client of the SQLiteStudio.
When -c option is given, then also columns will be listed under each table.
When -s option is given, then also system objects will be printed (sqlite_* tables, autoincrement indexes, etc).
The database argument is optional and if provided, then only given database will be printed. This is not a registered database name, but instead it's an internal SQLite database name, like 'main', 'temp', or any attached database name. To print tree for other registered database, call %1 first to switch the working database, and then use %2 command.列出資料庫中的所有物件(表、索引、觸發器和檢視)為一個樹。此樹非常類似您在 SQLiteStudio 的圖形使用者介面(GUI)版本中看到的效果。
提供 -c 選項時,會同時在每個表下列出它的列。
提供 -s 選項時,會同時列出系統物件(sqlite_* 表、自動增量索引等)。
資料庫引數為可選,如果提供則僅列出所給出的資料庫。這不是資料庫在清單中註冊的名稱,而是其在 SQLIte 資料庫內部的名稱,例如 'main'、'temp' 等。如果要列出清單中註冊的其他資料庫,先呼叫 %1 切換當前操作的資料庫,然後再使用 %2 命令。CliCommandUseNo current database selected.目前沒有選擇資料庫。Current database: %1當前資料庫:%1No such database: %1沒有這樣一個數據庫:%1changes default working database更改預設操作的資料庫Changes current working database to <name>. If the <name> database is not registered in the application, then the error message is printed and no change is made.
What is current working database?
When you type a SQL query to be executed, it is executed on the default database, which is also known as the current working database. Most of database-related commands can also work using default database, if no database was provided in their arguments. The current database is always identified by command line prompt. The default database is always defined (unless there is no database on the list at all).
The default database can be selected in various ways:
- using %1 command,
- by passing database file name to the application startup parameters,
- by passing registered database name to the application startup parameters,
- by restoring previously selected default database from saved configuration,
- or when default database was not selected by any of the above, then first database from the registered databases list becomes the default one.更改當前操作的資料庫至<名稱>。如果<名稱>資料庫沒有在本程式中註冊,將給出錯誤訊息並且什麼也不做。
什麼是當前操作的資料庫?
當您輸入一條 SQL 查詢以期執行時,它會在預設資料庫上執行,這也被稱為當前操作(或稱作業)的資料庫。大多數與資料庫相關的命令也在沒有額外指明時使用預設資料庫。當前的資料庫會始終在命令列中標明。會始終有一個預設資料庫,除非資料庫清單為空。
有多種方式選擇預設資料庫。
- 使用 %1 命令;
- 本程式啟動時將資料庫的檔名作為啟動引數傳入;
- 本程式啟動時將已註冊的資料庫名稱;
- 從已儲存的設定檔檔案還原之前選擇的預設資料庫;
- 未透過以上任何方式選擇預設資料庫時,註冊的資料庫清單中的第一個資料庫將作為預設資料庫。nameCLI command syntax名稱QObjectInsufficient number of arguments.引數數量不足。Too many arguments.引數過多。Invalid argument value: %1.
Expected one of: %2無效引數值:%1。
預期可能是:%2Unknown option: %1CLI command syntax未知選項:%1Option %1 requires an argument.CLI command syntax選項 %1 要求一個引數。stringCLI command syntax字串Command line interface to SQLiteStudio, a SQLite manager.SQLite 管理工具 SQLiteStudio 的命令列介面。Enables debug messages on standard error output.啟用除錯訊息輸出到標準錯誤輸出。Enables Lemon parser debug messages for SQL code assistant.啟用 SQL 程式碼助手的 Lemon 解析器除錯訊息。Lists plugins installed in the SQLiteStudio and quits.列出 SQLiteStudio 中已安裝的外掛然後退出。Executes provided SQL file (including all rich features of SQLiteStudio's query executor) on the specified database file and quits. The database parameter becomes mandatory if this option is used.Executes provided SQL file (including all rich features of SQLiteStudio's query executor) on the specified database file and quits. The database parameter becomes mandatory if this option is used.SQL fileSQL fileCharacter encoding to use when reading SQL file (-e option). Use -cl to list available codecs. Defaults to %1.Character encoding to use when reading SQL file (-e option). Use -cl to list available codecs. Defaults to %1.codeccodecLists available codecs to be used with -c option and quits.Lists available codecs to be used with -c option and quits.When used together with -e option, the execution will not stop on an error, but rather continue until the end, ignoring errors.When used together with -e option, the execution will not stop on an error, but rather continue until the end, ignoring errors.file檔案Database file to open要開啟的資料庫檔案Invalid codec: %1. Use -cl option to list available codecs.Invalid codec: %1. Use -cl option to list available codecs.Database file argument is mandatory when executing SQL file.Database file argument is mandatory when executing SQL file.Could not open specified database for executing SQL file. You may try using -d option to find out more details.Could not open specified database for executing SQL file. You may try using -d option to find out more details.