mysql update column to uppercase first letter code example

Example 1: oracle sql query to make column data uppercase

UPDATE
  MyTable
SET
  MyColumn = UPPER(MyColumn)

Example 2: mysql convert column to uppercase

UPDATE my_table SET my_column = UPPER(my_column)