в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:29Z

1 версия

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

== A simple multiple-line statement.==



<source lang="sql">
mysql>
mysql> SELECT
-> USER()
-> ,
-> CURRENT_DATE;
+----------------+--------------+
| USER() | CURRENT_DATE |
+----------------+--------------+
| root@localhost | 2007-07-22 |
+----------------+--------------+
1 row in set (0.00 sec)
mysql></source>

== Prompts and their meaning==

Prompt
Meaning
mysql>
Ready for new command.
->
Waiting for next line of multiple-line command.
">
Waiting for a single quote (") in the next line.
">
Waiting for double quote (") in the next line.
`>
Waiting for a backtick (`) in the next line.
/*>
Waiting for /* in the next line.

== The Most Important mysql Commands==

Abbreviation
Command
Interpretation
\c
clear
terminates input of command.
\h
help
displays a list of commands.
\q
exit or quit
ends mysql.
\s
status
shows status information on the MySQL server.
\T [f]
tee [filename]
logs all input and output into the specified file.
\t
notee
ends tee. The logging can be resumed at any time with tee or \T.
\u db
use database
makes the specified database the default.
\. fn
source filename
executes the SQL commands contained in the given file. The commands must be separated by semicolons.

== To cancel the command: type the "\c" command==



<source lang="sql">
mysql>
mysql>
mysql> CREATE TABLE employee (
-> ID IN(3)
-> \c
mysql>
mysql></source>

== You can enter multiple statements on a single line and end each one with a semicolon:==



<source lang="sql">
mysql>
mysql> SELECT VERSION(); SELECT NOW();
+---------------------+
| VERSION() |
+---------------------+
| 5.0.41-community-nt |
+---------------------+
1 row in set (0.00 sec)
+---------------------+
| NOW() |
+---------------------+
| 2007-07-22 20:10:16 |
+---------------------+
1 row in set (0.00 sec)
mysql></source>

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

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

в 13:44, 26 мая 2010

Admin: 1 версия