mysql> select " DFREF"; +--------+ | DFREF | +--------+ | DFREF | +--------+ 1 row in set (0.00 sec)
mysql> select lower(" DFREF"); +-----------------+ | lower(" DFREF") | +-----------------+ | dfref | +-----------------+ 1 row in set (0.00 sec)
mysql> select " DFREF"; +--------+ | DFREF | +--------+ | DFREF | +--------+ 1 row in set (0.00 sec)
mysql> select lower(" DFREF"); +-----------------+ | lower(" DFREF") | +-----------------+ | dfref | +-----------------+ 1 row in set (0.00 sec)
转载于:https://www.cnblogs.com/sea-stream/p/11308143.html