哪位大侠能够一条sql语句执行更新多条记录,该如何解决
哪位大侠能够一条sql语句执行更新多条记录
id num
1 1
2 2
3 4
4 8
表名test
最终结果
id为1的， 更新为2
id为2的，更新为3
id为3的，更新为6
id为4的，更新为11
------解决方案--------------------
如果不是相同的是无法一起更新的.看看有没其他神奇的写法吧
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1376
52
Huawei Watch GT 5 smartwatch gets update with new features
Oct 03, 2024 am 06:25 AM
Huawei is rolling out software version 5.0.0.100(C00M01) for the Watch GT 5 and the Watch GT 5 Prosmartwatchesglobally. These two smartwatches recently launched in Europe, with the standard model arriving as the company’s cheapest model. This Harmony
Tekken\'s Colonel Sanders dream fried by KFC
Oct 02, 2024 am 06:07 AM
Katsuhiro Harada, the Tekken series director, once seriously tried to bring Colonel Sanders into the iconic fighting game. In an interview with TheGamer, Harada revealed that he pitched the idea to KFC Japan, hoping to add the fast-food legend as a g
First look: Leaked unboxing video of upcoming Anker Zolo 4-port 140W wall charger with display
Oct 01, 2024 am 06:32 AM
Earlier in September 2024, Anker's Zolo 140W charger was leaked, and it was a big deal since it was the first-ever wall charger with a display from the company. Now, a new unboxing video from Xiao Li TV on YouTube gives us a first-hand look at the hi
New Xiaomi Mijia Graphene Oil Heater with HyperOS arrives
Oct 02, 2024 pm 09:02 PM
Xiaomi will shortly launch the Mijia Graphene Oil Heater in China. The company recently ran a successful crowdfunding campaign for the smart home product, hosted on its Youpin platform. According to the page, the device has already started to ship to
Garmin releases Adventure Racing activity improvements for multiple smartwatches via new update
Oct 01, 2024 am 06:40 AM
Garmin is ending the month with a new set of stable updates for its latest high-end smartwatches. To recap, the company released System Software 11.64 to combat high battery drain across the Enduro 3, Fenix E and Fenix 8 (curr. $1,099.99 on Amazon).
Samsung Galaxy Z Fold Special Edition revealed to land in late October as conflicting name emerges
Oct 01, 2024 am 06:21 AM
The launch of Samsung's long-awaited 'Special Edition' foldable has taken another twist. In recent weeks, rumours about the so-called Galaxy Z Fold Special Edition went rather quiet. Instead, the focus has shifted to the Galaxy S25 series, including
Manjaro 24.1 \'Xahea\' launches with KDE Plasma 6.1.5, VirtualBox 7.1, and more
Oct 02, 2024 am 06:06 AM
With a history of over one decade, Manjaro is regarded as one of the most user-friendly Linux distros suitable for both beginners and power users, being easy to install and use. Mostly developed in Austria, Germany, and France, this Arch-based distro
MINISFORUM BD790i SE Mini-ITX motherboard with AMD Ryzen 9 7940HX now available
Oct 02, 2024 am 06:06 AM
The BD790i SE is MINISFORUM's latest Mini-ITX motherboard option, having released the BD770i andBD790iin October 2023 and February 2024, respectively. As far as we can tell, the BD790i SE effectively replaces theBD770i, which MINISFORUM has now stopp
