This link has the list of command line options that can be used by the clients. Here below some examples using for instance the option “-e” that means execute the SQL statement inside the double quotes and quit:
“use employees; show tables;”
Another example is adding “--port=3306” to specify the
TCP/IP port to be used in this connection to the MySQL server. When specifying a
non-existent port (#3307 in this case) the system generates an error as
expected.
Knowing these command line options can be useful to perform different types of tasks and is good to be familiar with some of them. You may also encounter the options being used by reading SQL forums.
No comments:
Post a Comment