Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
O
O
Optimus2017-03-26 10:12:25
MySQL
Optimus, 2017-03-26 10:12:25

How to quickly change the value in the database?

In the DB field, the value 0 or 1
is possible. Is it possible to change 0 to 1 with one request if there was 0 in the database at the time of the request, and vice versa, change 1 to 0 if there was 1 in the field at the time of the request?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
R
rPman, 2017-03-26
Pyan @marrk2

update T set C = !C

Similar questions
N
nerwind932021-04-07 15:31:56
How to substitute copied text in js? 3Reply
Y
Yaroslav2019-10-03 12:49:21
Where and how to find free labor for the for fun project and where to discuss ideas? 7Reply
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
N
nerik2015-07-10 12:55:01
How to organize nat before ipsec tunnel? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question