Executing SQL queries

From brc plugins wiki
Jump to: navigation, search


Contents

MySQL

Explained here

SQLite

  • Download DB Browser for SQLite
  • Stop your server (important)
  • Open the database file (usually it's named database.db in my plugins)
  • Go to the Execute SQL tab
  • Paste the query you want to execute in the SQL 1 textbox
  • Click the play button
  • The query will be executed and you'll get the output in the bottom box (it'll say either success or failed)
  • Click the Write changes button
  • Database has been updated, you can close the DB Browser now and start your server