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