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!