Documentation | MentDB Weak Server

Generate MQL to INSERT/UPDATE/DELETE/ALTER on a database

To generate MQL to INSERT/UPDATE/DELETE/ALTER on a database:
Right click on 'MENTDB' and select 'DML...'

sql connect "session1" {cm get "MENTDB";};
sql dml "session1" (concat "insert into products (id, name, quantity) values (4, 'other', '4567');");
sql disconnect "session1";

Update your SQL request...
Execute buttons
```
"1";
```
1 is the result of the last command 'sql disconnect "session1";' not the number of insert row
To the number of row inserted:

sql connect "session1" {cm get "MENTDB";};
-> "[nb_row]" (sql dml "session1" (concat "insert into products (id, name, quantity) values (4, 'other', '4567');"));
sql disconnect "session1";
[nb_row];