Hi,
I cannot find my answer of this problem in the manual.

When trying to add the table below to mysql (3.23.36) I get the
error that says the index is too long.
But how can it complain about a index in this table when no index
is defined for this table? Do mysql create a pseudo primary key when
no primary key is defined?


CREATE TABLE NPGE_RETTEN_TMP (
 NP_NR NUMERIC(7,0) NOT NULL,
 GE_NR NUMERIC(18,0) NOT NULL,
 ORTSANGABE VARCHAR(100),
 TELEFON_NR VARCHAR(50),
 TELEFAX_NR VARCHAR(50),
 TEL_VORWAHL VARCHAR(20),
 BUCHTITEL VARCHAR(100),
 ANREDETITEL VARCHAR(20),
 BT_SCHLUESSEL VARCHAR(5),
 BEMERKUNG VARCHAR(100),
 LOESCHKZ VARCHAR(1),
 U_VERSION VARCHAR(1)
);


Normally, I've got this error when using KEY(x, y, x) where the
column length of x, y and z overrides 500 chars.


Help, anyone?


Regards,
Johan Andersson



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to