Collections:
Other Resources:
"mysql" Command Line Arguments in MySQL
What Are the "mysql" Command Line Arguments in MySQL?
✍: FYIcenter.com
"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:
Here is a tutorial exercise of how to use the command line argument to specify the database to use:
>cd \mysql\bin >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; +----------------+ | Tables_in_test | +----------------+ | links | +----------------+ 1 row in set (0.00 sec) mysql> quit; Bye
2016-10-16, 310👍, 0💬
Popular Posts:
How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...