I'm trying to create tables in Mysql via redirection input from file.
createservices.sql file:
CREATE TABLE services (
ID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
description VARCHAR(255) NOT NULL
)
At mysql prompt: mysql> < createservices.sql
Result (no matter what I try, I tried absolute path, too):
ERROR 1064: You have an error in your SQL syntax near '< createservices.sql' at
line 1
I can manually create table, but who wants to enter a table of say 20 items and have a syntax error? Very frustrating can you give insight?
Thanks Gary
createservices.sql file:
CREATE TABLE services (
ID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
description VARCHAR(255) NOT NULL
)
At mysql prompt: mysql> < createservices.sql
Result (no matter what I try, I tried absolute path, too):
ERROR 1064: You have an error in your SQL syntax near '< createservices.sql' at
line 1
I can manually create table, but who wants to enter a table of say 20 items and have a syntax error? Very frustrating can you give insight?
Thanks Gary