Re: text type

[Sasha Pachev]

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
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)