<p>The final line of the example (the ".system c:/work/dataout.csv")
has the same effect as double-clicking on the c:/work/dataout.csv file
in windows. This will typically bring up a spreadsheet program to display
the CSV file. That command only works as shown on Windows. The
equivalent line on a Mac would be ".system open /work/dataout.csv".
On Linux and other unix systems you will need to enter something like
".system libreoffice /work/dataout.csv", substituting your perferred
CSV viewing program for "libreoffice".
<h3>Converting An Entire Database To An ASCII Text File</h3>
<p>Use the ".dump" command to convert the entire contents of a
database into a single ASCII text file. This file can be converted
back into a database by piping it back into <b>sqlite3</b>.</p>

|

618
619
620
621
622
623
624
625
626
627
628
629
630
631
632

<p>The final line of the example (the ".system c:/work/dataout.csv")
has the same effect as double-clicking on the c:/work/dataout.csv file
in windows. This will typically bring up a spreadsheet program to display
the CSV file. That command only works as shown on Windows. The
equivalent line on a Mac would be ".system open /work/dataout.csv".
On Linux and other unix systems you will need to enter something like
".system libreoffice /work/dataout.csv", substituting your preferred
CSV viewing program for "libreoffice".
<h3>Converting An Entire Database To An ASCII Text File</h3>
<p>Use the ".dump" command to convert the entire contents of a
database into a single ASCII text file. This file can be converted
back into a database by piping it back into <b>sqlite3</b>.</p>

update, your database is safe. The database is safe even if your OS
crashes or takes a power loss. The crash-resistance of SQLite has
been extensively studied and tested and is attested by years of real-world
experience by billions of users.</p>
<p>That said, there are a number of things that external programs or bugs
in your hardware or OS can do to corrupt a database file. See
<a href="howtocorrupt.html">How To Corrupt An SQLite DAtabase File</a> for
further information.
<p>Your can use <a href="pragma.html#pragma_integrity_check">PRAGMA integrity_check</a>
to do a thorough but time intensive test of the database integrity.</p>
<p>Your can use <a href="pragma.html#pragma_quick_check">PRAGMA quick_check</a> to do a faster
but less thorough test of the database integrity.</p>
................................................................................
faq {
Does SQLite support foreign keys?
} {
<p>
As of version 3.6.19, SQLite supports [foreign key constraints]. But enforcement
of foreign key constraints is turned off by default (for backwards compatibility).
To enable foreign key constraint enforcements, run
[PRAGMA foreign_keys|PRAGMA foreign_keys=ON] or compile with
[SQLITE_DEFAULT_FOREIGN_KEYS | -DSQLITE_DEFAULT_FOREIGN_KEYS=1].
}
faq {
I get a compiler error if I use the SQLITE_OMIT_...
compile-time options when building SQLite.
................................................................................
application, that might change the ECCN in your particular case.
}
faq {
My query does not return the column name that I expect. Is this a bug?
} {
If the columns of your result set are named by AS clauses, then SQLite
is guaranteed to use the identifer to the right of the AS keyword as the
column name. If the result set does not use an AS clause, then SQLite
is free to name the column anything it wants.
See the [sqlite3_column_name()] documentation for further information.
}
# End of questions and answers.
#############

update, your database is safe. The database is safe even if your OS
crashes or takes a power loss. The crash-resistance of SQLite has
been extensively studied and tested and is attested by years of real-world
experience by billions of users.</p>
<p>That said, there are a number of things that external programs or bugs
in your hardware or OS can do to corrupt a database file. See
<a href="howtocorrupt.html">How To Corrupt An SQLite Database File</a> for
further information.
<p>Your can use <a href="pragma.html#pragma_integrity_check">PRAGMA integrity_check</a>
to do a thorough but time intensive test of the database integrity.</p>
<p>Your can use <a href="pragma.html#pragma_quick_check">PRAGMA quick_check</a> to do a faster
but less thorough test of the database integrity.</p>
................................................................................
faq {
Does SQLite support foreign keys?
} {
<p>
As of version 3.6.19, SQLite supports [foreign key constraints]. But enforcement
of foreign key constraints is turned off by default (for backwards compatibility).
To enable foreign key constraint enforcement, run
[PRAGMA foreign_keys|PRAGMA foreign_keys=ON] or compile with
[SQLITE_DEFAULT_FOREIGN_KEYS | -DSQLITE_DEFAULT_FOREIGN_KEYS=1].
}
faq {
I get a compiler error if I use the SQLITE_OMIT_...
compile-time options when building SQLite.
................................................................................
application, that might change the ECCN in your particular case.
}
faq {
My query does not return the column name that I expect. Is this a bug?
} {
If the columns of your result set are named by AS clauses, then SQLite
is guaranteed to use the identifier to the right of the AS keyword as the
column name. If the result set does not use an AS clause, then SQLite
is free to name the column anything it wants.
See the [sqlite3_column_name()] documentation for further information.
}
# End of questions and answers.
#############

This page was generated in about
0.007s by
Fossil 2.10 [b94e15cff7] 2019-09-13 13:54:36