stormZeng
2016-04-14 07:32
采纳率: 100%
浏览 1.6k

下面sql建表语句哪里错了? 有错误提示

create table salary(
salaryId int identity(1,1),
employeeId char(100),
employeeName char(100),
year char(100),
month char(100),
basicWage float,
overtimeWage float,
trafficWage float,
totalWage float,
kaoqinReduce float,
secureReduce float,
taxReduce float,
totalReduce float,
realWage float,
editTime char(100),
memo char(100)
)
然后给出的错误提示:(我实在 Navicat上运行的)
[Err] 1064 - 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 'identity(1,1),
employeeId char(100),
employeeName char(100),
year char(100' at line 2

year char(100' at line 2

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

3条回答 默认 最新

  • Favorite_988 2016-04-14 07:45
    最佳回答

    亲 mysql 没有identity,,,,,,那是sqlserver的,mysql的是:AUTO_INCREMENT

    评论
    解决 无用
    打赏 举报
查看更多回答(2条)

相关推荐 更多相似问题