哪位大神把下列语句改成MYSQL查询语句,谢谢了CREATETABLE[dbo].[Orders]([OrderId]INTIDENTITY(1,1)NOTNULL,[Name]NVARCHAR(MAX)NULL,[Line1]NVARCHAR(MAX)NULL,[Line2]NVARCHAR(MAX...

哪位大神把下列语句改成MYSQL查询语句,谢谢了

CREATE TABLE [dbo].[Orders] (

[OrderId] INT IDENTITY (1, 1) NOT NULL,

[Name] NVARCHAR (MAX) NULL,

[Line1] NVARCHAR (MAX) NULL,

[Line2] NVARCHAR (MAX) NULL,

[Line3] NVARCHAR (MAX) NULL,

[City] NVARCHAR (MAX) NULL,

[State] NVARCHAR (MAX) NULL,

[GiftWrap] BIT NOT NULL,

[Dispatched] BIT NOT NULL,

CONSTRAINT [PK_dbo.Orders] PRIMARY KEY CLUSTERED ([OrderId] ASC)

);

CREATE TABLE [dbo].[OrderLines] (

[OrderLineId] INT IDENTITY (1, 1) NOT NULL,

[Quantity] INT NOT NULL,

[Product_ProductID] INT NULL,

[Order_OrderId] INT NULL,

CONSTRAINT [PK_dbo.OrderLines] PRIMARY KEY CLUSTERED ([OrderLineId] ASC),

CONSTRAINT [FK_dbo.OrderLines_dbo.Products_Product_ProductID] FOREIGN KEY

([Product_ProductID]) REFERENCES [dbo].[Products] ([ProductID]),

CONSTRAINT [FK_dbo.OrderLines_dbo.Orders_Order_OrderId] FOREIGN KEY ([Order_OrderId])

REFERENCES [dbo].[Orders] ([OrderId])

);

展开

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐