這個外掛並未在最新的 3 個 WordPress 主要版本上進行測試。開發者可能不再對這個外掛進行維護或提供技術支援,並可能會與更新版本的 WordPress 產生使用上的相容性問題。

Run SQL Query

外掛說明

This plugin will allow you to execute any type of SQL query into the WordPress’s DB connecting through the driver provided by the MySQLi extension without the need to use another tool like phpMyAdmin.

It also gives you the ability to export the results in a CSV format file.

In order to access this plugin’s admin page (Tools -> Run SQL Query), your account needs to have the install_plugins capability, that means a Super Admin in the multi-site installation or an Admin in a single site.

Feel free to contribute:
https://github.com/Sefirost/run-sql-query

Use on you own risk. Under no circumstances will the Author of this plugin assume responsibility or liability for any damages or destructive effects on the database resulting from the queries executed using this tool.

螢幕擷圖

  • Run SQL Query plugin screen

安裝方式

  1. Upload the plugin folder run-sql-query to the /wp-content/plugins/ directory or by using the “Add Plugin” function of WordPress.
  2. Activate the plugin Run Sql Query through the ‘Plugins’ menu in WordPress
  3. The plugin page can be accessed via the ‘Run SQL Query’ link under ‘Tools’ menu in the administration area of a site (if your role is Admin for site administration role for single-site installs, or Super Admin for network installs).

常見問題集

Where is the plugin page to run the queries?

The plugin page can be accessed via the ‘Run SQL Query’ link under ‘Tools’ menu in the administration area of a site (if your role is Admin for site administration role for single-site installs, or Super Admin for network installs).

Can a query make unrecoverable changes in the database?

Yes, and this plugin doesn’t provide and a way to undo the changes. Under no circumstances will the Author of this plugin assume responsibility or liability for any damages or destructive effects on the database resulting from the queries executed using this tool.

What driver it uses to connect to the Database?

Unlike other similar plugins it uses the driver provided by the MySQLi extension included since PHP 5.3.0 which is designed to work with MySQL version 4.1.13 or newer.

使用者評論

閱讀全部 1 則使用者評論

參與者及開發者

以下人員參與了開源軟體〈Run SQL Query〉的開發相關工作。

參與者

將〈Run SQL Query〉外掛本地化為台灣繁體中文版

對開發相關資訊感興趣?

任何人均可瀏覽程式碼、查看 SVN 存放庫,或透過 RSS 訂閱開發記錄

變更記錄

1.0

  • Initial version