【问题描述】:单条sql语句插入不成功。语句如下
insert into kernel_role(TenantId,ShardId,CompanyId,RoleId,StationId,RoleName,Type,Status,Level,Rank,Description,CreateAccount,CreateTime,UpdateAccount,UpdateTime,IsActive,IsDeleted,IsShow,IsInternally)
values (0,0,0,0,387,‘商户超级管理员’,1,0,0,0,‘商户[11]超级管理员’,2912,‘2020-02-06 17:19:39.967865’,2912,‘2020-02-06 17:19:39.967970’,1,0,0,0)
错误如下:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 103 near “Rank,Description,CreateAccount,CreateTime,UpdateAccount,UpdateTime,IsActive,IsDeleted,IsShow,IsInternally)
values (0,0,0,0,387,‘商户超级管理员’,1,0,0,0,‘商户[11]超级管理员’,2912,‘2020-02-06 17:19:39.967865’,2912,‘2020-02-06 17:19:39.967970’,1,0,0,0)”
我一开始以为是level是关键词可能会有问题但是我修改level 改为level_x 也是同样的出错误