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

How do I find the default sql server instance?

990

How to create prepared statements using odbc_prepare()?

1103

Explain what is cte (common table expression)?

1188

What is difference between rownum and row_number?

1023

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1126

What does truncate do?

994

How to set the current database in ms sql server?

1141

What is difference between foreign key and unique key?

1048

How can a user-defined datatype be created?

1036

What is BCP? When does it used in sql server 2012?

1108

Explain what is the difference between union and union all?

1070

What does the on update no action do?

1079

Why truncate is ddl command?

1116

What is index in an assignment?

997

What is the command to change the recovery model?

1093