It's the behavior of official mysql cli client. I think it's reasonable.
Here are my 2 suggestions. Accepting any one of them will improve this software.
Do not execute sql without semicolon.
Only execute sql which is only for viewing data, like select * from foo and show databases. Sql for updating data, like update and delete, should require a semicolon to execute. Or ask user whether to execute if there's no semicolon;
amjith
commented
10 months ago
It's the behavior of official mysql cli client. I think it's reasonable.
Here are my 2 suggestions. Accepting any one of them will improve this software.
select * from fooandshow databases. Sql for updating data, likeupdateanddelete, should require a semicolon to execute. Or ask user whether to execute if there's no semicolon;