1950082774

• V

o±

B —

MySQL Command Linę Client

En ter password: x-x-x-x-x-x-x-x-x-x

Uelcome to the MySQL monitor. Commands end with ; or \g.

Vour MySQL connection id is 74 to serwer wersion: 5.0.24a-community-nt

Type *help;' or '\h' for help. Type '\c' to elear the buffer.

mysql> \h

For information about MySQL products and serwices, uisit: http://www.mysql.com/

For deweloper information, including the MySQL Reference Manuał, uisit: http://deu.mysql.com/

To buy MySQL Network Support, training, or other products, uisit: https://shop.mysql.com/

List of all MySQL commands:

Notę that all text commands must be first on linę and end with * ;'

I?    <\?>    Synonym for 'help' .

elear    <\c>    Clear command.

connect <\r> Reconnect to the serwer. Optional arguments are db and host. delimiter <\d> Set statement delimiter. NOTĘ: Takes the rest of the linę as new delimiter.

ego    <\G> Send command to mysql serwer, display result wertically.

exit    <\q> Exit mysql. Same as quit.

go    <\g> Send command to mysql serwer.

help    <\h>    Display this help.

notee    <\t>    Don't write into outfile.

print    <\p>    Print current command.

prompt    <\R>    Change your mysql prompt.

quit    <\q>    Quit mysql.

rehash    <\#>    Rebuild completion hash.

source    <\.>    Execute an SQL script file.    Takes a file name as    an argument.

Status    <\s>    Get    status information from    the serwer.

tee    <\T>    Set    outfile [to_outfile]. fippend ewerything into    giwen    outfile.

use    <\u>    Use    another database. Takes    database name as argument,

charset <\C> Switch to another charset. Might be needed for Processing binlog with multi-byte charsets.

warnings <\W> Show warnings after ewery statement. nowarning <\w> Don't show warnings after ewery statement.

go

help

notee

print

prompt

quit

rehash

source

Status

tee

use

charset

For serwer side help, type 'help contents' mysql> show databases;

System Zarządzania Bazą Danych

Kalkulator

Zadorskie..

Moje miejsca sieciowe

Mapy_Pol_G... dane_do_z7 Kosz chroniony przez pakiet...

zamówienie,

-'•/■.U    i .

■V-ł

* t •*    ■ -*    •- V

dfL

Database

information_schema

bud2et2005

mysql

statygraf ia test

5 rows in set <0.00 sec>

mysql> use statygrafia; Database changed mysql> show tables;

Tables_in_statygraf ia

litologia próby prof ile stratygraf ia

4 rows in set <0.00 sec) mysql> _

Kliknij, aby dodać notatki

i R^suj ’ Autokształty - \ \ □ O Al Q ifi] |JI I ^ * ł

Slajd 13 z 16

Piksel

Polski

Start

JłI Wideo AVerTV GO...

= Total Commander... E Skrzynka odbiorcz...    ' . http://meta.geop.

Ej| WYKORZYSTANIE ...

Microsoft PowerP...

► MySOL Administrator

Norton