0

I run flyway scripts DDL and DML where we use uppercase, but mysql use lowercase. Is there exist how to set default uppercase? TQ

Shadow
  • 33,525
  • 10
  • 51
  • 64
John Smith
  • 77
  • 7
  • Without changing the variable that controls this? It's not doable. – Shadow Aug 10 '22 at 17:04
  • I agree, I don't think you can change this unless you change the variable the is meant to be used to change it. Kind of a chicken-and-egg problem. Good luck! – Bill Karwin Aug 10 '22 at 19:21

1 Answers1

0

The problem is resolved by changing lower_case_table_names variable during instalation of mysql in advanced option.

John Smith
  • 77
  • 7
  • Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Aug 18 '22 at 08:03