Collections:
"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
2018-04-28, 935👍, 0💬
Popular Posts:
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...