ΟΙ ΑΛΛΑΓΕΣ ΓΡΑΜΜΗΣ ΕΓΙΝΑΝ ΓΙΑ ΛΟΓΟΥΣ ΧΩΡΟΥ ΕΠΕΙΔΗ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ
ΜΕΓΑΛΗ ΓΡΑΜΜΑΤΟΣΕΙΡΑ ΓΙΑ ΕΥΚΟΛΗ ΑΝΑΓΝΩΣΗ. ΟΙ ΜΑΘΗΤΕΣ ΜΠΟΡΟΥΝ
ΝΑ ΔΙΝΟΥΝ ΤΗΝ ΚΑΘΕ ΕΝΤΟΛΗ ΣΤΗΝ ΙΔΙΑ ΓΡΑΜΜΗ ΚΑΙ Η MYSQL ΝΑ ΑΛΛΑΖΕΙ ΜΟΝΗ
ΤΗΣ.
Your MySQL connection id is 1
Server version: 5.1.51-community MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY 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 clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| altes |
| dates |
| dianomes |
| mc |
| mysql |
| persons |
| skopos |
| test |
| xartziliki |
+--------------------+
10 rows in set (0.19 sec)
mysql> create database proion;
Query OK, 1 row affected (0.03 sec)
mysql> use proion;
Database changed
mysql> create table proionta(codepro int,categ char(20),posotita int,timi int pr
imary key(codepro));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(code
pro))' at line 1
mysql> create table proionta(codepro int,categ char(20),posotita int,timi int, p
rimary key(codepro));
Query OK, 0 rows affected (0.19 sec)
mysql> insert into proionta values(12,'printer',4,80);
Query OK, 1 row affected (0.06 sec)
mysql> insert into proionta values(12,'printer',2,90);
ERROR 1062 (23000): Duplicate entry '12' for key 'PRIMARY'
mysql> insert into proionta values(10,'printer',2,90);
Query OK, 1 row affected (0.03 sec)
mysql> insert into proionta values(1,'tower',3,180);
Query OK, 1 row affected (0.05 sec)
mysql> insert into proionta values(2,'tower',1,260);
Query OK, 1 row affected (0.05 sec)
mysql> insert into proionta values(14,'scanner',2,89);
Query OK, 1 row affected (0.05 sec)
mysql> insert into proionta values(16,'scanner',3,95);
Query OK, 1 row affected (0.05 sec)
mysql> insert into proionta values(18,'pccamera',5,28);
Query OK, 1 row affected (0.05 sec)
mysql> select * from proionta;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
7 rows in set (0.00 sec)
mysql> select * from proionta group by posotita;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 2 | tower | 1 | 260 |
| 10 | printer | 2 | 90 |
| 1 | tower | 3 | 180 |
| 12 | printer | 4 | 80 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
5 rows in set (0.02 sec)
mysql> select * from proionta group by categ;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 18 | pccamera | 5 | 28 |
| 10 | printer | 2 | 90 |
| 14 | scanner | 2 | 89 |
| 1 | tower | 3 | 180 |
+---------+----------+----------+------+
4 rows in set (0.00 sec)
mysql> select * from proionta order by categ;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 18 | pccamera | 5 | 28 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
+---------+----------+----------+------+
7 rows in set (0.02 sec)
mysql> select * from proionta order by categ desc;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
7 rows in set (0.00 sec)
mysql> select sum(timi) from proionta;
+-----------+
| sum(timi) |
+-----------+
| 822 |
+-----------+
1 row in set (0.03 sec)
mysql> select avg(timi) from proionta;
+-----------+
| avg(timi) |
+-----------+
| 117.4286 |
+-----------+
1 row in set (0.00 sec)
mysql> select max(timi) as maximum value,min(timi) as minimum value from proiont
a;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'value
,min(timi) as minimum value from proionta' at line 1
mysql> select max(timi) as maximum_value,min(timi) as minimum_value from proiont
a;
+---------------+---------------+
| maximum_value | minimum_value |
+---------------+---------------+
| 260 | 28 |
+---------------+---------------+
1 row in set (0.03 sec)
mysql> select * from proionta where timi>29 and timi<100;
+---------+---------+----------+------+
| codepro | categ | posotita | timi |
+---------+---------+----------+------+
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
+---------+---------+----------+------+
4 rows in set (0.00 sec)
mysql> select * from proionta where timi<54 or timi>64;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
7 rows in set (0.00 sec)
mysql> select * from proionta where timi<54 or timi>94;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 16 | scanner | 3 | 95 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
4 rows in set (0.00 sec)
mysql> select * from proionta where timi>29 or timi<100;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
7 rows in set (0.00 sec)
mysql> select * from proionta where (timi<54 or timi>94)and categ='scanner';
+---------+---------+----------+------+
| codepro | categ | posotita | timi |
+---------+---------+----------+------+
| 16 | scanner | 3 | 95 |
+---------+---------+----------+------+
1 row in set (0.00 sec)
mysql> select * from proionta where (timi<54 or timi>94)and not (categ='scanner'
);
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
3 rows in set (0.00 sec)
mysql> select count(*) where categ='tower';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'where
categ='tower'' at line 1
mysql> select count(*) from proionta where categ='tower';
+----------+
| count(*) |
+----------+
| 2 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from proionta where categ='tower'or categ='printer';
+----------+
| count(*) |
+----------+
| 4 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from proionta where timi<=44 or timi>=82;
+----------+
| count(*) |
+----------+
| 6 |
+----------+
1 row in set (0.00 sec)
mysql> alter table proionta add column diathes char(20);
Query OK, 7 rows affected (0.33 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> select * from proionta;
+---------+----------+----------+------+---------+
| codepro | categ | posotita | timi | diathes |
+---------+----------+----------+------+---------+
| 1 | tower | 3 | 180 | NULL |
| 2 | tower | 1 | 260 | NULL |
| 10 | printer | 2 | 90 | NULL |
| 12 | printer | 4 | 80 | NULL |
| 14 | scanner | 2 | 89 | NULL |
| 16 | scanner | 3 | 95 | NULL |
| 18 | pccamera | 5 | 28 | NULL |
+---------+----------+----------+------+---------+
7 rows in set (0.00 sec)
mysql> update proionta set diathes='yes' where categ='printer';
Query OK, 2 rows affected (0.05 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from proionta;
+---------+----------+----------+------+---------+
| codepro | categ | posotita | timi | diathes |
+---------+----------+----------+------+---------+
| 1 | tower | 3 | 180 | NULL |
| 2 | tower | 1 | 260 | NULL |
| 10 | printer | 2 | 90 | yes |
| 12 | printer | 4 | 80 | yes |
| 14 | scanner | 2 | 89 | NULL |
| 16 | scanner | 3 | 95 | NULL |
| 18 | pccamera | 5 | 28 | NULL |
+---------+----------+----------+------+---------+
7 rows in set (0.00 sec)
mysql> update proionta set diathes='yes' where categ='pccamera';
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update proionta set timi=timi*1.03 where timi>=100;
Query OK, 2 rows affected (0.05 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from proionta;
+---------+----------+----------+------+---------+
| codepro | categ | posotita | timi | diathes |
+---------+----------+----------+------+---------+
| 1 | tower | 3 | 185 | NULL |
| 2 | tower | 1 | 268 | NULL |
| 10 | printer | 2 | 90 | yes |
| 12 | printer | 4 | 80 | yes |
| 14 | scanner | 2 | 89 | NULL |
| 16 | scanner | 3 | 95 | NULL |
| 18 | pccamera | 5 | 28 | yes |
+---------+----------+----------+------+---------+
7 rows in set (0.00 sec)
ΜΕΓΑΛΗ ΓΡΑΜΜΑΤΟΣΕΙΡΑ ΓΙΑ ΕΥΚΟΛΗ ΑΝΑΓΝΩΣΗ. ΟΙ ΜΑΘΗΤΕΣ ΜΠΟΡΟΥΝ
ΝΑ ΔΙΝΟΥΝ ΤΗΝ ΚΑΘΕ ΕΝΤΟΛΗ ΣΤΗΝ ΙΔΙΑ ΓΡΑΜΜΗ ΚΑΙ Η MYSQL ΝΑ ΑΛΛΑΖΕΙ ΜΟΝΗ
ΤΗΣ.
Your MySQL connection id is 1
Server version: 5.1.51-community MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY 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 clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| altes |
| dates |
| dianomes |
| mc |
| mysql |
| persons |
| skopos |
| test |
| xartziliki |
+--------------------+
10 rows in set (0.19 sec)
mysql> create database proion;
Query OK, 1 row affected (0.03 sec)
mysql> use proion;
Database changed
mysql> create table proionta(codepro int,categ char(20),posotita int,timi int pr
imary key(codepro));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(code
pro))' at line 1
mysql> create table proionta(codepro int,categ char(20),posotita int,timi int, p
rimary key(codepro));
Query OK, 0 rows affected (0.19 sec)
mysql> insert into proionta values(12,'printer',4,80);
Query OK, 1 row affected (0.06 sec)
mysql> insert into proionta values(12,'printer',2,90);
ERROR 1062 (23000): Duplicate entry '12' for key 'PRIMARY'
mysql> insert into proionta values(10,'printer',2,90);
Query OK, 1 row affected (0.03 sec)
mysql> insert into proionta values(1,'tower',3,180);
Query OK, 1 row affected (0.05 sec)
mysql> insert into proionta values(2,'tower',1,260);
Query OK, 1 row affected (0.05 sec)
mysql> insert into proionta values(14,'scanner',2,89);
Query OK, 1 row affected (0.05 sec)
mysql> insert into proionta values(16,'scanner',3,95);
Query OK, 1 row affected (0.05 sec)
mysql> insert into proionta values(18,'pccamera',5,28);
Query OK, 1 row affected (0.05 sec)
mysql> select * from proionta;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
7 rows in set (0.00 sec)
mysql> select * from proionta group by posotita;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 2 | tower | 1 | 260 |
| 10 | printer | 2 | 90 |
| 1 | tower | 3 | 180 |
| 12 | printer | 4 | 80 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
5 rows in set (0.02 sec)
mysql> select * from proionta group by categ;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 18 | pccamera | 5 | 28 |
| 10 | printer | 2 | 90 |
| 14 | scanner | 2 | 89 |
| 1 | tower | 3 | 180 |
+---------+----------+----------+------+
4 rows in set (0.00 sec)
mysql> select * from proionta order by categ;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 18 | pccamera | 5 | 28 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
+---------+----------+----------+------+
7 rows in set (0.02 sec)
mysql> select * from proionta order by categ desc;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
7 rows in set (0.00 sec)
mysql> select sum(timi) from proionta;
+-----------+
| sum(timi) |
+-----------+
| 822 |
+-----------+
1 row in set (0.03 sec)
mysql> select avg(timi) from proionta;
+-----------+
| avg(timi) |
+-----------+
| 117.4286 |
+-----------+
1 row in set (0.00 sec)
mysql> select max(timi) as maximum value,min(timi) as minimum value from proiont
a;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'value
,min(timi) as minimum value from proionta' at line 1
mysql> select max(timi) as maximum_value,min(timi) as minimum_value from proiont
a;
+---------------+---------------+
| maximum_value | minimum_value |
+---------------+---------------+
| 260 | 28 |
+---------------+---------------+
1 row in set (0.03 sec)
mysql> select * from proionta where timi>29 and timi<100;
+---------+---------+----------+------+
| codepro | categ | posotita | timi |
+---------+---------+----------+------+
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
+---------+---------+----------+------+
4 rows in set (0.00 sec)
mysql> select * from proionta where timi<54 or timi>64;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
7 rows in set (0.00 sec)
mysql> select * from proionta where timi<54 or timi>94;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 16 | scanner | 3 | 95 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
4 rows in set (0.00 sec)
mysql> select * from proionta where timi>29 or timi<100;
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 10 | printer | 2 | 90 |
| 12 | printer | 4 | 80 |
| 14 | scanner | 2 | 89 |
| 16 | scanner | 3 | 95 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
7 rows in set (0.00 sec)
mysql> select * from proionta where (timi<54 or timi>94)and categ='scanner';
+---------+---------+----------+------+
| codepro | categ | posotita | timi |
+---------+---------+----------+------+
| 16 | scanner | 3 | 95 |
+---------+---------+----------+------+
1 row in set (0.00 sec)
mysql> select * from proionta where (timi<54 or timi>94)and not (categ='scanner'
);
+---------+----------+----------+------+
| codepro | categ | posotita | timi |
+---------+----------+----------+------+
| 1 | tower | 3 | 180 |
| 2 | tower | 1 | 260 |
| 18 | pccamera | 5 | 28 |
+---------+----------+----------+------+
3 rows in set (0.00 sec)
mysql> select count(*) where categ='tower';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'where
categ='tower'' at line 1
mysql> select count(*) from proionta where categ='tower';
+----------+
| count(*) |
+----------+
| 2 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from proionta where categ='tower'or categ='printer';
+----------+
| count(*) |
+----------+
| 4 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from proionta where timi<=44 or timi>=82;
+----------+
| count(*) |
+----------+
| 6 |
+----------+
1 row in set (0.00 sec)
mysql> alter table proionta add column diathes char(20);
Query OK, 7 rows affected (0.33 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> select * from proionta;
+---------+----------+----------+------+---------+
| codepro | categ | posotita | timi | diathes |
+---------+----------+----------+------+---------+
| 1 | tower | 3 | 180 | NULL |
| 2 | tower | 1 | 260 | NULL |
| 10 | printer | 2 | 90 | NULL |
| 12 | printer | 4 | 80 | NULL |
| 14 | scanner | 2 | 89 | NULL |
| 16 | scanner | 3 | 95 | NULL |
| 18 | pccamera | 5 | 28 | NULL |
+---------+----------+----------+------+---------+
7 rows in set (0.00 sec)
mysql> update proionta set diathes='yes' where categ='printer';
Query OK, 2 rows affected (0.05 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from proionta;
+---------+----------+----------+------+---------+
| codepro | categ | posotita | timi | diathes |
+---------+----------+----------+------+---------+
| 1 | tower | 3 | 180 | NULL |
| 2 | tower | 1 | 260 | NULL |
| 10 | printer | 2 | 90 | yes |
| 12 | printer | 4 | 80 | yes |
| 14 | scanner | 2 | 89 | NULL |
| 16 | scanner | 3 | 95 | NULL |
| 18 | pccamera | 5 | 28 | NULL |
+---------+----------+----------+------+---------+
7 rows in set (0.00 sec)
mysql> update proionta set diathes='yes' where categ='pccamera';
Query OK, 1 row affected (0.05 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update proionta set timi=timi*1.03 where timi>=100;
Query OK, 2 rows affected (0.05 sec)
Rows matched: 2 Changed: 2 Warnings: 0
mysql> select * from proionta;
+---------+----------+----------+------+---------+
| codepro | categ | posotita | timi | diathes |
+---------+----------+----------+------+---------+
| 1 | tower | 3 | 185 | NULL |
| 2 | tower | 1 | 268 | NULL |
| 10 | printer | 2 | 90 | yes |
| 12 | printer | 4 | 80 | yes |
| 14 | scanner | 2 | 89 | NULL |
| 16 | scanner | 3 | 95 | NULL |
| 18 | pccamera | 5 | 28 | yes |
+---------+----------+----------+------+---------+
7 rows in set (0.00 sec)
Δεν υπάρχουν σχόλια:
Δημοσίευση σχολίου