MySQL: Updating all rows setting a field to 0, but setting one row's field to 1

 efficient way to update a selection of rows' field to 0, but set One of these rows to 1 based on an ID.

UPDATE `table` SET `inuse` = (`id` = 23) WHERE <condition>

Example:

UPDATE `communication` SET `is_default` = (`id` = 1 and `empid` = 1) WHERE empid = 1


https://stackoverflow.com/questions/1013042/mysql-updating-all-rows-setting-a-field-to-0-but-setting-one-rows-field-to-1


Comments

Post a Comment

Popular posts from this blog

Android App Version Update using the following cordova cli commands

Change the version in config.xml ionic cordova build --release android jarsigner -verbose -sigalg SHA1withRSA -digestalg SHA1 -keystore my-release-key.keystore app-release-unsigned.apk alias_name_1 C:\Users\<Username>\AppData\Local\Android\Sdk\build-tools\23.0.2\zipalign.exe -v 4 app-release-unsigned.apk NameOfTheApp.apk Note:   C:\Users\<Username>\AppData\Local\Android\Sdk\build-tools\23.0.2\zipalign.exe --  this path may vary depending on your OS/Folder configuration.  Once release build is generated upload your APK, for upload the new version in play store follow the below link . 1. First, log in to the Google Play Developer Console. 2. Next, locate your app in the app choices listed for your developer account. Click on the appropriate app. 3. Next, click on 'Release Management', then 'App Releases'. 4. To upload a new .APK file, click on 'Manage Production', then 'Create Release'. 5. Drag and drop the new .APK file into the 'APKs to a...
Read more

75 inspirational quotes that will change your life

1 of 75 Oprah Winfrey Quote : "You become what you believe." 2 of 75 Margaret Thatcher Quote : "You may have to fight a battle more than once to win it. 3 of 75 Steve Jobs Quote : "The only way to do great work is to love what you do." 4 of 75 Audrey Hepburn Quote : "Nothing is impossible, the word itself says, 'I'm possible!'" 5 of 75 Dalai Lama Quote : "Happiness is not something readymade. It comes from your own actions." 6 of 75 Amelia Earhart Quote : "The most difficult thing is the decision to act, the rest is merely tenacity." 7 of 75 Dolly Parton Quote : "If you see someone without a smile give them yours." 8 of 75 Jane Fonda Quote : "It's never to late- never to late to change your life,never to late to be happy." 9 of 75 Cate Blanchett Quote : "If you know you are going to fail, then fail gloriously." 10 of 75 Drew Barrymore Quote : "Life is very interesting... in t...
Read more

Retrieval Image From DataBase and Display on WebPage by Using Servlets.

Hi Frnds, This Session I will Explain you to " How Retrive Image from DataBase Using Servlets and Display it on WebPage " The below code is useful for  Retrive Image from DataBase Using Servlets and Display it on WebPage. import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; import javax.servlet.http.HttpServlet; import javax.servlet.annotation.WebServlet; @WebServlet("/ImageDis") public class ImageDis extends HttpServlet { public void service(HttpServletRequest request,HttpServletResponse response)  throws IOException,ServletException {  response.setContentType("image/jpeg"); Blob image = null; Connection con = null; byte[ ] imgData = null ; Statement stmt = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/DbName","UserName","Password"); stmt = con.createStatement...
Read more