Ask Your Question
0

Bulk Record Update in Base

asked 2019-10-02 02:54:26 +0100

LSemmens gravatar image

updated 2019-10-02 06:49:01 +0100

ebot gravatar image

Pseudo code:

open table "Master" for editing

If size = "24 x 12" then size_id = 153

How would I structure an SQL command to do this? Currently my MASTER table contains only a few thousand records, but it is still time consuming to manually each record with the updated info.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-10-02 03:08:18 +0100

Ratslinger gravatar image

Hello,

Should be like:

Update "YOUR_TABLE_NAME" set "size_id" = 153 Where "size" = '24 x 12'

Always make a backup copy before running when dealing with possible large updates of this type.

edit flag offensive delete link more

Comments

Thank You!

LSemmens gravatar imageLSemmens ( 2019-10-02 03:24:37 +0100 )edit
2

@LSemmens, you can also give a big thank you to @Ratslinger by following the rules of this page: If the answer from @Ratslinger has solved your problem, please click on the chekmark in the circle to the left of the answer and on the arrow ^ for a positive vote. This will tell the community that the question has been answered correctly, and @Ratslinger gets a bit of karma.

This automatically marks the question as resolved. Thank you!

ebot gravatar imageebot ( 2019-10-02 06:47:28 +0100 )edit
Login/Signup to Answer

Question Tools

Stats

Asked: 2019-10-02 02:54:26 +0100

Seen: 32 times

Last updated: Oct 02