przeglÄ…danieºzy

â–  Sk)

Plik Edycja Widok Zakładki Ustawienia Pomoc

Asus:/home/piotr # mysql -h localhost -u root -p£Mttest Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.1.57-log SUSE MySQL RPM

Copyright (c) 2000, 2010, Oracle and/or its affiliates. Ali rights reserved. This software comes with ABSOLLTTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or ‘\h‘ for help. Type '\c' to elear the current input statement.

mysql> show databases;

+....................+

| Database    |

+--------------------+

| information_schema |

I mysql    I

| test    |

+....................+

3 rows in set (0.00 sec)

mysql> use test;

Database changed mysql> show tables;

+----------------+

| Tables_in_test |

+................+

| uczniowie    |

+................+

1 row in set (0.00 sec)

mysql> describe uczniowie;

1	Field	1	Type	1	Nuli	1	Key	1	Default	| Extra	1
1	uczenid	1	int(10) unsigned	1	NO	1	PRI	1	NULL	| auto inerement	1
1	nazwisko	1	char(30)	1	NO	1		1	NULL	1	1
1	imiel	1	char(15)	1	NO	1		1	NULL	1	1
1	imie2	1	char(15)	1	YES	1		1	NULL	1	1
1	adres	1	char(40)	1	NO	1		1	NULL	1	1
1	miejscowość	1	char(30)	1	NO	1		1	NULL	1	1
+		-+		-+	____	-+		+		â– +...............	-+

6 rows in set (0.00 sec) mysql> |

piotr: mysql

U

A

V