Innov-AI
    Documentation | MentDB Weak Server
Get a single value from a SQL table

  • try {
    
    	sql connect "session1" {cm get "demo_cm_mysql";};
    	-> "[name]" (sql value "session1" (concat "select name from products where id=1"));
    	
    	# Here your MQL source code to work with [name];
    	
    	sql disconnect "session1";
    
    } {
    
    	try {sql disconnect "session1";} {} "[err_sql]";
    	log trace [err]; 
    
    } "[err]";
  • An error is generated if no value is found... try...
Services     Supporters     Contact     About     Legal notice © 2024