Is there distinction between the commands understood by the MySQL client and understood by the MySQL server?

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP



Is there distinction between the commands understood by the MySQL client and understood by the MySQL server?



When using MySQL in command line (such as Bash),



is there a similar distinction between PostgreSQL server and client psql? If yes, what are the MySQL client and MySQL server when I run mysql in a OS shell? I never see in MySQL document a distinction between MySQL client/shell and MySQL server.


mysql



is there distinction between the commands understood by the MySQL client and understood by the MySQL server?
For comparison, in Postgresql, psql has its own commands usually started with , such as l, while postgresql server only understands SQL commands and doesn't understand psql commands.
In MySQL official document, I don't find it mentions whether a command is only understood by the MySQL client or by the MySQL server.



l



Thanks.




1 Answer
1



The command line client mysql also has commands that are interpreted by the client program rather than sent to the server.


mysql



Like for psql, these commands start with a backslash.


psql



You can find a list in the documentation.





Thanks Is it correct that all commands not started with a backslash are understood by MySQL server?
– Tim
Aug 8 at 13:30





Not necessarily understood by, but sent to.
– Laurenz Albe
Aug 8 at 14:03






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Firebase Auth - with Email and Password - Check user already registered

Dynamically update html content plain JS

Creating a leaderboard in HTML/JS