sorry guys, all ur answers are not working properly. Try to answer in one

How to swap the data of two columns in a table. both the
columns containing varchar values.

Question Posted / mysql

Answer Posted / mysql

sorry guys, all ur answers are not working properly.
Try to answer in one sql statement.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the three different part of rdl file explain them?

257

How does a profiler work?

882

What are “phantom rows”?

1622

Define right outer join?

938

How important do you consider cursors or while loops for a transactional database?

923

How do I find the sql server database version?

958

How can sql server instances be hidden? : sql server security

1070

what is difference between NULL and ISNULL in SQL Server 2008?

974

How to scale out a federation by Sql statement?

116

What is mean by dml?

963

What is the difference between ddl,dml and dcl commands?

1074

What is sql server profiler?

963

Which data type columns are the best candidates for full-text indexing?

928

How to create new table with "create table" statements?

1018

What methods do you follow to protect from sql injection attack?

979