Discuss / SQL / 插入或更新下面的语句少写了个ON_(:3J∠)_
Back

插入或更新下面的语句少写了个ON_(:3J∠)_

Topic source

lijianjian666

#1 Created at ... [Delete] [Delete and Lock User]

INSERT INTO students (id, class_id, name, gender, score) VALUES (1, 1, '小明', 'F', 99) DUPLICATE KEY UPDATE name='小明', gender='F', score=99; 这条语句的DUPLICATE前面需要加个ON

廖雪峰

#2 Created at ... [Delete] [Delete and Lock User]

修复了

  • 1

Reply