Hi,
> Good evening people.
>
> I'm trying to create a simple table via MySQl Navigator.
> The table il structured in this way
>
> dt_amt Date Not Null Primary Key
> oper INT Not Null Primary Key
> amount Decimal(3,3) Null ---
>
> but when I choose "fire" it shows me a "multiple primary key define
Mayuran wrote:
Ive never used MySQL navigator, but I think you should assign the
primary keys
in the same line, like so:
dt_amtDateNot Null
operINTNot Null
amountDecimal(3,3)Null
primary key (dt_amt, oper)
thats, ok. It's a sql navigator bug! I had created the tabl
At 20:50 +0100 11/26/03, getting_out wrote:
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amt DateNot NullPrimary Key
operINT Not NullPrimary Key
amount Decimal(3,3)Null
getting_out wrote:
Good evening people.
I'm trying to create a simple table via MySQl Navigator.
The table il structured in this way
dt_amtDateNot NullPrimary Key
operINTNot NullPrimary Key
amountDecimal(3,3)Null---
but when I choose "fire" it shows
