List:General Discussion« Previous MessageNext Message »
From:Levy Carneiro Jr. Date:March 17 1999 8:28pm
Subject:Error with batch files
View as plain text  

	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

	Does somebody know what is wrong?

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

Error with batch filesLevy Carneiro Jr.17 Mar
Re: Error with batch filesPaul DuBois17 Mar