本文介绍了如何自动将MySQL列转换为小写的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
是否存在可以添加到列中的属性,以便将其值转换为小写?而不是通过PHP对每个单个值执行此操作?
Is there a property that I can add to a column so that it converts its value to lowercase? Instead of doing it for every single value through PHP?
推荐答案您可能可以通过触发,该触发会在插入或更新时触发.我自己想创建一个视图该列的小写版本.视图的SQL可能看起来像
You could probably do it through a trigger that fires on insert or update. Myself, I'd rather just create a view that has a lower-case version of the column in question. The SQL for the view might look like
SELECT ID, LOWER(MY_COLUMN) AS MY_COLUMN_LOWERCASE FROM MY_TABLE;更多推荐
如何自动将MySQL列转换为小写
发布评论