в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:06Z

1 версия

Новая страница

== Continue even if errors in batch mode, you should use the --force command-line option==



<source lang="sql">
shell> mysql --force < batch-file</source>

== If anonymous (unnamed) user is allowed, you should be able to connect to that server by invoking mysql without any options:==



<source lang="sql">
shell> mysql</source>

== If you are logging in on the same machine that MySQL is running on, you can omit the host.==



<source lang="sql">
shell> mysql -u user -p</source>

== If you need to specify connection parameters on the command line in batch mode==



<source lang="sql">
shell> mysql -h host -u user -p < batch-file</source>

== Logging In with mysql==



<source lang="sql">
$ mysql -u <username> -p</source>

== Non-Interactive Commands==

Just do a quick look up on a table without logging into the client, running the query then logging back out again.
You can instead just type one line using the " -e " flag.



<source lang="sql">
c:\mysql\bin\mysql -u admin -p myDatabase -e "SELECT * FROM employee"</source>

== Remote Client Connection==

If you have set the privileges to allow remote connections to a database, you can connect from a remote command line client by using the -h flag:



<source lang="sql">
c:\mysql\bin\mysql -u <username> -p -h <host></source>

== Run the output through a pager==



<source lang="sql">
shell> mysql < batch-file | more</source>

== Supply your password on the command line after the -p option.==

You must do so with no intervening space



<source lang="sql">
mysql> -pmypassword, not as -p mypassword</source>

== To escape some special characters in the file==



<source lang="sql">
shell> mysql -e "source batch-file"</source>

== To see a list of options provided by mysql, invoke it with the --help option:==



<source lang="sql">
shell> mysql --help</source>

== Use scripts from the mysql prompt by using the source command or \. command==



<source lang="sql">
mysql> source filename;
mysql> \. filename

mysql></source>

== Using mysql in Batch Mode==

Put the commands you want to run in a file.



<source lang="sql">
shell> mysql < batch-file</source>

== You can catch the output in a file for further processing==



<source lang="sql">
shell> mysql < batch-file > mysql.out</source>

== You can select the database on the command line when you invoke mysql.==

You must select database for use each time you begin a mysql session.



<source lang="sql">
mysql>
shell> mysql -h host -u user -p yourDatabaseName
mysql></source>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/MySQL Utilities/mysql - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия