-- 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);
解决方案 »
- Input string was not in a correct format.
- 这怎的统计SQL怎么写
- 将一个数据库表的数据插入另一个数据库表
- 急啊,连不上mysql,帮帮忙
- 无法启动MySQL服务
- mysql +php 数据库连接问题。
- 请问postgresql的连接数如何修改?
- 急! 关于超大的列数据导出问题 100分求助
- mysql-libs是什么包 ? mysql-shared是什么包? mysql-shared-compat是什么包?mysql-test是什么包?
- linux 下创建分区表失败
- 十万火急,phpmyadmin导出数据库和mysql导入数据库~~~~在线等
- 怎样导入数据?
用SQLylog导,没有任何反映。
p后面跟密码,如果有。
或者登录到mysql命令行中
在>提示符下面输入
use databasename;
source /data/data.sql;source后面是路径跟文件名