> The ".import" command of the command line program that comes with sqlite
> works. If you need something that doesn't do check out my program, see
> the
> links below. You should also check out a text editor that has macros and
> regular expression search and replace. 180 lines isn't much harder
Jay Sprenkle wrote:
The ".import" command of the command line program that comes with sqlite
works. If you need something that doesn't do check out my program, see
the
links below. You should also check out a text editor that has macros and
regular expression search and replace. 180 lines
On Fri, 1 Sep 2006, Jay Sprenkle wrote:
The ".import" command of the command line program that comes with sqlite
works.
Thank you, Jay. I missed that.
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|
On 9/1/06, Rich Shepard <[EMAIL PROTECTED]> wrote:
Is there a command to bulk load data (in comma and quote format) into a
table? I'd hate to copy 180 lines x 31 attributes by individually.
The ".import" command of the command line program that comes with sqlite
works. If you need
On Fri, 1 Sep 2006, Sergio 'OKreZ' Agosti wrote:
http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator
Sergio,
Thank you. I'll need to re-do the tables now that I see that I can get the
constraints that are needed.
Rich
--
Richard B. Shepard, Ph.D.
On 01/set/06, at 15:16, Rich Shepard wrote:
Is there a way to write SQL statements that perform the same
referential
integrity checks as if foreign keys were available for constraints?
http://www.rcs-comp.com/site/index.php/view/Utilities-
SQLite_foreign_key_trigger_generator
I'm using sqlite3 in an application, and I think that I've read all the
docs. A search of the archives didn't reveal any threads that answer my two
questions so I'll ask them here. If there's something in the archives or a
doc that I missed, please point me to it.
Is there a way to write SQL
7 matches
Mail list logo