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, 2356🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...