MySQL - Explain the "mysql" command Line options

Explain the "mysql" command Line options.

Following are the most commonly used mysql command line options:

1. -u username – Specifies username while connecting to server.
2. -p password – Specifies password while connecting to server.
3. -h hostname – Specifies hostname when server is running. Default being local host.
4. -e command – Executes the specified command.
5. "-H" - Specifies that the query output is displayed in HTML table format.
6. "-X" - Specifies that the query output is displayed in XML element format.
MySQL - Explain few command line arguments in MYSQL
Explain few command line arguments in MYSQL - -D – specifies database to use, -h, --host=name - connects to host......
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......
Post your comment

Related Content

Follow us

▲