SQLite: Command Line Shell - Revision history

Onnowpurbo: /* Perintah khusus di sqlite3 */

2014-04-02T07:37:03Z

Perintah khusus di sqlite3

Onnowpurbo: /* Perintah khusus di sqlite3 */

2014-04-02T07:36:21Z

Perintah khusus di sqlite3

Onnowpurbo: /* Perintah khusus di sqlite3 */

2014-04-02T07:35:54Z

Perintah khusus di sqlite3

Onnowpurbo: /* Perintah khusus di sqlite3 */

2014-04-02T07:35:33Z

Perintah khusus di sqlite3

Onnowpurbo: /* Perintah khusus di sqlite3 */

2014-04-02T07:33:48Z

Perintah khusus di sqlite3

Onnowpurbo: /* Perintah khusus di sqlite3 */

2014-04-02T07:32:59Z

Perintah khusus di sqlite3

Onnowpurbo at 07:31, 2 April 2014

2014-04-02T07:31:03Z

Onnowpurbo: /* Perintah khusus di sqlite3 */

2014-04-02T07:12:41Z

Perintah khusus di sqlite3

Onnowpurbo: /* Special commands to sqlite3 */

2014-04-02T07:07:28Z

Special commands to sqlite3

Onnowpurbo: /* Tambahan: Query ke tabel SQLITE_MASTER */

2014-04-02T07:02:40Z

Tambahan: Query ke tabel SQLITE_MASTER

@@ Line 96: / Line 96: @@
                            csv      Comma-separated value
                            column   Left-aligned columns. (See .width)
-                           'html     HTML <table> code'
+                           html     HTML <table> code
                            insert   SQL insert statements for TABLE
                            line     One value per line

@@ Line 95: / Line 95: @@
   .mode MODE ?TABLE?     Set output mode where MODE is one of:
                            csv      Comma-separated value
+                          column   Left-aligned columns. (See .width)
-                           html     HTML <table> code
+                           'html     HTML <table> code'
                            insert   SQL insert statements for TABLE
                            line     One value per line

@@ Line 95: / Line 95: @@
   .mode MODE ?TABLE?     Set output mode where MODE is one of:
                            csv      Comma-separated value
-                          column   Left-aligned columns. (See .width)
                            html     HTML <table> code
                            insert   SQL insert statements for TABLE

@@ Line 94: / Line 94: @@
   .load FILE ?ENTRY?     Load an extension library
   .mode MODE ?TABLE?     Set output mode where MODE is one of:
-                           csv      Comma-separated valu
+                           csv      Comma-separated value
-                           column   Left-aligned columns.  (See .width)
+                           column   Left-aligned columns. (See .width)
                            html     HTML <table> code
                            insert   SQL insert statements for TABLE

@@ Line 96: / Line 96: @@
                            csv      Comma-separated valu
                            column   Left-aligned columns.  (See .width)
-                             html     HTML <table> code
+                          html     HTML <table> code
-                             insert   SQL insert statements for TABLE
+                          insert   SQL insert statements for TABLE
-                             line     One value per line
+                          line     One value per line
-                             list     Values delimited by .separator string
+                          list     Values delimited by .separator string
-                             tabs     Tab-separated values
+                          tabs     Tab-separated values
-                             tcl      TCL list elements
+                          tcl      TCL list elements
   .nullvalue STRING      Print STRING in place of NULL values
   .output FILENAME       Send output to FILENAME

@@ Line 106: / Line 106: @@
   .output stdout         Send output to the screen
   .prompt MAIN CONTINUE  Replace the standard prompts
   .quit                  Exit this program
   .read FILENAME         Execute SQL in FILENAME

@@ Line 121: / Line 121: @@
 ==Changing Output Formats==
-The sqlite3 program is able to show the results of a query in eight different formats: "csv", "column", "html", "insert", "line", "list", "tabs", and "tcl". You can use the ".mode" dot command to switch between these output formats.
+sqlite3 mampu menampilkan hasil query dalam delapan format yang berbeda, yaitu:
 The default output mode is "list". In list mode, each record of a query result is written on one line of output and each column within that record is separated by a specific separator string. The default separator is a pipe symbol ("|"). List mode is especially useful when you are going to send the output of a query to another program (such as AWK) for additional processing.

@@ Line 70: / Line 70: @@
 atau menjalankan perintah query yang sudah prepackge.
-For a listing of the available dot commands, you can enter ".help" at any time. For example:
+Untuk memperoleh daftar perintah dot yang tersedia,
-    sqlite> .help
+ sqlite> .help
-    .backup ?DB? FILE      Backup DB (default "main") to FILE
+ .backup ?DB? FILE      Backup DB (default "main") to FILE
-    .bail ON|OFF           Stop after hitting an error.  Default OFF
+ .bail ON|OFF           Stop after hitting an error.  Default OFF
-    .databases             List names and files of attached databases
+ .databases             List names and files of attached databases
-    .dump ?TABLE? ...      Dump the database in an SQL text format
+ .dump ?TABLE? ...      Dump the database in an SQL text format
-    .echo ON|OFF           Turn command echo on or off
+ .echo ON|OFF           Turn command echo on or off
-    .exit                  Exit this program
+ .exit                  Exit this program
-    .explain ON|OFF        Turn output mode suitable for EXPLAIN on or off.
+ .explain ON|OFF        Turn output mode suitable for EXPLAIN on or off.
-    .genfkey ?OPTIONS?     Options are:
+ .genfkey ?OPTIONS?     Options are:
-                             --no-drop: Do not drop old fkey triggers.
+                          --no-drop: Do not drop old fkey triggers.
-                             --ignore-errors: Ignore tables with fkey errors
+                          --ignore-errors: Ignore tables with fkey errors
-                             --exec: Execute generated SQL immediately
+                          --exec: Execute generated SQL immediately
-                           See file tool/genfkey.README in the source
+                        See file tool/genfkey.README in the source
-                           distribution for further information.
+                        distribution for further information.
-    .header(s) ON|OFF      Turn display of headers on or off
+ .header(s) ON|OFF      Turn display of headers on or off
-    .help                  Show this message
+ .help                  Show this message
-    .import FILE TABLE     Import data from FILE into TABLE
+ .import FILE TABLE     Import data from FILE into TABLE
-    .indices TABLE         Show names of all indices on TABLE
+ .indices TABLE         Show names of all indices on TABLE
-    .iotrace FILE          Enable I/O diagnostic logging to FILE
+ .iotrace FILE          Enable I/O diagnostic logging to FILE
-    .load FILE ?ENTRY?     Load an extension library
+ .load FILE ?ENTRY?     Load an extension library
-    .mode MODE ?TABLE?     Set output mode where MODE is one of:
+ .mode MODE ?TABLE?     Set output mode where MODE is one of:
-                             csv      Comma-separated values
+                          csv      Comma-separated valu
-                             column   Left-aligned columns.  (See .width)
+                          column   Left-aligned columns.  (See .width)
                               html     HTML <table> code
                               insert   SQL insert statements for TABLE
@@ Line 101: / Line 102: @@
                               tabs     Tab-separated values
                               tcl      TCL list elements
-    .nullvalue STRING      Print STRING in place of NULL values
+ .nullvalue STRING      Print STRING in place of NULL values
-    .output FILENAME       Send output to FILENAME
+ .output FILENAME       Send output to FILENAME
-    .output stdout         Send output to the screen
+ .output stdout         Send output to the screen
-    .prompt MAIN CONTINUE  Replace the standard prompts
+ .prompt MAIN CONTINUE  Replace the standard prompts
-    .quit                  Exit this program
-    .read FILENAME         Execute SQL in FILENAME
+ .quit                  Exit this program
-    .restore ?DB? FILE     Restore content of DB (default "main") from FILE
+ .read FILENAME         Execute SQL in FILENAME
-    .schema ?TABLE?        Show the CREATE statements
+ .restore ?DB? FILE     Restore content of DB (default "main") from FILE
-    .separator STRING      Change separator used by output mode and .import
+ .schema ?TABLE?        Show the CREATE statements
-    .show                  Show the current values for various settings
+ .separator STRING      Change separator used by output mode and .import
-    .tables ?PATTERN?      List names of tables matching a LIKE pattern
+ .show                  Show the current values for various settings
-    .timeout MS            Try opening locked tables for MS milliseconds
+ .tables ?PATTERN?      List names of tables matching a LIKE pattern
-    .timer ON|OFF          Turn the CPU timer measurement on or off
+ .timeout MS            Try opening locked tables for MS milliseconds
-    .width NUM NUM ...     Set column widths for "column" mode
+ .timer ON|OFF          Turn the CPU timer measurement on or off
-    sqlite>
+ .width NUM NUM ...     Set column widths for "column" mode
 ==Changing Output Formats==

@@ Line 61: / Line 61: @@
 schema untuk tabel TEMPORARY di simpan di tabel khusus bernama "sqlite_temp_master". Tabel "sqlite_temp_master" sebetulnya juga tabel temporary / sementara.
-==Special commands to sqlite3==
+==Perintah khusus di sqlite3==
-Most of the time, sqlite3 just reads lines of input and passes them on to the SQLite library for execution. But if an input line begins with a dot ("."), then that line is intercepted and interpreted by the sqlite3 program itself. These "dot commands" are typically used to change the output format of queries, or to execute certain prepackaged query statements.
+Umumnya, sqlite3 hanya membaca tulisan yang masuk dan memberikan masukan tersebut SQLite library untuk di jalankan.
 For a listing of the available dot commands, you can enter ".help" at any time. For example:

@@ Line 57: / Line 57: @@
 Kita tidak dapat secara manual mengubah tabel sqlite_master.
-The schema for TEMPORARY tables is not stored in the "sqlite_master" table since TEMPORARY tables are not visible to applications other than the application that created the table. The schema for TEMPORARY tables is stored in another special table named "sqlite_temp_master". The "sqlite_temp_master" table is temporary itself.
+schema untuk tabel TEMPORARY tidak di simpan dalam table "sqlite_master" karena tabel TEMPORARY
 ==Special commands to sqlite3==