I have a `user` table as below:

```
id     name     description

1      desc1    user1
2      desc2    user2

```

Now i want to swap the values using mysql as below:

```
id     name     description

1      user1    desc1    
2      user2    desc2

```

I found most of the examples for sqlserver but not for mysql.

I tried using:

```
 UPDATE user 
 SET name = description,  
     description = name

```

but ended up with all description values.I tried declaring temp variable using `Declare` as in sql server but there is not `declare` in Mysql.