How to make a copy values from one column to another in mysql?



How to make a copy values from one column to another in mysql?..

Answer / Krishna Bharti

To copy values from one column to another in MySQL, you can use the SQL query: SET target_column = source_column; where source_column and target_column are the names of your columns. Here's an example: UPDATE table SET new_column = old_column;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I run mysql?

1 Answers  


What is pdo in php mysql?

1 Answers  


How can we find the number of rows in a table using MySQL?

3 Answers  


Is mysqli faster than mysql?

1 Answers  


Can't connect mysql server on localhost?

1 Answers  


How to get help information from the server?

1 Answers  


What is mysqlcommand?

1 Answers  


What is prepare statement in mysql?

1 Answers  


How do I start mysql server?

1 Answers  


What is mysql cursor?

1 Answers  


What is the usage of regular expressions in mysql?

1 Answers  


What are the different types of triggers in mysql?

1 Answers  


Categories