What Are the "mysql" Command Line Arguments

Q

What Are the "mysql" Command Line Arguments? - MySQL FAQs - Command-Line End User Interface mysql

✍: FYIcenter.com

A

"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:

"mysql databaseName" - Starts "mysql" in interactive mode and use the specified database.
"mysql < fileName" - Starts "mysql" in batch mode and executes all commands in the specified file.
"mysql < fileName > fileName" - Starts "mysql" in batch mode, executes all commands in the specified file, and write output to the specified file.

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

2007-05-10, 5257👍, 0💬

What Are the "mysql" Command Line Arguments
What Are the "mysql" Command Line Arguments? - MySQL FAQs - Command-Line End User Interface mysql "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:... 2007-05-10, 5258👍, 0💬

How To Connect MS Access to Oracle Servers
How To Connect MS Access to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection Once you got a DSN defined in the ODBC manager that connects to an Oracle server, you can connect a normal MS Access document to the Oracle server, and link an Access table to Oracle tab... 2007-04-17, 5026👍, 0💬

Java Bean Class with 100 Fields
How to write a bean class, when you have 100 fields and each have three sub fields. 2007-04-26, 5004👍, 0💬

How To Connect ASP Pages to Oracle Servers
How To Connect ASP Pages to Oracle Servers? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Connection If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the co... 2007-04-17, 4880👍, 0💬

What Are the Non-Standard SQL Commands Supported by "mysql"
What Are the Non-Standard SQL Commands Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands: "SHOW infoName" - Shows basic information of based on the speci... 2007-05-10, 4631👍, 0💬

What Is the Command Line End User Interface - mysql
What Is the Command Line End User Interface - mysql? - MySQL FAQs - Command-Line End User Interface mysql "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It i... 2007-05-10, 4540👍, 0💬

How To Get Help Information from the Server
How To Get Help Information from the Server? - MySQL FAQs - Command-Line End User Interface mysql While you are at the "mysql>" prompt, you can get help information from the server by using the "HELP" command. The tutorial exercise below shows sevearal examples: >cd \mysql\bin >mysql -u root mysql> ... 2007-05-10, 4527👍, 0💬

How Many SQL DDL Commands Are Supported by "mysql"
How Many SQL DDL Commands Are Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql There are 4 SQL Data Definition Language (DDL) commands that are supported by "mysql". They are listed below with short descriptions: "CREATE dataObjectType dataObjectName" - Creates new database... 2007-05-08, 4516👍, 0💬

What Are the "mysql" Command Line Options
What Are the "mysql" Command Line Options? - MySQL FAQs - Command-Line End User Interface mysql "mysql" offers a big list of command line options. Here are some commonly used options: "-?" - Displays a help message on how to use "mysql" and terminates the program. "-u userName" - Specifies a user na... 2007-05-08, 4396👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.