MentDB
Mentalese Database Engine
Strong AI, Weak AI, Interoperability and Software Development
Home
> MQL Functions 1254f - MQL v_3.1.6
Application Manager
App
Virtual host
Service Oriented Architecture
Script
Versioning
User
Group
Cluster
Data transformation
MQL Syntax
Data Type
Statement
Operator
Date
Math
String
Type
Constant
Extract and Load
CSV
HTML
JSON
XML
File Watcher
File
Atom
External REST API
External SOAP API
Compress
SQL
MongoDB
CM
Tunnel
Mail
FTP
FTPS
SFTP
CIFS
SSH
Excel
Excelx
MSWord
MSWordx
PDF
SCRUD
Microsoft
Stripe
Enterprise Service Bus
Stack
Job
Analytics
Predictive analysis
Data quality
Artificial Intelligence
Machine Learning
Deep Learning
Bot
Mentalese
Language
Symbol
Word
Thought
Relation
Circle
Concentration
NoSQL Database
Sequence
Node
Server
Metric
Environment variable
Session
Parameter
Log
OS
Server
App
app create
app show
app is_granted_a
app is_granted_sa
app exist
app delete
app webserver restart
app webserver add_blocked_ip
app webserver remove_blocked_ip
app webserver show_all_remote_ips
app webserver show_all_blocked_remote_ips
app webserver reset_all_remote_ips
app webserver reset_all_blocked_remote_ips
app menu
app menu show
_app_sajax_2_script___create_remote
_app_sajax_1_skeleton___html_div
_app_sajax_1_skeleton___css_container
_app_sajax_1_skeleton___css_row
_app_sajax_1_skeleton___css_col
_app_sajax_1_skeleton___onload
_app_sajax_1_skeleton___on_click_button
_app_sajax_1_skeleton___on_click_event
_app_sajax_1_skeleton___import_all_charts
_app_sajax_3_in_loading___button_in_container
_app_sajax_3_in_loading___refresh_container_with_data
_app_sajax_3_in_loading___show_alert
_app_sajax_3_in_loading___execute_javascript
_app_sajax_3_in_loading___on_click_button
_app_sajax_3_in_loading___on_click_event
_app_sajax_3_in_loading___import_all_chart
_app_sajax_3_in_loading___form
_app_sajax_3_in_loading___form_control_textbox_text
_app_sajax_3_in_loading___form_control_textbox_range
_app_sajax_3_in_loading___form_control_textbox_number
_app_sajax_3_in_loading___form_control_textbox_mail
_app_sajax_3_in_loading___form_control_textbox_tel
_app_sajax_3_in_loading___form_control_textbox_time
_app_sajax_3_in_loading___form_control_textbox_date_fr
_app_sajax_3_in_loading___form_control_textbox_date_en
_app_sajax_3_in_loading___form_control_textbox_datetime_fr
_app_sajax_3_in_loading___form_control_textbox_datetime_en
_app_sajax_3_in_loading___form_control_textbox_color
_app_sajax_3_in_loading___form_control_textbox_password
_app_sajax_3_in_loading___form_control_textbox_file
_app_sajax_3_in_loading___form_control_textarea
_app_sajax_3_in_loading___form_control_textarea_ckeditor
_app_sajax_3_in_loading___form_control_select_mono
_app_sajax_3_in_loading___form_control_select_multiple
_app_sajax_3_in_loading___form_control_radio_line
_app_sajax_3_in_loading___form_control_radio_inline
_app_sajax_3_in_loading___form_control_checkbox_line
_app_sajax_3_in_loading___form_control_checkbox_inline
_app_sajax_3_in_loading___form_control_hidden
Virtual host
app vhost add
app vhost show
app vhost exist
app vhost delete
Script
script export_group
script import_group
script create
script create|insert|add
script update
script merge
script set delay
script get
script generate create
script generate update
script generate merge
script copy
script copy all
script rename
script rename all
script exist
script show
script show ghost
script export_all
script get_all
execute
call
include
script is granted
script generate url
script generate delay
script generate execute
script generate stack
script generate call
script generate include
script generate sub_include
script show groups
script show users
script delete
script delete all
Versioning
version check_group
version commit_group
version commit_script
version show_commits
version show_scriptnames
version show_scripts
version show_script
User
user create
user create|insert|add
user check password
user exist
user secret_key
user set password
user show
user show groups
user show scripts
user delete
Group
group add
group create|insert|add
group exist
group grant user
group grant script
group grant_all script
group ungrant_all script
group is granted user
group is granted script
group get
group get user
group get script
group show
group ungrant user
group ungrant script
group remove
Cluster
cluster show
cluster create
cluster exist
cluster delete
cluster signal process
cluster signal deploy
cluster signal set
cluster signal delete
cluster signal show
cluster signal remote_show
cluster signal give
cluster node set
cluster nodes show_obj
cluster nodes show_txt
cluster node delete
cluster node expels
cluster execute_hot
cluster execute
cluster node reinstate
cluster node generate_set
cluster node
MQL Syntax
category1 categoryN action param1 paramN
Data Type
numeric
string
null
[_n_]
[_r_]
variable
boolean
json
comment
error
Statement
eval
parallel
if
if force
case
switch
mode
for
while
repeat
synchronized
break
continue
exception
try
stack flow_init
stack flow_step
stack flow_json_get
stack flow_json_set
stack var_show
Operator
+
-
*
/
bi+
bi-
bi*
bi/
bd+
bd-
bd*
bd/
and
or
xor
not
is null
is not null
is null or empty
is empty
is not empty
equal
not equal
==
!=
>
>=
<
<=
Date
date add
date addt
date current_ms
date current_ns
date curdate
date current_date
date current_time
date current_timestamp
date curtime
date curtimestamp
date dateadd
date dateaddt
date datediff
date datedifft
date ts_to_long
date dt_to_long
date long_to_dt
date long_to_ts
date day_of_month
date day_of_week
date day_of_year
date dayname
date diff
date difft
date full_systimestamp
date hour
date is_valid_date
date is_valid_date
date is_valid_time
date is_valid_timestamp
date is_valid_timestamp
date format
date minute
date month
date monthname
date nb_day
date seconde
date sysdate
date systime
date systimestamp
date now
date systimestamp_min
date time
date year
Math
math abs
math base_to_base
math bin package_3d
math acos
math asin
math atan
math atan2
math avg
math bit_and
math bit_or
math bit_xor
math cbrt
math ceil
math ceiling
math cos
math cosh
math cot
math decimal_format
math deg_to_rad
math e
math exp
math expm1
math floor
math hypot
math log
math log10
math log1p
math max
math min
math mod
math order_int
math order_long
math order_double
math order_float
math pi
math pow
math power
math rad_to_deg
math random
math rint
math round
math sign
math signum
math sin
math sinh
math sqrt
math tan
math tanh
math ulp
String
string ascii
string bin
string bit_length
string char
string char_length
string char_to_int
concat
string csv_value
string sentence_distance
string sentences_distance
string order
string get_variable
string levenshtein_distance
string md5
string sha
string count
string encode_sign_generate_keypair
string encode_sign
string decode_sign_verify
string encode_rsa_generate_keypair
string encode_rsa
string decode_rsa
string encode_des_generate_key
string encode_des
string decode_des
string encode_blowfish
string decode_blowfish
string encode_pbe
string decode_pbe
string encode_b64
string decode_b64
string del_char_before_each_line
string mql_to_html
string ends_with
string first_letter_upper
string first_letter
string generate_random_str
string hex
string hex_to_int
string hex_to_str
string indent
string instr
string instr
string int_to_char
string int_to_hex
string int_to_oct
string is_letter
string is_alpha_num_uds
string is_alpha_num
string is_number_char
string itrim
string lcase
string left
string length
string like
string locate
string locate
string lower
string lpad
string lrtrim
string lrtrim0
string ltrim
string matches
string mid
string mid
string not_like
string not_regexp
string oct
string oct_to_int
string position
string position
string regexp
string repeat
string repeat_insert_str
string replace
string reverse
string right
string rpad
string rtrim
string space
string split
string split_mql
string split_sentence
string starts_with
string starts_with_or
string str_to_hex
string strcmp
string strpos
string strpos
string sublrchar
string substr
string substr
string substring
string substring
string to_string
string encode
string empty_if_null
string null_if_empty
string trim
string txt
string txt2
string ucase
string unhex
string upper
string zero
type is_matches_regex
Type
type is_bool
type is_enum
type is_char
type is_date
type is_decimal
type is_email
type is_hour
type is_time
type is_hour_without_sec
type is_integer
type is_number
type is_byte
type is_small_int
type is_medium_int
type is_int
type is_big_int
type is_float
type is_double
type is_timestamp
type is_valid_date
type is_valid_date
type is_valid_time
type is_valid_timestamp
type is_valid_timestamp
type is_varchar
Constant
constant math_four_pi
constant math_half_pi
constant math_pi
constant math_pi_square
constant math_two_pi
constant physics_a0
constant physics_amu
constant physics_bohr_magneton
constant physics_c
constant physics_c_square
constant physics_e
constant physics_eh
constant physics_f
constant physics_fine_structure
constant physics_g
constant physics_g0
constant physics_k
constant physics_lp
constant physics_m_deuteron
constant physics_m_electron
constant physics_m_muon
constant physics_m_neutron
constant physics_m_proton
constant physics_magn_flux_quantum
constant physics_mp
constant physics_n
constant physics_newtonian_g
constant physics_nuclear_magneton
constant physics_perm_vac_electric
constant physics_perm_vac_magnetic
constant physics_planck
constant physics_planck_over_two_pi
constant physics_r
constant physics_rinf
constant physics_stefan_boltzmann
constant physics_tp
constant physics_z0
CSV
csv parse
HTML
html load_from_str
html load_from_url
html close
html close_all
html show
html exist
html element
html parse
json parse_obj
json parse_array
JSON
json load
json show
json load select
json load by ref
json iobject
json count
json select
json is object
json is array
json exist
json doc
json fields
json iarray
json iarray
json uarray
json uobject
json darray
json dobject
json unload
json unload_all
XML
xml load
xml show
xml doc
xml exist
xml count
xml select node
xml select text
xml select attribute
xml xpath
xml fields
xml itext
xml inode
xml utext
xml iattribute
xml dattribute
xml dnode
xml unload
xml unload_all
xml escape_10
xml escape_11
File Watcher
file_watcher start
file_watcher kill
file_watcher exist
file_watcher show
File
file create
file append
file exist
file image_resize
file image_rotate_90
file is_directory
file load
file count_line dir
file count_lines
file meta_data
file cur_abs_dir
file cur_canonical_dir
file pwd
file size
file last_modified
file mkdir
file delete
file copy_dir
file copy_file
file copy_format
file ini
file ini_str
file dir_list
file dir_list_regex
file b64_read
file b64_write
file writer_open
file writer_exist
file writer_show
file writer_add_line
file writer_add_bytes
file writer_flush
file writer_close
file writer_closeall
file reader_open
file reader_exist
file reader_show
file reader_get_line
file reader_get_bytes
file reader_close
file reader_closeall
Atom
atom before_exclud
atom before_includ
atom count
atom count_distinct
atom count_lrtrim
atom count_lrtrim_distinct
atom distinct
atom distinct_lrtrim
atom distinct_lrtrim_1sbefore
atom find
atom find_lrtrim
atom get
atom get_first
atom get_first_lrtrim
atom get_last
atom get_last_lrtrim
atom get_lrtrim
atom lrtrim
atom position
atom position_lrtrim
atom size
External REST API
rest http
rest http_json_post
rest https
rest https_json_post
External SOAP API
soap http
soap https
Compress
compress zip
compress unzip
compress tar
compress untar
compress tarGz
compress untarGz
compress tarBz2
compress untarBz2
compress jar
compress unjar
compress gz
compress ungz
compress bz2
compress unbz2
SQL
sql connect
sql show
sql auto_commit
sql set_timeout
sql value
sql row
sql col_distinct
sql block open
sql block close
sql block to_json
sql to json
sql to xml
sql to html
sql to excel
sql to excelx
sql to pdf
sql to csv
sql to csv_file
sql dml
sql parse
sql commit
sql rollback
sql disconnect
sql disconnect all
sql encode
sql show tables
sql select
sql show data
sql show desc
sql show activity
MongoDB
mongodb connect
mongodb client_show_loaded
mongodb client_exist
mongodb disconnect
mongodb disconnect all
mongodb database_show
mongodb database_load
mongodb database_show_loaded
mongodb database_exist
mongodb database_unload
mongodb database_unload all
mongodb collection_show
mongodb collection_load
mongodb collection_show_loaded
mongodb collection_exist
mongodb collection_unload
mongodb collection_unload all
mongodb collection_insert
mongodb collection_update
mongodb collection_delete
mongodb collection_select
mongodb database_stat
CM
cm set mentdb
cm set as400
cm set db2
cm set derby_embedded
cm set derby_server
cm set firebird
cm set h2_embedded
cm set h2_server
cm set hsql_embedded
cm set hsql_server
cm set mysql
cm set oracle
cm set postgresql
cm set sqlserver
cm set file
cm set ftp
cm set ftps
cm set sftp
cm set ssh
cm set cifs
cm set smtp
cm set pop3
cm set imap
cm show_scrud
cm show
cm show_obj
cm get
cm generate_update
cm exist
cm remove
Tunnel
tunnel connect
tunnel execute_hot
tunnel execute_hot cluster
tunnel execute cluster
tunnel execute
tunnel disconnect
tunnel disconnect all
mql
mql encode
Mail
mail download pop3
mail download imap
mail download imap_disk
mail send
mail process
mail process_limit
mail count_loaded
mail count_all
mail count_error
mail min_error_date
mail show
mail show_error
mail get_body
mail get_error
mail replay_error_id
mail replay_error_cm
mail replay_error_all
mail delete_error_id
mail delete_error_cm
mail delete_error_all
FTP
ftp set timeout
ftp connect
ftp set type
ftp active compression
ftp active
ftp passive
ftp cd
ftp pwd
ftp mkdir
ftp ls
ftp rename
ftp put
ftp get
ftp rm file
ftp rm dir
ftp disconnect
ftp disconnect all
FTPS
ftps connect
ftps parse pbsz
ftps exec prot
ftps active
ftps passive
ftps set type
ftps cd
ftps pwd
ftps mkdir
ftps ls
ftps ls dirs
ftps rename
ftps put
ftps get
ftps rm
ftps rm dir
ftps disconnect
ftps disconnect all
SFTP
sftp connect
sftp cd
sftp lcd
sftp pwd
sftp lpwd
sftp mkdir
sftp ls
sftp rename
sftp home
sftp version
sftp put
sftp get
sftp rm
sftp rm dir
sftp disconnect
sftp disconnect all
CIFS
cifs mkdir
cifs rm
cifs ls
cifs rename
cifs get
cifs put
SSH
ssh connect
ssh execute_1_cmd
ssh execute_n_cmd
ssh scp from
ssh scp to
ssh disconnect
ssh disconnect all
Excel
excel load
excel load empty
excel show
excel save
excel exist
excel sheet add
excel sheet delete
excel sheet max_row
excel sheet show
excel cell get
excel cell eval
excel cell ref
excel cell set
excel cell format
excel close
excel close_all
excel build_in_format
Excelx
excelx load
excelx load empty
excelx show
excelx save
excelx exist
excelx sheet add
excelx sheet delete
excelx sheet max_row
excelx sheet show
excelx cell get
excelx cell eval
excelx cell ref
excelx cell set
excelx cell format
excelx close
excelx close_all
MSWord
msword replace
MSWordx
mswordx replace
PDF
pdf from html
pdf compress_image
SCRUD
scrud select
scrud export
scrud create
scrud parse
scrud db_to_db
scrud csv_to_db
scrud insert
scrud update
scrud merge
scrud delete
Microsoft
azure get_token
Stripe
stripe session
Stack
stack
stack process
stack status
stack reset
stack process_limit
stack count_wait
stack count_running
stack count_closed
stack count_error
stack delete_wait_id
stack delete_wait_script
stack delete_closed_id
stack delete_closed_script
stack delete_error_id
stack delete_error_script
stack reset_error_nbattempt_id
stack reset_error_nbattempt_script
stack replay_error_id
stack replay_error_script
stack get
stack search
Job
job help
job add
job create|insert|add
job show
job show activate
job exist
job pause
job resume
job generate update
job update
job set cluster_script
job remove
job scheduler stop
job scheduler start
job scheduler restart
job scheduler status
Predictive analysis
pa polynomial_curve_fit_get_coeff
pa polynomial_curve_fit_eval
pa polynomial_curve_fit_eval_incr
pa xy_scatter
pa xy_scatter
pa rl load
pa rl load_from_json
pa rl load_empty
pa rl exist
pa rl show
pa rl add_data
pa rl slope
pa rl intercept
pa rl predict
pa rl intercept_std_err
pa rl mean_square_error
pa rl count
pa rl r
pa rl sum_squares
pa rl r_square
pa rl significance
pa rl slope_confidence_interval
pa rl slope_std_err
pa rl sum_squared_errors
pa rl total_sum_squares
pa rl x_sum_squares
pa rl slope_confidence_interval
pa rl close
pa rl close_all
pa rm load
pa rm load_from_json
pa rm set_no_intercept
pa rm calculate_adjusted_r_squared
pa rm calculate_residual_sum_of_squares
pa rm calculate_r_squared
pa rm calculate_total_sum_of_squares
pa rm estimate_error_variance
pa rm estimate_regressand_variance
pa rm estimate_regression_standard_error
pa rm estimate_regression_parameters_variance
pa rm estimate_residuals
pa rm estimate_regression_parameters_standard_errors
pa rm estimate_regression_parameters
pa rm predict
pa rm exist
pa rm show
pa rm close
pa rm close_all
Data quality
dq algorithm show
dq algorithm set
dq algorithm exist
dq algorithm get
dq algorithm remove
dq generate
dq analyse
dq analyse show
Machine Learning
ml cluster xy_scatter
ml cluster load
ml cluster load_from_json
ml cluster exist
ml cluster show
ml cluster nb
ml cluster nb_point
ml cluster points
ml cluster point_get
ml cluster point_delete
ml cluster point_add
ml cluster point_update
ml cluster distance
ml cluster close
ml cluster close_all
ml h_node load_from_json
ml h_node add_problem
ml h_node predict
ml h_node exist
ml h_node exist_problem
ml h_node show
ml h_node show_problem
ml h_node close_problem
ml h_node close
ml h_node close_all
Deep Learning
dl4j csv_train_and_save_model
dl4j csv_load_model
dl4j csv_predict
dl4j show
dl4j exist
dl4j delete
dl n_bayesian create_train_file
dl n_bayesian show
dl n_bayesian exist
dl n_bayesian create_model
dl n_bayesian load
dl n_bayesian predict
dl n_bayesian delete
dl bayesian show
dl bayesian exist
dl bayesian create
dl bayesian add_sentence
dl bayesian init
dl bayesian predict
dl bayesian delete
dl csv execute_config
dl csv load_network
dl csv predict
dl img step1 create_training
dl img step2 add_image
dl img step3 create_hidden_layer
dl img step4 create_or_load_network
dl img step5 train_network
dl img step6 predict
dl img step7 close_file
dl img execute_config
dl img load_network
dl img predict
Bot
bot create
bot show
bot get
bot exist
bot reload
bot delete
bot user_create
bot user_show
bot user_get
bot user_exist
bot set_wait_replay
bot get_wait_replay
bot right_add
bot right_check
bot right_delete
bot right_show
bot user_set_var
bot user_get_var
bot user_get_vars
bot user_delete
bot training_merge
bot training_get
bot training_exist
bot training_version_get
bot training_version_exist
bot training_generate_merge
bot training_version_generate_merge
bot training_version_delete
bot training_search
bot training_push
bot training_pull
bot execute
Language
language create
language create|insert|add
language show
Symbol
symbol create
symbol create|insert|add
symbol first
symbol last
symbol show
symbol get
symbol perception
symbol show words
symbol show languages
symbol stimulate
Word
word create
word create|insert|add
word create
word create|insert|add
word exist
word first
word last
word get
word lang probability
word search
word levenshtein
word show languages
word show
word show
word perception
word perception symbol
word perception thought
word stimulate
word delete
word delete
Thought
thought create
thought create|insert|add
thought show
thought show
thought first
thought last
thought get
thought merge
thought prob_in_words
thought show words
thought show words
thought stimulate
thought delete
thought delete by lang
thought delete by word
thought delete by word lang
Relation
relation create
relation create|insert|add
relation show sentence
relation translate
relation search
relation execute
relation show thoughts
relation show thought nodes
relation stimulate
relation delete
Circle
circle merge
circle exist
circle contains
circle show
circle ids
circle id
circle delete
Concentration
concentration show
concentration set depth
concentration depth
Sequence
sequence show
sequence get current
sequence add
sequence create|insert|add
sequence exist
sequence increment
sequence update
sequence generate update
sequence remove
Node
node create
node create|insert|add
node exist
node delete
node iobject
node show
node count
node fields
node iarray
node iarray
node is array
node is object
node select
node uarray
node uobject
node darray
node dobject
Metric
metric sessions
metric system
metric current cpu jvm
metric current cpu system
metric current free mem
metric current free swap mem
metric current mem jvm
metric current used mem
metric current used swap mem
metric date
metric file system roots
metric java vendor
metric java version
metric system architecture
metric system name
metric system nb processor
metric system version
metric total mem
metric total swap mem
Environment variable
env set var
concat_var
env incr var
env decr var
env get var
env exist var
env del var
env show
Session
WS Session
@chat
@cmdid
@count sessions
@sessions
@sid
DB Session
bye
cmdid
count sessions
exit
help
quit
sessions
sid
@pid
who
Parameter
parameter add
parameter create|insert|add
parameter merge
parameter exist
parameter get value
get_param
parameter remove
parameter show
parameter update
parameter lock_if_null
parameter generate update
parameter generate merge
Log
log trace
log write
log show
log current id
log retention day
log remove
log archive size
log archive path
log reset
log search
log show_time
OS
os version
os arch
os name
os type
os hostname
os user_timezone
os user_name
os user_lang
os user_home
os user_dir
os execute
Server
id
ai firstname
ai lastname
name
ai name
shutdown
stop
wait
maintenance get
maintenance set
version
exceeded sessions
reset exceeded sessions
@exceeded sessions
@reset exceeded sessions
src count
function count
refresh admin
refresh devel
refresh config
in editor
in clipboard
in out_editor
in activity
in scatter
config reload
kill
kill_process
Home
> MQL Functions 1254f - MQL v_3.1.6
MentDB © 2012 - 2023