In article [EMAIL PROTECTED], Sinisa
Milivojevic [EMAIL PROTECTED] writes
MattJ wrote:
It's still possible in the mysql client to request the creation
of an index with indexlength NULL on TEXT fields. This apparently
works okay on creation of the index, insert and select operations, but
Dear
Dose anyone know, if i install MySql in NFS, are there any problem? and is
that a good idea? why?
lei shen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
You wrote:
Description:
Documentation section 6.5.7 regarding create index states: For CHAR and
VARCHAR columns, indexes can be created that use only part of a column, using
col_name(length) syntax. (On BLOB and TEXT columns the length is required.)
It's still possible in the
Hi!
cut
How-To-Repeat:
Create table with field-type of TEXT.
CREATE INDEX AnyName ON Table(TextField);
Issue an update to a pre-existing record for the incorrectly indexed
TextField.
Fix:
mysql should throw an error to the client if request is made to
In article [EMAIL PROTECTED], Michael Widenius
[EMAIL PROTECTED] writes
I just tested this with the upcoming MySQL 4.0.1:
mysql create table t1 (a text);
Query OK, 0 rows affected (0.01 sec)
mysql CREATE INDEX t1 ON t1(a);
ERROR 1170: BLOB column 'a' used in key specification without a key
Thank you for your report.
We shall check it out.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
___/
Description:
Documentation section 6.5.7 regarding create index states: For CHAR and
VARCHAR columns, indexes can be created that use only part of a column, using
col_name(length) syntax. (On BLOB and TEXT columns the length is required.)
It's still possible in the mysql client