Question

帮我将这个sqlserver的脚本翻译成oracle或者mysql语言，谢了

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[email]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[email]
GO

CREATE TABLE [dbo].[email] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[title] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[content] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[fjr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sjr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ftime] [datetime] NOT NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[users]
GO

CREATE TABLE [dbo].[users] (
[userid] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[question] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[answer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[birthday] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[gender] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[firstname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[nickname] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mobile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[mail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

Answer 1

你可以在ORACLE 中导入SQL数据库，表结构连数据一起都解决了

追问

怎么导入？我就是因为不会导，才会需要翻译的。

追答

mysql的：

CREATE TABLE `email` (
`id` int(11) NOT NULL,
`title` varchar(50) default NULL,
`content` varchar(50) default NULL,
`type` varchar(50) NOT NULL,
`fjr` varchar(50) NOT NULL,
`sjr` varchar(50) NOT NULL,
`ftime` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `users` (
`userid` int(11) NOT NULL,
`username` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`question` varchar(50) NOT NULL,
`answer` varchar(50) NOT NULL,
`birthday` varchar(50) NOT NULL,
`gender` varchar(50) NOT NULL,
`firstname` varchar(50) default NULL,
`nickname` varchar(50) default NULL,
`mobile` varchar(50) default NULL,
`mail` varchar(50) default NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;