Run:
sqlite -help
...and see the sqlite's command line syntax. You should give then db
filename as an parameter. Otherwise DB will be created in the memory and not
saved.
Best regards,
Witold
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Saturday,
Try:
sqlite>.schema TableName
...will display table definition.
Best regards,
Witold
rsync could be better.
Best Regards,
Witold
And is there a way to automatically replicate the database to a second
system?
Copying the database file should give you an exact replica.
http://www.sqlite.org/autoinc.html
try INTEGER PRIMARY KEY (no interger :-)
Best regards,
Witold
- Original Message -
From: "alok" <[EMAIL PROTECTED]>
To:
Sent: Monday, April 04, 2005 12:21 PM
Subject: [sqlite] How to create Auto Increment Field in SQlite
I am
You don't need to register. Just place the ticket:
http://www.sqlite.org/cvstrac/tktnew
Best regards,
Witold
- Original Message -
From: "David Wheeler" <[EMAIL PROTECTED]>
To: "SQLite Users"
Sent: Friday, March 18, 2005 9:06 PM
Subject: [sqlite] How do I
I strongly suggest to use pysqlite. APSW may be more powerfull in some areas
but is not complaint with the python standard DB access API. If you will use
pysqlite: 1) you will learn Python standard DBAPI 2) you will able to easly
(relativly) migrate to another DB engine in future (mysql,
Sometimes IFNULL function can be also enough
(http://sqlite.org/lang_expr.html).
- Original Message -
From: "Witold Czarnecki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, March 06, 2005 2:21 PM
Subject: Re: [sqlite] Does sqlite has isnull f
You may use operator "ISNULL" instead. For example "SELECT x FROM table
WHERE y ISNULL".
Best reagrds,
Witold
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Sunday, March 06, 2005 2:12 PM
Subject: [sqlite] Does sqlite has isnull function?
Hi All,
I
Are there spaces in [Company Name] and [Contact Name] field names?
Regards,
Witold
- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 24, 2005 4:40 PM
Subject: [sqlite] more syntax errors ?
fastmac:/applications/sqlite
ive to look into?
Best regards
Jan
- Original Message -
From: "Witold Czarnecki" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 22, 2005 8:45 PM
Subject: Re: [sqlite] New to SQLite...23
There is good PHP/SQLite introduction here
There is good PHP/SQLite introduction here:
http://www.zend.com/php5/abs/php101-9.php
Best regards,
Witold
- Original Message -
From: "Jan Ekström" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, February 22, 2005 8:36 PM
Subject: Re: [sqlite] New to
Are all operations in the trigger succeed or fail as a unit? Two updates for
example. Or should I start the transaction before trigger firing?
Best regards,
Witold
Hello,
two questions:
1.
SELECT TYPEOF(ROUND(1));
... returns 'text'. Is it OK? Sorry, I asked this question 2 days ago but I
still don't know - is it a bug or not?
2.
sqlite> CREATE TABLE test(id INTEGER NOT NULL PRIMARY KEY UNIQUE, fld
INTEGER);
sqlite> INSERT INTO test(fld) VALUES(1);
3.0.8
- Original Message -
From: "Ulrik Petersen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, February 19, 2005 11:57 AM
Subject: Re: [sqlite] Is it bug?
Witold Czarnecki wrote:
sqlite> select typeof(round(1));
text
Is it bug?
What version?
Ulrik Petersen
sqlite> select typeof(round(1));
text
Is it bug?
Best regards,
Witold
SELECT name FROM sqlite_master WHERE type = 'table'
Best regards,
Witold Czarnecki
- Original Message -
From: "Sijmen Mulder" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, February 17, 2005 3:22 PM
Subject: Re: [sqlite] Getting metadata
PRAGMA
PRAGMA table_info(table-name);
http://sqlite.org/pragma.html
- Original Message -
From: "Sijmen Mulder" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 17, 2005 3:03 PM
Subject: [sqlite] Getting metadata
Hi there,
Is there a way to get information about the
Sent: Friday, February 11, 2005 12:16 AM
Subject: Re: [sqlite] TYPEOF in triggers
On Thu, 2005-02-10 at 23:59 +0100, Witold Czarnecki wrote:
sqlite> CREATE TABLE test(a NUMERIC);
sqlite> CREATE TRIGGER test1 BEFORE INSERT ON test FOR EACH ROW BEGIN
...> SELECT CASE WHEN (TYPEOF(NEW.a)
Can you help?:
sqlite> CREATE TABLE test(a NUMERIC);
sqlite> CREATE TRIGGER test1 BEFORE INSERT ON test FOR EACH ROW BEGIN
...> SELECT CASE WHEN (TYPEOF(NEW.a) != 'numeric') THEN RAISE(ABORT,
'Error!') END;
...> END;
sqlite> INSERT INTO test VALUES('aaa');
sqlite> SELECT TYPEOF(a) FROM
You may try:
SELECT NULL FROM sqlite_master WHERE tbl_name = 'table';
- Original Message -
From: "Asko Kauppi" <[EMAIL PROTECTED]>
To:
Sent: Thursday, February 10, 2005 5:08 PM
Subject: Re: [sqlite] would someone check my SQL..
Is it true that in SQLite one has
20 matches
Mail list logo