There might be limitation on length of index in mysql
try this
CREATE TABLE `adminpages` (
`adminpageid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`file_name` VARCHAR( 250 ) NOT NULL ,
`page_title` VARCHAR( 250 ) NOT NULL ,
PRIMARY KEY ( `adminpageid` ) ,
INDEX ( `file_name` , `page_title` )
At 21:29 -0400 10/24/01, [EMAIL PROTECTED] wrote:
>Greeting! I am trying to convert an application from a DB2 based
>program to MySQL. We are still evaluating MySQL and learning.
>We are using Java and the JDBC driver mm.mysql.jdbc-1.2c to
>create the database. The Java version of this program usi
On Fri, 23 Mar 2001, Daniel Adams wrote:
> Can someone please tell me what the problem is below. All I am trying to
> do is pipe a backup created with mysqldump into mysql and it gives me
> this error:
>
> ERROR 1071 at line 1291: Specified key was too long. Max key length is
> 500
It is exc
