Donate Share

Mogwai Java Tools

Tracker: Bugs

5 [ERDesigner] MySQL auto_increment - ID: 1435994
Last Update: Comment added ( mirkosertic )

Hi,

I'm using ERDesgner, and when generating SQL for MySql,
sequenced id are not generated as aut_increment mysql
fields...

Is it possible to add that capability, specially for
primary keys ?

See you


newbeewan ( newbeewan ) - 2006-02-21 15:57

5

Closed

None

Mirko Sertic

SQL generation

ERDesigner support

Public


Comment ( 1 )




Date: 2006-02-24 13:15
Sender: mirkoserticProject AdminAccepting Donations

Logged In: YES
user_id=402529

Hi,

thanks for using ER-Designer.

The sequence generator only works for oracle databases. To
use auto_increment columns on MySQL, you can do the
following :

1. create a new domain, lets call it dom_id
2. define the datatype as "integer auto_increment primary
key";
3. assign this domain to your primary key column and set the
Is primary key attribute to true.

It's a kind of ugly workaround, but is working :-)

Let me tknow if you've got further questions.

Mirko


Log in to comment.

Attached File

No Files Currently Attached

Changes ( 4 )

Field Old Value Date By
status_id Open 2006-02-24 13:15 mirkosertic
assigned_to nobody 2006-02-24 13:15 mirkosertic
summary MySQL auto_increment 2006-02-24 13:15 mirkosertic
close_date - 2006-02-24 13:15 mirkosertic