I think the issue was by ths following , Looking at how mysqli_multi_query works, you need to put your queries concatenated by a semicolon and then send that single query to the function. Right now you are sending the two queries separately so it will only do one query at a time.
To fix the issue you can do I ended up writing my own gem, which includes a little wrapper around MySQL. Not a fully-fledged mysql client, but a minimal bridge in order to support SphinxQL. You can see the gem here: https://github.com/d11wtq/oedipus
What's the idiomatic way to write multi-line ActiveRelation queries?
Hope that helps It is not console stops, it's query executing. Probaly, the table is big, and SELECT * - the most inefficent possible query - may take a lot of time to execute. Try something easier to test everything works, like this:
seems to work fine I found the answer myself, there should not be any additional white space characters in the query, entire query should be in continuous line. The beauty of blueprism is, it can execute any level of complex queries without any constraints, but need to modify the syntax accordingly. always we should mention the filename and table names in the following format - [databasename].[dbo].[tablename].[fieldname]