Subject | Re: [ib-support] Re: [IB-Conversions] Porting from mysql to firebird |
---|---|
Author | Ulrich_Groffy |
Post date | 2003-02-22T11:09:09Z |
Hello,
what is the difference between NUMERIC(18,0) and the FB 1.5 type BIGINT?
Best regards Ulrich
what is the difference between NUMERIC(18,0) and the FB 1.5 type BIGINT?
Best regards Ulrich
>
> There is no auto-increment type. Declare the column as a NUMERIC(18,0)
> type which is the 64-bit integer and use a generator to populate it. To
> make the engine automatically insert the next value of the generator each
> time a row is inserted, write a Before Insert trigger, e.g.
> CREATE GENERATOR GEN_ATABLE;
>