sql 建表语句如下: 表的结构 `node`
--
CREATE TABLE IF NOT EXISTS `node` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(45) NOT NULL,
`gender` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- 导出表中的数据 `node`
--
INSERT INTO `node` (`id`, `name`, `gender`) VALUES
(1, 'cuiran', 'boy'),
(2, 'aojuan', 'girl'),
(3, 'zhangsan', 'boy'),
(4, 'lisi', 'girl'),
(5, 'aomiao', 'girl'),
(6, 'aoqian', 'girl'),
(7, 'wangwu', 'boy');
-- 表的结构 `edge`
--
CREATE TABLE IF NOT EXISTS `edge` (
`id` int(10) unsigned NOT NULL auto_increment,
`sid` int(10) unsigned NOT NULL,
`tid` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- 导出表中的数据 `edge`
--
INSERT INTO `edge` (`id`, `sid`, `tid`) VALUES
(3, 2, 1),
(4, 3, 1),
(5, 4, 1),
(6, 5, 2),
(7, 6, 2),
(8, 7, 1); 怎么样 把他改成oracle表结构呢
--
CREATE TABLE IF NOT EXISTS `node` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(45) NOT NULL,
`gender` varchar(45) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- 导出表中的数据 `node`
--
INSERT INTO `node` (`id`, `name`, `gender`) VALUES
(1, 'cuiran', 'boy'),
(2, 'aojuan', 'girl'),
(3, 'zhangsan', 'boy'),
(4, 'lisi', 'girl'),
(5, 'aomiao', 'girl'),
(6, 'aoqian', 'girl'),
(7, 'wangwu', 'boy');
-- 表的结构 `edge`
--
CREATE TABLE IF NOT EXISTS `edge` (
`id` int(10) unsigned NOT NULL auto_increment,
`sid` int(10) unsigned NOT NULL,
`tid` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- 导出表中的数据 `edge`
--
INSERT INTO `edge` (`id`, `sid`, `tid`) VALUES
(3, 2, 1),
(4, 3, 1),
(5, 4, 1),
(6, 5, 2),
(7, 6, 2),
(8, 7, 1); 怎么样 把他改成oracle表结构呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货