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
解决方案 »
- Mysql 导入binary类型,被截断了
- 含有blob字段的表查询特别慢,怎么优化SQL?
- 数据库ER图完成了,要写成关系图才能创建数据库?
- mysql中文乱码??(mysql+php)在线等,急
- 关于date的问题
- MySQL show variables的疑问
- 求助!!MySQL语句
- 求在XP下怎样做Postgresql的数据备份?紧急求助。。
- [求助]在Windows2003环境下如何完全卸载MySQL?[up有分]
- 一个月后,WIN32平台下的MySql还有用吗?
- 求助MySQL的存储过程中的事务处理
- 为什么MYSQL的INNER JOIN没有效果,变成了LEFT JOIN的效果呢? 有完整SQL语句
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 ``