Search code examples
mysqllowercase

set lower database mysql

Can look like a stupid question, but i don't want to mess it here

would "update table SET field = LOWER(field)" turn every field on table to lowercase? (and will do nothing, else, right?)

Thanks!

Solution

  • If you don't want to mess it BACK UP FIRST. We could be an evil bunch of trolls!

    It will also cause any update trigger on the table to run.