Re: Re:ERROR 1073: create InnoDB tables!
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
Re: Re:ERROR 1073: create InnoDB tables!
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
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