think-orm
think-orm copied to clipboard
Model::update() 当MySQL字段类型为bigint整型,更新条件字段值长度大于16的字符串类型,无法更新成功
CREATE TABLE test (
id int unsigned NOT NULL AUTO_INCREMENT COMMENT '表èªå¢id',
order_no bigint NOT NULL DEFAULT '0' COMMENT 'ååç¼å·',
order_sn bigint NOT NULL DEFAULT '0' COMMENT '订åç¼å·',
update_time int unsigned NOT NULL DEFAULT '0' COMMENT 'æ´æ°æ¶é´',
create_time int unsigned NOT NULL DEFAULT '0' COMMENT 'å建æ¶é´',
PRIMARY KEY (id),
UNIQUE KEY order_no (order_no),
KEY order_sn (order_sn)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='æµè¯';
INSERT INTO test (id, order_no, order_sn, update_time, create_time) VALUES (1, 3021080720351340511, 0, 0, 0);
// $data = ['order_sn'=>'21080715996084293','order_no'=>'3021080720351340511']; //å符串类åé¿åº¦å¤§äº16æ´æ°ä¸äº
$data = ['order_sn'=>'21080715996084293','order_no'=>3021080720351340511]; //æ´åè¿æ ·å¯ä»¥æ´æ°
$result = \app\model\Test::update($data,['order_no'=>$data['order_no']]);
return json($result);