How to double the values of all cells?

S

S

Sergey Beloventsev2017-10-01 14:22:05

MySQL

Sergey Beloventsev, 2017-10-01 14:22:05

How to double the values of all cells?

The next question is there is a customer table that has a bonus field, I need to double the value of each cell, can you tell me how this can be done?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

Kirill Petrov, 2017-10-01
@Recosh

UPDATE customer SET bonus=bonus/2
Should work
PS do not forget about backups: D

Similar questions

N

nerwind932021-04-07 15:31:56

How to substitute copied text in js? 3Reply

A

AlexStolman2015-06-06 09:26:47

How to remove or replace HTTP referer when submitting a form from site A to site B? 4Reply

O

OKNOZA2015-06-21 23:31:05

Can I not use NodeJS templating engine? 7Reply

A

Alex2015-06-29 15:03:19

How to Livereload server side and client side at the same time using Gulp? 2Reply

E

Extramezz2015-07-08 11:10:38

Why doesn't mod_rewrite work? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question