怎样吧这样的文本文件导入mysql数据库？
CREATE DATABASE fastmail;
use fastmail;
CREATE TABLE alias (
userid varchar(20) DEFAULT '' NOT NULL,
alias varchar(100) DEFAULT '' NOT NULL,
alias_userid varchar(20) DEFAULT '' NOT NULL,
alias_host varchar(100) DEFAULT '' NOT NULL,
KEY userid (userid),
KEY alias (alias),
UNIQUE user_alias (userid,alias,alias_userid,alias_host)
);
INSERT INTO alias VALUES( 'alias', 'root', 'admin', '');
INSERT INTO alias VALUES( 'alias', 'postmaster', '.', '/Maildir/');
INSERT INTO alias VALUES( 'alias', 'mailer-daemon', '/', ' home/mail/mdaemon');
CREATE TABLE mailbox (
userid varchar(20) DEFAULT '' NOT NULL,
uid mediumint(9) DEFAULT '333' NOT NULL,
gid mediumint(9) DEFAULT '333' NOT NULL,
home varchar(100) DEFAULT '' NOT NULL,
password varchar(16) DEFAULT '' NOT NULL,
quota int(10) DEFAULT '5000' NOT NULL,
PRIMARY KEY (userid),
UNIQUE home (home),
KEY password (password)
);
INSERT INTO mailbox VALUES( 'admin', '333', '333', '/home/mail/', '43e9a4ab75570f5b', '5000');
CREATE TABLE rcpthosts (
host varchar(100) DEFAULT '' NOT NULL,
PRIMARY KEY (host)
);
CREATE TABLE virtual (
userid varchar(20) DEFAULT '' NOT NULL,
ext varchar(100) DEFAULT '' NOT NULL,
virtual_userid varchar(20) DEFAULT '' NOT NULL,
virtual_host varchar(100) DEFAULT '' NOT NULL,
PRIMARY KEY (virtual_userid,virtual_host),
KEY (virtual_userid),
KEY (virtual_host),
UNIQUE virtual (userid,ext,virtual_userid,virtual_host)
);
CREATE TABLE folderlist (
userid varchar(20) DEFAULT '' NOT NULL,
folderindex int DEFAULT 0 NOT NULL,
folderid varchar(100) DEFAULT '' NOT NULL,
foldername varchar(20) DEFAULT '' NOT NULL,
type tinyint DEFAULT 0 NOT NULL
);
INSERT INTO folderlist VALUES( 'admin', '30000', 'src', '草稿箱', '0');
INSERT INTO folderlist VALUES( 'admin', '20000', 'snt', '发件箱', '0');
INSERT INTO folderlist VALUES( 'admin', '40000', 'dsb', '垃圾箱', '0');
INSERT INTO folderlist VALUES( 'admin', '10000', 'rev', '收件箱', '0');
CREATE TABLE address (
id int(11) NOT NULL auto_increment,
regdate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
userid varchar(20) NOT NULL,
username varchar(50) NOT NULL,
gender char(2),
location varchar(100),
zipcode varchar(50),
phone varchar(50),
bpcode varchar(50),
handset varchar(50),
email varchar(50),
homepage varchar(50),
birthday date,
PRIMARY KEY (id),
UNIQUE id (id)
);
CREATE TABLE admin (
userid varchar(20) NOT NULL,
password varchar(20) NOT NULL,
username varchar(20) NOT NULL,
PRIMARY KEY (userid),
UNIQUE userid (userid)
);
INSERT INTO admin VALUES( 'admin', '43e9a4ab75570f5b', 'Fastmail默认管理者');
CREATE TABLE profile (
userid varchar(20) NOT NULL,
username varchar(50) NOT NULL,
gender tinyint(4) NOT NULL,
location varchar(100),
zipcode varchar(50),
signature varchar(250),
regdate datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
certificateType tinyint(4),
cardNumber varchar(20),
birthday date DEFAULT '0000-00-00',
province tinyint(4),
education tinyint(4),
occupation tinyint(4),
phone varchar(50),
signup char(1) DEFAULT 'Y',
PRIMARY KEY (userid),
UNIQUE userid (userid)
);
INSERT INTO profile VALUES( 'admin', 'Fastmail默认管理者', '0', '', '610054', '', NOW(), '1', '888888888888888888', '2000-05-08', '21', '4', '8', 'Y','');
问题点数：20、回复次数：4Top
1 楼olvest4000（奥维斯）回复于 2002-04-02 16:17:06 得分 0
关注，好象可以直接运行！！！Top
2 楼jackyanna（Hello World 的疑惑）回复于 2002-04-03 13:18:23 得分 0
1、先进入Mysql安装目录。
2、假如以上文件保存为C:\Data.txt
cd \mysql\bin
mysql <C:\\data.txtTop
3 楼jackyanna（Hello World 的疑惑）回复于 2002-04-03 13:21:44 得分 0
1/应在文本开始出写：
drop database if exists fastmail;
2/假如文本data.txt保存在C:\
3/进入命令提示符下
cd \mysql\bin
mysql <C:\data.txtTop
4 楼jackyanna（Hello World 的疑惑）回复于 2002-04-03 13:24:40 得分 10
cd \mysql\bin
mysql <c:\data.txtTop
5 楼reffox（redfox）回复于 2002-04-06 22:30:53 得分 0
mysql> c:/file.txt;
ERROR 1064: You have an error in your SQL syntax near 'c:/emp.txt' at line 1
mysql>Top
6 楼taozabc（Pluto）回复于 2002-04-08 09:11:12 得分 10
不是在mysql>命令符下，应该在系统提示符下使用mysql命令！Top
