# 通过数据库查询更改许多用户的界面语言？

**URL:** https://meta.discourse.org/t/change-the-interface-language-for-many-users-via-a-database-query/391635
**Category:** Support
**Created:** [2025年十二月18日 07:42 UTC](https://meta.discourse.org/t/change-the-interface-language-for-many-users-via-a-database-query/391635 "2025-12-18T07:42:12Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![jahan\_gagan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jahan_gagan/32/501948_2.png) [@jahan\_gagan](https://meta.discourse.org/u/jahan_gagan)
#### Post date: [2025年十二月18日 08:54 UTC](https://meta.discourse.org/t/change-the-interface-language-for-many-users-via-a-database-query/391635/2 "2025-12-18T08:54:42Z")

</div>

您不能通过数据浏览器插件运行 `UPDATE` 查询，因为它严格限制为只读。

对于此类批量更新，请改用 Rails 控制台：

```plaintext
User.where(locale: 'en').update_all(locale: 'en_GB')

```

有关批量更新用户偏好的更多示例，请参阅：

> [@Edit a user preference for everyone or a subset of users](https://meta.discourse.org/t/edit-a-user-preference-for-everyone-or-a-subset-of-users/25162):
>
> bookmark This guide explains how to edit a user preference for everyone or a subset of users in Discourse. person_raising_hand Required user level: System Administrator warning Console access is required. If you need to update the user preference for all of your users or a large subset of users, you can do so via the rails console. Summary In this guide, you’ll learn: How to access the Rails console for making bulk changes Examples of modifying user preferences How to identify set…

---

_[View the full topic](https://meta.discourse.org/t/change-the-interface-language-for-many-users-via-a-database-query/391635)._