Search
Setup for Free
DT
Drizzle Team
•
3y ago
Dev Emm
Increment without first selecting
UPDATE table_name SET column_name = column_name + 1 WHERE condition;
UPDATE table_name SET column_name = column_name + 1 WHERE condition;
please any easy way to do this with drizzle
? talking about the SET column
_name
= column
_name
+ 1 part
Drizzle Team
Join
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,794
Members
View on Discord
Similar Threads
Was this page helpful?
Yes
No
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
UPDATE
table_name
SET
column_name
=
column_name
+
1
WHERE
condition;
UPDATE
table_name
SET
column_name
=
column_name
+
1
WHERE
condition;
Similar Threads
Selecting from 2 subqueries without using magic `sql()`
DT
Drizzle Team / help
2y ago
Setting AUTO_INCREMENT starting value
DT
Drizzle Team / help
3y ago
Selecting multiple relating rows
DT
Drizzle Team / help
3y ago
How to increment field in PG
DT
Drizzle Team / help
2y ago