I just tried with your definition and it worked fine.
Johan Andersson schrieb am Montag, 6. August 2001, 14:03:42:
> 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
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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