-- MySQL dump 9.08
--
-- Host: localhost Database: jinghua
---------------------------------------------------------
-- Server version 4.0.14-nt--
-- Table structure for table 'errornotepad'
--DROP TABLE IF EXISTS errornotepad;
CREATE TABLE errornotepad (
field1 tinyint(4) default NULL,
ID int(11) default NULL,
StuID int(11) default NULL,
EID int(11) default NULL,
ErrorCount smallint(6) default NULL
) TYPE=MyISAM;--
-- Dumping data for table 'errornotepad'
--
--
-- Table structure for table 'errorpad'
--DROP TABLE IF EXISTS errorpad;
CREATE TABLE errorpad (
id int(11) unsigned NOT NULL auto_increment,
stu_id varchar(50) default NULL,
question_id int(11) unsigned default NULL,
add_date datetime default NULL,
errorcount smallint(11) unsigned default '0',
test_id int(11) unsigned default NULL,
mn_test_id int(11) unsigned default NULL,
review_date datetime default NULL,
sourcetype tinyint(4) unsigned default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;--
-- Dumping data for table 'errorpad'
--INSERT INTO errorpad VALUES (13,'sc010',571,'2003-10-22 10:40:38',2,119,NULL,NULL,2);
INSERT INTO errorpad VALUES (14,'sc010',572,'2003-10-22 10:40:38',1,119,NULL,NULL,2);
INSERT INTO errorpad VALUES (15,'sc010',792,'2003-10-22 11:13:44',3,152,29,NULL,3);
INSERT INTO errorpad VALUES (16,'sc010',793,'2003-10-22 11:13:44',2,152,29,NULL,3);
INSERT INTO errorpad VALUES (17,'sc007',610,'2003-10-22 11:16:36',2,128,18,NULL,3);
INSERT INTO errorpad VALUES (18,'sc007',611,'2003-10-22 11:16:36',2,128,18,NULL,3);
--
-- Host: localhost Database: jinghua
---------------------------------------------------------
-- Server version 4.0.14-nt--
-- Table structure for table 'errornotepad'
--DROP TABLE IF EXISTS errornotepad;
CREATE TABLE errornotepad (
field1 tinyint(4) default NULL,
ID int(11) default NULL,
StuID int(11) default NULL,
EID int(11) default NULL,
ErrorCount smallint(6) default NULL
) TYPE=MyISAM;--
-- Dumping data for table 'errornotepad'
--
--
-- Table structure for table 'errorpad'
--DROP TABLE IF EXISTS errorpad;
CREATE TABLE errorpad (
id int(11) unsigned NOT NULL auto_increment,
stu_id varchar(50) default NULL,
question_id int(11) unsigned default NULL,
add_date datetime default NULL,
errorcount smallint(11) unsigned default '0',
test_id int(11) unsigned default NULL,
mn_test_id int(11) unsigned default NULL,
review_date datetime default NULL,
sourcetype tinyint(4) unsigned default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;--
-- Dumping data for table 'errorpad'
--INSERT INTO errorpad VALUES (13,'sc010',571,'2003-10-22 10:40:38',2,119,NULL,NULL,2);
INSERT INTO errorpad VALUES (14,'sc010',572,'2003-10-22 10:40:38',1,119,NULL,NULL,2);
INSERT INTO errorpad VALUES (15,'sc010',792,'2003-10-22 11:13:44',3,152,29,NULL,3);
INSERT INTO errorpad VALUES (16,'sc010',793,'2003-10-22 11:13:44',2,152,29,NULL,3);
INSERT INTO errorpad VALUES (17,'sc007',610,'2003-10-22 11:16:36',2,128,18,NULL,3);
INSERT INTO errorpad VALUES (18,'sc007',611,'2003-10-22 11:16:36',2,128,18,NULL,3);
用SQLylog导,没有任何反映。
p后面跟密码,如果有。
或者登录到mysql命令行中
在>提示符下面输入
use databasename;
source /data/data.sql;source后面是路径跟文件名