转为小写:
update tablename set fieldname = lower(fieldname)
转为大写:
update tablename set fieldname = upper(fieldname)
转为小写:
update tablename set fieldname = lower(fieldname)
转为大写:
update tablename set fieldname = upper(fieldname)