How can swap same feilds data using Mysql ?
Table Name Color
ID | Color
We can swap feilds data using following query.
update `test` as i , test as c set i.color='black',c.color = 'white' where i.color='white' and c.color='black'
What is MYSQL ?
MySQL is an open source relational database management system (RDBMS) which uses Structured Query Language (SQL). MYSQL is the most popular language that is available for both Linux and Windows operating system.