From: Levy Carneiro Jr.
Date: March 17 1999 8:28pm
Subject: Error with batch files
List-Archive: http://lists.mysql.com/mysql/447
Message-Id: <Pine.LNX.3.96.990317171449.19790A-100000@slave.fractal.com.br>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII


	Hi,

	I maked a batch file with SQL commands to create a table in a
database. Here is a example from the file:

------ here begins ------

# batch.mysql
CREATE TABLE document_config_table (
  body_bg_color text(999),
  body_background_file text(999),
  body_text_color text(999),
  body_link_color text(999),
  body_vlink_color text(999),
  body_alink_color text(999),
  document_id double,
  horde_user_id double(FK) (IE)
);

------ here ends ------

	When I tries the following command appears an error:

[server:~] mysql table_name -p < batch.mysql
Enter password: ********
ERROR 1064 at line 4: You have an error in your SQL sysntax near '(999),
  body_background_file text(999),
  body_text_color text(999),
  body_lin' at line 2
[server:~]

	Does somebody know what is wrong?


	Thanks in advance,
_______________________________________
Levy Carneiro Jr.	<levy@stripped>
Jesus loves you!