List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:December 13 1999 1:32pm
Subject:Re: syntax error generated when using TEXT and BLOB datatypes
View as plain text  
At 5:38 AM -0500 1999-12-12, root wrote:
>  >Description:
>	Cannot use datatype TEXT or BLOB when creating or altering a 
>table, keep getting syntax error near '(500))' 
>>How-To-Repeat:
>	alter table products (
>vitamins TEXT(500)
>);


BLOB and TEXT types don't take a length in MySQL.  See the manual for
information on the type names and how to use them to select the (approximate)
length you want.

-- 
Paul DuBois, paul@stripped
Thread
syntax error generated when using TEXT and BLOB datatypesroot12 Dec
  • Re: syntax error generated when using TEXT and BLOB datatypessinisa13 Dec
  • Re: syntax error generated when using TEXT and BLOB datatypesPaul DuBois13 Dec