Andreas Ntaflos wrote:
>
> But it seems I misunderstood the point of AUTOINCREMENT. I am looking for
> something like PostgreSQL's SERIAL data type [1] so when creating new rooms I
> don't have to manually specify the roomID. Instead the next possible roomID
> should be chosen automatically whe
On Friday 05 September 2008 21:57:30 Igor Tandetnik wrote:
> Andreas Ntaflos
>
> <[EMAIL PROTECTED]> wrote:
> > this question is about the AUTOINCREMENT usage in SQLite when
> > modelling weak entities. Suppose there are two tables 'Building' and
> > 'Room':
> >
> > CREATE TABLE Building (
> >b
Andreas Ntaflos
<[EMAIL PROTECTED]> wrote:
> this question is about the AUTOINCREMENT usage in SQLite when
> modelling weak entities. Suppose there are two tables 'Building' and
> 'Room':
>
> CREATE TABLE Building (
>buildingID INTEGER PRIMARY KEY AUTOINCREMENT,
>...
> );
>
> CREATE TABLE R
3 matches
Mail list logo