> Ive never used MySQL navigator, but I think you should assign the
> primary keys
> in the same line, like so:
> dt_amt Date Not Null
> oper INT Not Null
> amount Decimal(3,3) Null
> primary key (dt_amt, oper)
thats, ok. It's a sql navigator bug! I had created the table using the
primary key (field_1, filed_2, ...).
I think I'm gonna remove mysql-navigator. I've always used console and i
think it's always better. Slower to use better and more powerful :)
While reading the documentation, I've discovered the command
show create table <table_name>
it's great! I didn't remember some options for creating table but I
remember I've used in another table :)
thanks a lot D.