From: Paul DuBois
Date: March 18 1999 12:39pm
Subject: Re: Newbie create table problem
List-Archive: http://lists.mysql.com/win32/20
Message-Id: <v04020a00b316a448a2b5@[192.168.0.5]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 2:46 AM -0600 3/18/1999, Malte Andreasson wrote:
>I'm just about going nuts here over this problem. I give the command
>
>mysql < skapa.txt
>
>and the file skapa.txt looks like this:
>
>use ecce;
>create table hela (
>datum date,
>kanal tinyint,
>vdag tinyint,
>tid time,
>pgm varchar,
>tusen int,
>pct float,
>man float,
>kvinnor float,
>iiitvi float,
>viitx float,
>xitxiv float,
>xvtxxiv float,
>xxvtxxxix float,
>xltlix float,
>lxplus float,
>xvtxxix float,
>xvtxxxiv float,
>xvtxliv float,
>xvtlix float,
>xxvtlix float,
>mxvtxxxiv float,
>kxvtxxxiv float,
>mxvtlix float,
>kxvtlix float,
>lengd time,
>andel float,
>vidd float);
>
>It *should* work, in my opinion -- nevertheless, I get parse errors. Anyone
>see right away what my problem is?

What's the length of your VARCHAR field?  The syntax is VARCHAR(n),
where 1<=n<=255.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/