List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 9 1999 7:09pm
Subject:Re: text type
View as plain text  
Craig Oettle wrote:
> Hi,
> I'm new to MySQL but have been playing with it for a few weeks.  I am
> trying to create a table as follows:
> create table motherboard(
> itemno varchar(30),
> descript text(0),
> list decimal(6,2),
> price decimal(6,2)
> );
> I keep getting the error "you have a syntax error at ,(0) on line 3"  no
> matter what I do to the text entry it always gives this message.  I have
> tried descript text, descript text(), descript TEXT, etc.  I did read
> the manual part about data types and used the create table example
> choosing the "type" text, but no matter how I do it, it won't work.  I'm
> sure it's something simple but I can't see it.
> Suse Linux 6.1, kernel 2.2.7, mysql Ver. 9.32 Dist 3.22.21
> --
> Craig Oettle

It works without (0) just fine, here is stuff copied and pasted from my
mysql client:

mysql> create table motherboard(
    -> itemno varchar(30),
    -> descript text,
    -> list decimal(6,2),
    -> price decimal(6,2)
    -> );
Query OK, 0 rows affected (0.10 sec)

Sasha Pachev (home) (work)
text typeCraig Oettle9 Jul
  • Re: text typeSasha Pachev9 Jul