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 defined
message
a multiple primary key defined
message and doesn't make me create the table.
Isn't MySql able to handle multiple primary key or it's a navigator bug?
In the same day I can receive data from different operators.
Thanks in advance D.
--
MySQL General Mailing List
For list archives: http
me a multiple primary key defined
message and doesn't make me create the table.
Isn't MySql able to handle multiple primary key or it's a navigator bug?
In the same day I can receive data from different operators.
Thanks in advance D.
Ive never used MySQL navigator, but I think you should
---
but when I choose fire it shows me a multiple primary key defined
message and doesn't make me create the table.
Isn't MySql able to handle multiple primary key or it's a navigator bug?
You cannot define multiple primary keys using PRIMARY KEY. The name of
a PRIMARY KEY is PRIMARY
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