Documentation | MentDB Weak Server

Generate MQL to import data from a remote database to a local database

To generate MQL to import data from a remote database to a local database:
Right click on the table 'apps' and select 'Import data into local MENTDB database'

execute "select.import.generate_sql.exe"
	"[tunnel_id]" ""
	"[connection_id]" "MENTDB"
	"[sql_request]" "select * from apps where ..."
	"[local_table_name]" "tmp_apps"
	"[nb_line_by_block]" "500"
;

Update the configuration:

execute "select.import.generate_sql.exe"
	"[tunnel_id]" "demo_cm_mentdb"
	"[connection_id]" "MENTDB"
	"[sql_request]" "select * from apps"
	"[local_table_name]" "tmp_apps"
	"[nb_line_by_block]" "500"
;

Execute buttons

execute "select.import.handle.exe"
	"[destination_db_id]" "MENTDB"
	"[create_table]" "DROP TABLE IF EXISTS `tmp_apps`;CREATE TABLE `tmp_apps` (
	`app_id` varchar(12) NULL DEFAULT NULL,
	`title` varchar(13) NULL DEFAULT NULL
);"
	"[configuration]" "{
  \"tunnel_id\": \"demo_cm_mentdb\",
  \"connection_id\": \"MENTDB\",
  \"local_table_name\": \"tmp_apps\",
  \"sql_request\": \"select * from apps\",
  \"nb_line_by_block\": \"500\"
}"
;

Update the configuration
Execute buttons
Right click on MENTDB database and select 'Show table'