Index

  1. Home
  2. Docs
  3. Index
  4. Data Explorer
  5. Run SQL script files

Run SQL script files

Button Import data/Execute script(s) can be used to execute SQL script files. It allows DCL (grant or revoke access), DDL (e.g. create table, drop table) and DML (select, insert, update, delete) statements, presuming the connected user has the proper priveleges (works for remote databases as well).

SQL script files may contain multiple SQL statements. There is one important rule:

every SQL statement must end with a ; and a new line

If you receive a message that your SQL file was succesfully processed and you are not seeing any results, this is mostly because one or more SQL statements do not end with a ; and a new line.

If your SQL file is too long, you might not be able to upload it. Instead, you can add your SQL file to a ZIP file and upload the ZIP file.

You can also bundle multiple SQL files in a ZIP. This can be very useful, for example, if you want to copy tables, projects and/or publications from your development machine to a production environment. Be aware, that you have no influence on the order in which SQL files are processed. Make sure there are no dependies between SQL file within one ZIP file.

Be CAREFUL! Know what you do! Do what you know! If you have never written any SQL before, don’t start experimenting here. If you corrupt a WordPress table, you might need to restore your backup… (Do you have one? Right now?)

Was this article helpful to you? Yes No

Leave a Reply

Your email address will not be published. Required fields are marked *

2 × two =