dump文件的导入
qyxc 2002-05-20 04:28:02 文件名是mydb.dump,内容为
CREATE TABLE employees ( id tinyint(4) DEFAULT 0 NOT NULL
AUTO_INCREMENT, first varchar(20), last varchar(20),
address varchar(255), position varchar(50), PRIMARY KEY (id),
UNIQUE id (id));INSERT INTO employees VALUES (1,Bob,Smith,
128 Here St, Cityname,Marketing Manager);
INSERT INTO employees VALUES (2,John,Roberts,45 There St , Townville,Telephonist);
INSERT INTO employees VALUES (3,Brad,Johnson,1/34 Nowhere Blvd, Snowston,Doorman);
用下面的命令加到数据库mydb中
mysql -uroot -pstar mydb < mydb.dump
出现提示
ERROR 1064 at line 1: You have an error in your SQL syntax near 'Here St, Cityname,Marketing Manager>'at line 2
请告诉我这个文件到底作了什么,因为我完全不会MYSQL!
谢谢!