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
⇒ DDL Commands Supported in MySQL
⇐ "mysql" Command Line Options in MySQL
2018-04-28, 1831🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...