CamelotSql assumes that SQL statements are placed first terminated with ";" and then followed by any other execution options.
To list all available commands and options, type help or ?.
camelotsql> ?List of all CamelotSql commands:Note that all sql commands (SELECT, INSERT, UPDATE, etc) must be first on line and end with ";"? Synonym for 'help'.clear Clear window and reset cursor position.cls Synonym for 'clear'.config Show stored connections.connect Connect to server using named connection or with specified options. Type 'help connect' for details. 'connect myconnection' 'connect -server 192.168.0.1 -user foo -password -bar'delete Delete connection from configuration. 'delete myconnection'exit Same as quit.help Displays this help.pager Set default page size or disable/enable pager. 'pager 20' 'pager off'quit Quit CamelotSql.save Save named connection with specified options. Type 'help save' for details.For sql execution options, type 'help options'.camelotsql>
camelotsql> save mysharepoint -server 192.168.1.34 -user foo -password bar -timeout 60Saved connection mysharepoint..camelotsql>
camelotsql> connect mysharepointConnected to mysharepoint..camelotsql>
camelotsql> connect -server 192.168.1.34 -user foo -password bar -timeout 60Connected to 192.168.1.34..camelotsql>
Register new account
Handle your account
Handle your licenses