Hi,
md5 is a function name, maybe that's why you need to quote the field
name. Check the MySQL manual about that.
On Thu, 2003-02-20 at 10:51, [EMAIL PROTECTED] wrote:
> >Description:
> syntax checker reject length restriction when index char column
> with ending by number.
>
> >How-To-R
>Description:
syntax checker reject length restriction when index char column
with ending by number.
>How-To-Repeat:
alter table xmlmd5 add index md5 (md5(10));
ERROR 1064: You have an error in your SQL syntax near 'md5(10))' at line 1
column definition of md5 is md