Hi!
Something like
CREATE TABLE CAMELON (A INT NOT NULL AUTO_INCREMENT, B CHAR (5),
PRIMARY KEY (A)) TYPE = INNODB;
Regards,
Heikki
http://www.innodb.com
At 02:01 PM 9/18/01 +0900, you wrote:
>Hi, Heikki.
>
>Thanks for the info.
>
>I understand your first explanation, I'll try.
>
>> You can probably circumvent the problem by
>> adding an extra VARCHAR column where you put
>> the first 255 characters of the blob column.
>
>Would you please inform me more externation of second.
>Can you give me an examples?
>
>> Or maybe you could generate an artificial
>> primary key with auto-increment, for example?
>
>--
>Best regards.
>
>
>----- Original Message -----
>From: "Heikki Tuuri" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Thursday, September 13, 2001 12:50 AM
>Subject: Re:ERROR 1073: create InnoDB tables!
>
>
>> Hi!
>>
>> You can probably circumvent the problem by
>> adding an extra VARCHAR column where you put
>> the first 255 characters of the blob column.
>> Or maybe you could generate an artificial
>> primary key with auto-increment, for example?
>>
>> Regards,
>>
>> Heikki
>> http://www.innodb.com
>>
>> >Hi,
>> >I tried create table specify "type=InnoDB".with the following script:
>> > >create table objects(uri blob not null, primary key uriIndex (uri(255)),
>> > classname blob) type=InnoDB;I'm getting the following error
>> > ERROR 1073: BLOB column 'uri' can't be used in key specification with
>> the used \
>> >table typeThis is what I found in the mySQL docs:
>> >* Only the MyISAM table type supports indexing on BLOB and TEXT columns.
>> When putting \
>> >an index on a BLOB or TEXT column you MUST always specify the length of the
>> index:
>> > CREATE TABLE test (blob_col BLOB, index(blob_col(10)));
>> >I could change the uri to varchar but...
>> >* Values in VARCHAR columns are variable-length strings. I can declare a
>> VARCHAR \
>> >column to be any length between 1 and 255, just as for CHAR columns.
>> >That's not very good, we can choose- transactions but uri limited to 255
chars
>> >- no limit but also no transactions
>> >Is it supported ? If yes, please let me know how?Any help is welcome.
>>
>
>
>
---------------------------------------------------------------------
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
