How to swap two rows in mysql Hierarchical Data table

[praveen jalakam]

Hi,

I created mysql hierarchical data table,
CREATE TABLE treeviewdata(entityid INT AUTO_INCREMENT PRIMARY KEY,nameVARCHAR(20) NOT NULL,parentid INT DEFAULT NULL);

Mysql>Select * from treeviewdata;

+-----------------------------------------+
| entityid | name | parentid |
+-----------------------------------------+
| 1 | ELECTRONICS| NULL |
+-----------------------------------------+
| 2 | TELEVISIONS| 1 |
+-----------------------------------------+
| 3 | TUBE | 2 |
+-----------------------------------------+
| 4 | LCD| | 2 |
+-----------------------------------------+

Now i want to swap rows in treeviewdata table where parentid=2;



Edited 1 time(s). Last edit at 04/13/2011 12:17AM by praveen jalakam.