I have a problem with key creation :

Server version: 4.0.4-beta-max-nt  Binary version
PC : DELL OPTIPLEX GX100
OS : Windows 2000 Professional
RAM: 256 Mb




C:\mysql\bin>mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.4-beta-max-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use repos

Database changed

mysql> CREATE TABLE property (
    ->   serialno int(11) NOT NULL default '0',
    ->   ns_id int(11),
    ->   name varchar(255) NOT NULL default '',
    ->   value text,
    ->   KEY serialidx (serialno),
    ->   KEY nvidx (name,value(245))
    -> ) TYPE=MyISAM;

ERROR 1005: Can't create table '.\repos\property.frm' (errno: 140)


mysql> CREATE TABLE property (
    ->   serialno int(11) NOT NULL default '0',
    ->   ns_id int(11),
    ->   name varchar(255) NOT NULL default '',
    ->   value text,
    ->   KEY serialidx (serialno),
    ->   KEY nvidx (name,value(236))
    -> ) TYPE=MyISAM;

Query OK, 0 rows affected (0.05 sec)



mysql>

236 Is the maximum permitted length , I don't know why.

Bye,

            Luca Barba




---------------------------------------------------------------------
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