List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:March 18 1999 12:39pm
Subject:Re: Newbie create table problem
View as plain text  
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/
Thread
Newbie create table problem(Malte Andreasson)18 Mar
  • Re: Newbie create table problemPaul DuBois18 Mar