Question

把下边sqlserver建表语句改成mysql的，谢谢！！！！

CREATE TABLE [T_Office] (

[F_Id] [int] IDENTITY (1, 1) NOT NULL ,

[F_OfficeName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[F_Tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[F_Address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,

[F_Order] [smallint] NULL CONSTRAINT [DF_T_Office_F_Order] DEFAULT (0),

[F_Fax] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,

[F_Code] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,

[F_Web] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

[F_OtherTel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

CONSTRAINT [pk_office_id] PRIMARY KEY CLUSTERED

(

[F_Id]

) ON [PRIMARY] ,

CONSTRAINT [un_office_officename] UNIQUE NONCLUSTERED

(

[F_OfficeName]

) ON [PRIMARY]

) ON [PRIMARY]

Answer 1

MYSQL 建表还用语句吗？用个可视的工具不就行了