mysql odderby_mysql2derby

最新推荐文章于 2022-12-09 11:26:10 发布

浪斌

最新推荐文章于 2022-12-09 11:26:10 发布

阅读量101

点赞数

文章标签： mysql odderby

本文链接：https://blog.csdn.net/weixin_33474462/article/details/113909396

版权

MySQL Derby 数据迁移 SQL转换数据库导入

关键词由CSDN通过智能技术生成

将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)去掉注释部分的的内容(即--和/**/)