MySQL - Explain few command line arguments in MYSQL

Explain few command line arguments in MYSQL.

Command line arguments can be seen typing
Mysql –help in command line.

Following are the options:

1. -D – Specifies database to use.

2. -h, --host=name - Connects to host.

3. -H, --html – Produce HTML output.

4. -X, --xml – Produce XML output.

5. -t, --table – Produces in table format.

6. -w –wait - Waits and retry if connection is lost.

7. --show-warnings – Show warnings after every statement.
MySQL - Explain some of the non-standard SQL commands in MySQL
Explain some of the non-standard SQL commands in MySQL - There are many non-standard SQL commands that are supported by mysql. Here is short list of some commonly used commands.......
MySQL - Differentiate between BINARY and VARBINARY in MySQL
Differentiate between BINARY and VARBINARY in MySQL - BINARY and VARBINARY have the same nature of differences like CHAR and VARCHAR......
MySQL - Differentiate between CHAR and VARCHAR in MySQL
Differentiate between CHAR and VARCHAR in MySQL - CHAR stores the data or values in fixed length format. If the size of the string is smaller than the specified length.......
Post your comment