how to swapping update query table row 0 to 1 and 1 to 0



mysql update query 1 to 0 and 0 to 1 single statement using query
update users set banned= case  when banned= "0"  then 1 when banned= "1"  then 0 end

Comments

Post a Comment

Popular posts from this blog

public void setName(String name) { this.name = name; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getPassword2() { return password2; } public void setPassword2(String password2) { this.password2 = password2; }
Read more

Pyramid Program 4

Pyramid Program 4  Output ---------- 1 1 2 1 1 2 4 2 1 1 2 4 8 4 2 1 1 2 4 8 16 8 4 2 1 1 2 4 8 16 32 16 8 4 2 1 1 2 4 8 16 32 64 32 16 8 4 2 1 1 2 4 8 16 32 64 128 64 32 16 8 4 2 1 Pyramid Program 4 Source code ------------- package com.swain.cell; public class Piramid4 {        public static void main(String args[]){        int i,k,j;        for (i=1;i<=200;i= i*2){               for (j=1; j<=i; j=j*2)               System. out .print(j + " " );               for (k=i/2; k>=1; k=k/2)               System. out .print( k + " " );               System. out ....
Read more