Re: [sqlite] An interchangeable autoincremental field

2011-11-15 Thread Luciano de Souza
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 "int

Re: [sqlite] An interchangeable autoincremental field

2011-11-15 Thread Simon Slavin
On 15 Nov 2011, at 11:27am, Luciano de Souza wrote: > 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 > dat

[sqlite] An interchangeable autoincremental field

2011-11-15 Thread Luciano de Souza
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 best