UPDATE `tbl_goods_stock_v2` SET `stock_quantity` = 21 WHERE `goods_sku` = 1012333205 AND `cus_id` = 0错误:Duplicate entry '21' for key 'stock_quantity'表结构:CREATE TABLE `tbl_goods_stock_v2` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cus_id` int(10) DEFAULT '0' COMMENT '客户编号',
`goods_sku` int(10) unsigned NOT NULL COMMENT '商品SKU',
`stock_quantity` int(10) NOT NULL COMMENT '锁定库存数量',
PRIMARY KEY (`id`),
UNIQUE KEY `stock_quantity` (`stock_quantity`),
KEY `id` (`id`,`cus_id`,`goods_sku`)
)请问为什么报错? 这条语句在MSSQL里是正常执行的
解决方案 »
- 追加数据表mysql
- MySQL5.1多列分别统计的问题
- 会分析MYSQL错误日志的老大进来,帮帮我,求求你们!
- mysql汉字乱码问题
- MySQL如何实现全文检索
- 请问怎样从一个数据库中读取所有表名?谢谢!
- Host 'xxxxxx' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' 怎么办
- MYSQL:求记录总数
- mysql如何执行xx.sql文件???
- delphi刚入门,以前都是用自带的paradox,现在发现好像access还要好些,不知mysql或者sql server,oracle是不是更好?请问大家,用什么数据库更好些,如果考虑到过渡到C/S?
- JProgressBar 进度显示问题
- 求在MYSQL 两个时间比较,计算当前是第几个月的写法
CREATE TABLE `tbl_goods_stock_v2` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cus_id` int(10) DEFAULT '0' COMMENT '客户编号',
`goods_sku` int(10) unsigned NOT NULL COMMENT '商品SKU',
`stock_quantity` int(10) NOT NULL COMMENT '锁定库存数量',
PRIMARY KEY (`id`),
UNIQUE KEY `stock_quantity` (`stock_quantity`),
KEY `id` (`id`,`cus_id`,`goods_sku`)
)