Well, it's not so unsuitable. For luck, a simple replacement could solve
the problem. I asked only because I thought there was a pattern. If not,
let's go to the replacements!
Em 15/11/2011 10:15, Simon Slavin escreveu:
On 15 Nov 2011, at 11:27am, Luciano de Souza wrote:
With the clause
Hi listers,
With the clause "integer primary key", we can create an
autoincrementable field in Sqlite. Other databases uses auto_increment,
serial and something else.
If I am not wrong, Sqlite uses also auto_int. But, if I would build a
database readable by other databases, what is the
Hi listers,
Suppose I have a file called "audio.wav" and I want to store it inside a
database. If I correctly understood, I could create a table like that:
create table test
(
id integer primary key,
name text not null,
file blob not null
);
I have never dealt with blob fields, so perhaps
Från: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] För Luciano de Souza
> Skickat: den 3 januari 2010 19:05
> Till: General Discussion of SQLite Database
> Ämne: Re: [sqlite] Foreign key support in Sqlite
>
> I can't comprehend! I downloaded the two packs in c:\t
Oh! Sorry! I didn't read Igor's message. I will read the article and
certainly I will get the result! Sorry again!
Jean and Igor, thank you!
- Original Message -
From: "Luciano de Souza" <luchya...@predialnet.com.br>
To: "General Discussion of SQLite Database"
I can't comprehend! I downloaded the two packs in c:\test. Three files were
unpacked: sqlite3.exe, sqlite3.dll and sqlite3.def.
I created the database:
c:> sqlite3 test.db
I create the structure:
sqlite> .read test.sql
The test.sql contains the statements mentioned before.
I tried to insert
Everything downloaded correctly, but there is still something wrong. Perhaps
my very short experience in SQL resulted in any statement mistake.
Let me show again how the tables are created and the data inserted:
create table cities
(
id integer primary key not null,
name text not null
);
create
.
Is there something wrong? I need to do something to enable the foreign key
support?
This is my first message to the list. It's a pleasure for me to join the Sqlite
community.
Luciano de Souza
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
8 matches
Mail list logo