MySQL Programming Question:

Download Job Interview Questions and Answers PDF

What Are the "mysql" Command Line Arguments?

MySQL Programming Interview Question
MySQL Programming Interview Question

Answer:

"mysql" supports only one optional command line argument, "database". But "mysql" allows the operating system to redirect input and output streams at the command line level. Here are some good examples:

► "mysql databaseName" - Starts "mysql" in interactive mode and use the specified database.
► "mysql < fileName" - Starts "mysql" in batch mode and executes all commands in the specified file.
► "mysql < fileName > fileName" - Starts "mysql" in batch mode, executes all commands in the specified file, and write output to the specified file.

Here is a tutorial exercise of how to use the command line argument to specify the database to use:

>cd mysqlin
>mysql -u root test
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 4 to server version: 5.0.24

mysql> show tables;
<pre>+----------------+
| Tables_in_test |
+----------------+
| links |
+----------------+</pre>
1 row in set (0.00 sec)

mysql> quit;
Bye

Download MySQL Programming Interview Questions And Answers PDF

Previous QuestionNext Question
What Are the "mysql" Command Line Options?How Many SQL DDL Commands Are Supported by "mysql"?