How to update all values of a column by all values of another column in mysql

sql update column with value from another column in the same table
sql set column value based on another column
update one column from another column in same table mysql
mysql update column with value from another column
mysql update multiple columns from select
sql update column with value from another table
sql update column value based on condition
how to use select and update together in mysql