[RESOLVED] how to empty a column and insert content from another column

[lli2k5]

How would you do this simple thing?

I would like to empty Column B, copy Column C's contents into Column B and then empty Column C's contents.

Each row is uniquely identified by its value in Column A.

[bradgrafelman]

Well, what kind of column is Column C? Does it have a default value? Depending upon these questions, you'd have a query that looks like:

UPDATE `myTable` SET `column_b` = `column_c`, `column_c` = ''
-- OR --
UPDATE `myTable` SET `column_b` = `column_c`, `column_c` = 0
-- OR --
UPDATE `myTable` SET `column_b` = `column_c`, `column_c` = DEFAULT

[lli2k5]

thanks!, it works.

[bradgrafelman]

Glad I could help - don't forget to mark this thread resolved.