SQL语句转MySQL,为什么执行时暴出错误:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax:check the manual that corresponds to your MySQL server version for the right syntax to use near '?U' at line
我的SQL语句如下:USE [PovertySurvey_db]
GO/****** Object: Table [dbo].[省] Script Date: 01/10/2013 17:10:10 ******/
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GOCREATE TABLE [dbo].[省](
[省名] [nvarchar](16) NOT NULL,
PRIMARY KEY CLUSTERED
(
[省名] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GO
sqlmysql
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax:check the manual that corresponds to your MySQL server version for the right syntax to use near '?U' at line
我的SQL语句如下:USE [PovertySurvey_db]
GO/****** Object: Table [dbo].[省] Script Date: 01/10/2013 17:10:10 ******/
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GOCREATE TABLE [dbo].[省](
[省名] [nvarchar](16) NOT NULL,
PRIMARY KEY CLUSTERED
(
[省名] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GO
sqlmysql
CREATE TABLE `省`(`省名` VARCHAR(16) NOT NULL ,
PRIMARY KEY (`省名`) );
ERROR 1193 (HY000) at line 5:Unknown system variable 'ANSI_NULLS'
这又是什么情况?
这句不要。
你就原样直接执行下面这一句。什么都别加。
CREATE TABLE `省`(
`省名` varchar(16) PRIMARY KEY
)
mysql ``