将mysql数据库中的数据导入到derby数据库
1.将Mysql中的数据导出为sql文件(c:\>mysqldump -h localhost -u root -p mydb >e:\mysql\mydb.sql )
-- MySQL dump 10.10
--
-- Host: localhost Database: j2ee
-- ------------------------------------------------------
-- Server version 5.0.22-community-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `t_accountitem`
--
DROP TABLE IF EXISTS `t_accountitem`;
CREATE TABLE `t_accountitem` (
`id` varchar(255) NOT NULL,
`transcode` varchar(255) default NULL,
`transDate` varchar(255) default NULL,
`transTime` varchar(255) default NULL,
`itemAmount` varchar(50) default NULL,
`acountType` varchar(255) default NULL,
`accountID` varchar(255) default NULL,
`projectTypeID` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `t_accountitem`
--
/*!40000 ALTER TABLE `t_accountitem` DISABLE KEYS */;
LOCK TABLES `t_accountitem` WRITE;
INSERT INTO `t_accountitem` VALUES ('SNAI20090725000004','SNAI20090725000004','2009-07-25','14:24:17','200','1','SNTA20090724000000','SNPI20090725000004'),('SNAI20090725000005','SNAI20090725000005','2009-07-17','14:24:38','6000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090725000006','SNAI20090725000006','2009-07-16','20:10:04','900','1','SNTA20090724000000','SNPI20090725000004'),('SNAI20090725000007','SNAI20090725000007','2009-07-23','20:10:16','500','0','SNTA20090724000000','SNPI20090724000002'),('SNAI20090729000008','SNAI20090729000008','2005-07-08','09:54:03','4000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090729000009','SNAI20090729000009','2005-07-08','09:54:23','500','0','SNTA20090724000000','SNPI20090724000003'),('SNAI20090729000010','SNAI20090729000010','2006-07-11','09:54:44','6000','1','SNTA20090724000000','SNPI20090724000001'),('SNAI20090729000012','SNAI20090729000012','2007-07-14','10:00:09','5000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090729000013','SNAI20090729000013','2007-07-20','10:00:22','800','0','SNTA20090724000000','SNPI20090724000003'),('SNAI20090729000014','SNAI20090729000014','2007-07-19','10:04:57','800','0','SNTA20090724000000','SNPI20090724000002'),('SNAI20090729000015','SNAI20090729000015','2008-07-04','10:05:11','9000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090729000016','SNAI20090729000016','2009-07-14','10:05:25','1200','0','SNTA20090724000000','SNPI20090724000002'),('SNAI20090729000017','SNAI20090729000017','2008-07-23','10:11:44','900','0','SNTA20090724000000','SNPI20090724000002'),('SNAI20090729000018','SNAI20090729000018','2008-07-09','10:31:00','500','1','SNTA20090724000000','SNPI20090724000001'),('SNAI20090729000019','SNAI20090729000019','2007-07-09','10:31:13','300','0','SNTA20090724000000','SNPI20090724000003'),('SNAI20090729000020','SNAI20090729000020','2006-07-10','10:31:32','600','1','SNTA20090724000000','SNPI20090724000001'),('SNAI20090729000022','SNAI20090729000022','2009-07-12','10:31:51','600','1','SNTA20090724000000','SNPI20090724000001'),('SNAI20090729000023','SNAI20090729000023','2009-07-16','12:42:06','3000','1','SNTA20090724000000','SNPI20090724000000'),('SNAI20090806000022','SNAI20090806000022','2009-08-05','15:16:25','900','0','SNTA20090724000000','SNPI20090724000003');
UNLOCK TABLES;
/*!40000 ALTER TABLE `t_accountitem` ENABLE KEYS */;
--
-- Table structure for table `t_projectitem`
--
DROP TABLE IF EXISTS `t_projectitem`;
CREATE TABLE `t_projectitem` (
`id` varchar(255) NOT NULL,
`projectID` varchar(255) default NULL,
`projectName` varchar(255) default NULL,
`acountType` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `t_projectitem`
--
/*!40000 ALTER TABLE `t_projectitem` DISABLE KEYS */;
LOCK TABLES `t_projectitem` WRITE;
INSERT INTO `t_projectitem` VALUES ('SNPI20090724000000','2009072413:19:18','工资','1'), ('SNPI20090724000001','2009072413:30:41','奖金','1'), ('SNPI20090724000002','2009072413:30:48','交通','0'), ('SNPI20090724000003','2009072413:30:57','食宿','0'), ('SNPI20090725000004','2009072514:23:51','压岁钱','1'), ('SNPI20090729000005','2009072921:15:44','旅游','0');
UNLOCK TABLES;
/*!40000 ALTER TABLE `t_projectitem` ENABLE KEYS */;
--
-- Table structure for table `t_totalaccount`
--
DROP TABLE IF EXISTS `t_totalaccount`;
CREATE TABLE `t_totalaccount` (
`id` varchar(255) NOT NULL,
`accountID` varchar(255) default NULL,
`customerName` varchar(255) default NULL,
`amount` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `t_totalaccount`
--
/*!40000 ALTER TABLE `t_totalaccount` DISABLE KEYS */;
LOCK TABLES `t_totalaccount` WRITE;
INSERT INTO `t_totalaccount` VALUES ('SNTA20090724000000','20090724','sjs','31100');
UNLOCK TABLES;
/*!40000 ALTER TABLE `t_totalaccount` ENABLE KEYS */;
--
-- Table structure for table `t_user`
--
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`id` varchar(255) NOT NULL,
`uname` varchar(255) default NULL,
`password` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `t_user`
--
/*!40000 ALTER TABLE `t_user` DISABLE KEYS */;
LOCK TABLES `t_user` WRITE;
INSERT INTO `t_user` VALUES ('SNUS20090724000000','sjs','sjs'),('SNUS20090724000001','lx','lx'), ('SNUS20090729000002','孙萌','123456'),('SNUS20090729000003','王璐 ','123458'),('SNUS20090729000004','张立','789456'),('SNUS20090729000005',' 孙亮','456789'),('SNUS20090729000006','田亮','123654'), ('SNUS20090729000007','周正','789654'),('SNUS20090729000008','朱芳 ','456987'),('SNUS20090801000009','qqq','qqq');
UNLOCK TABLES;
/*!40000 ALTER TABLE `t_user` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2.修改导出的mydb.sql文件
(1)去掉注释部分的的内容(即--和/**/)
(2)删除DROP TABLE IF EXISTS `t_totalaccount`;和LOCK TABLES `t_user` WRITE;
(3)对于剩余部分的内容,表名和字段名需要去掉“`”(即Esc键子下方的字符)
(4)去掉ENGINE=InnoDB DEFAULT CHARSET=utf8;字符部分
分享到:
相关推荐
NULL 博文链接:https://thetopofqingshan.iteye.com/blog/1504004
derby 数据库驱动jar包, 更多其他数据库驱动jar包(包括db2,derby,exasol,h2,jtds,mimer,mysql,nuodb,oracle,postgresql,redshift,sqlite,vertica)请看楼主其他资源贴
各种数据库的jdbc(mysql,orcal ,derby,hive,postgresql,monetdb-jdbc)
Mysql+Oracle+SqlServer+Access+derby jdbc驱动包
支持多种数据源的nacos,包括mysql/postgresql/oracle/derby 版本号为1.4.2 对应的各个组件版本 springcloud version: 2020.0.1 springboot version: 2.4.2 springcloudalibaba version: 2021.1 需根据自身情况修改...
derby,jtds,mysql,oracle,sql2000,sql2005的jdbc数据库驱动
derby-jdbc-driver.jar包下载,这个东西我在网上找了很久,可能各个版本都有不适用的地方,上传这里希望能帮助到大家
Apache Derby非常小巧,核心部分derby.jar只有2M,既可以做为单独的数据库服务器使用,也可以内嵌在应用程序中使用。 官网下载地址:http://db.apache.org/derby/derby_downloads.html 点击进
1.常用的开源数据库:H2,Derby,HSQLDB,MySQL,PostgreSQL。其中H2, HSQLDB类似,十分适合作为嵌入式数据库使用,其它的数据库大部分都需要安装独 立的客户端和服务器端。2.H2的优势: 1、h2采用纯Java编写,因此...
在开发小型带数据库的java应用程序时,使用mysql,sql等数据库,当你的程序出现在一个没有安装数据库的电脑,该程序无法使用数据库,但是derby是内置在项目中的数据,体积小,免安装,可以达到你想要的java数据库...
H2 Derby HSQLDB MySQL PostgreSQL Pure JavaYesYesYesNoNoMemory ModeYesNoYesNoNoTransaction IsolationYesYesNoYesYesCost Based OptimizerYesYesNoYesYesEncrypted DatabaseYesYesNoNoNoODBC ...
ofbiz默认是使用java 的derby数据库,本文档是如何修改成mysql数据库
java数据库齐全驱动包,oracle,mysql,derby....
Druid支持所有JDBC兼容的数据库,包括Oracle、MySql、Derby、Postgresql、SQL Server、H2等等。 Druid针对Oracle和MySql做了特别优化,比如Oracle的PS Cache内存占用优化,MySql的ping检测优化。
web开发的一些重要的参考资源(oracle.mysql,derby等驱动jstl
DBeaver [1] 是一个通用的数据库管理工具和 SQL 客户端,支持 MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, 以及其他兼容 JDBC 的数据库。DBeaver 提供一个图形界面用来查看数据库结构、...
常见的数据库驱动包(odbc7,mysql-connector,sqljdbc,jtds,db2,ifxjdbc,kingbase)
数据库可视化客户端工具,可以链接mysql、sqllite、oracle、postgreSql、SqlServer等数据库
Beaver Enterprise是一个通用的数据库管理工具和 SQL 客户端,支持 MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, 以及其他兼容 JDBC 的数据库。DBeaver Enterprise提供一个图形界面用来...
Apache,MySQL,PHP-Pinewood Derby管理。 基于Web的系统,用于运行Pinewood Derby。 注册男孩和汽车。 选择种族类型,并让其发挥作用。 显示热量/比赛结果。 专为Pack,地区或市议会Derby设计。 它可与...