Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1672
Server version: 5.7.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> use izglitibas_iestade_SDambis
Database changed
mysql> show tables
    -> showtables
    -> show databases;
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 'showtables
show databases' at line 2
mysql> show database;
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 'database' at line 1
mysql> show databases;
+-------------------------------+
| Database                      |
+-------------------------------+
| information_schema            |
| armands                       |
| d_kotelnikovs_kd              |
| db_name                       |
| db_name2                      |
| db_namel                      |
| errortesting                  |
| galdini                       |
| internetveikals               |
| ivkins_kd                     |
| ivkins_veikals_normal         |
| izglitibas_iestade_akidanovs  |
| izglitibas_iestade_kbrikmanis |
| izglitibas_iestade_sdambis    |
| izglitibas_iestade_vuzvards   |
| kb                            |
| kdv3                          |
| mysql                         |
| naurisk                       |
| newtest1                      |
| performance_schema            |
| preces                        |
| restorans                     |
| restoransak                   |
| skola1                        |
| skola_kr                      |
| skola_rkuc                    |
| skolaa                        |
| stunda                        |
| sys                           |
| tikls                         |
| veikals                       |
| veikals1                      |
| veikals_babisko               |
| veikals_nenormalizeta         |
| veikals_rkuc                  |
| veikalsak24                   |
| veikalseb24                   |
| veikalu_tikls                 |
| ving1_valters                 |
| ving3_valters                 |
| vingr1                        |
| vingr1_                       |
| vingr1_rkuc                   |
| vingr1_valters                |
| vingr2_valters                |
| vingr3_arvis                  |
| vingr3_valters                |
| vingr4_arvis                  |
| vingr4_valters                |
| vingr4_ziemelis               |
| vingrin3                      |
| vingrin4                      |
| vingrin4_armands              |
+-------------------------------+
54 rows in set (0.02 sec)

mysql> show tables;
+--------------------------------------+
| Tables_in_izglitibas_iestade_sdambis |
+--------------------------------------+
| audzekni                             |
| grupas                               |
| komisijas                            |
| kvalifikacijas                       |
| maca                                 |
| macas                                |
| pasniedz                             |
| prieksmeti                           |
| skolotaji                            |
+--------------------------------------+
9 rows in set (0.00 sec)

mysql> select a.* from audzekni AS a inner join grupas as gr ON a.grupa=gr.id where gr.nosaukums "D4-1";
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 '"D4-1"' at line 1
mysql> select a.* from audzekni AS a inner join grupas as gr ON a.grupa=gr.id where gr.nosaukums="D4-1";
ERROR 1146 (42S02): Table 'izglitibas_iestade_sdambis.audzekni' doesn't exist
mysql> select a.* from audzekni AS a inner join grupas as gr ON a.grupa=gr.id where gr.nosaukums="D4-1";
ERROR 1146 (42S02): Table 'izglitibas_iestade_sdambis.audzekni' doesn't exist
mysql> select a.* from audzekni AS a inner join grupas as gr ON a.grupa=gr.id where gr.nosaukums="D4-1";
ERROR 1146 (42S02): Table 'izglitibas_iestade_sdambis.audzekni' doesn't exist
mysql> show tables audzekni;
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 'audzekni' at line 1
mysql> describe audzekni;
ERROR 1146 (42S02): Table 'izglitibas_iestade_sdambis.audzekni' doesn't exist
mysql> show tables;
+--------------------------------------+
| Tables_in_izglitibas_iestade_sdambis |
+--------------------------------------+
| audzekni                             |
| grupas                               |
| komisijas                            |
| kvalifikacijas                       |
| maca                                 |
| macas                                |
| pasniedz                             |
| prieksmeti                           |
| skolotaji                            |
+--------------------------------------+
9 rows in set (0.00 sec)

mysql> describe grupas;
ERROR 1146 (42S02): Table 'izglitibas_iestade_sdambis.grupas' doesn't exist
mysql> select * from Audzekni as a where vards like "P*";
ERROR 1146 (42S02): Table 'izglitibas_iestade_sdambis.audzekni' doesn't exist
mysql> select * from Audzekni as a where vards like "P%";
ERROR 1146 (42S02): Table 'izglitibas_iestade_sdambis.audzekni' doesn't exist
mysql> show databases;
+-------------------------------+
| Database                      |
+-------------------------------+
| information_schema            |
| armands                       |
| d_kotelnikovs_kd              |
| db_name                       |
| db_name2                      |
| db_namel                      |
| errortesting                  |
| galdini                       |
| internetveikals               |
| ivkins_kd                     |
| ivkins_veikals_normal         |
| izglitibas_iestade_akidanovs  |
| izglitibas_iestade_kbrikmanis |
| izglitibas_iestade_sdambis    |
| izglitibas_iestade_vuzvards   |
| kb                            |
| kdv3                          |
| mysql                         |
| naurisk                       |
| newtest1                      |
| performance_schema            |
| preces                        |
| restorans                     |
| restoransak                   |
| skola1                        |
| skola_kr                      |
| skola_rkuc                    |
| skolaa                        |
| stunda                        |
| sys                           |
| tikls                         |
| veikals                       |
| veikals1                      |
| veikals_babisko               |
| veikals_nenormalizeta         |
| veikals_rkuc                  |
| veikalsak24                   |
| veikalseb24                   |
| veikalu_tikls                 |
| ving1_valters                 |
| ving3_valters                 |
| vingr1                        |
| vingr1_                       |
| vingr1_rkuc                   |
| vingr1_valters                |
| vingr2_valters                |
| vingr3_arvis                  |
| vingr3_valters                |
| vingr4_arvis                  |
| vingr4_valters                |
| vingr4_ziemelis               |
| vingrin3                      |
| vingrin4                      |
| vingrin4_armands              |
+-------------------------------+
54 rows in set (0.00 sec)

mysql> use izglitibas_iestade_SDambis;
Database changed
mysql> select * from Audzekni as a where vards like "P%";
ERROR 1146 (42S02): Table 'izglitibas_iestade_sdambis.audzekni' doesn't exist
mysql> use izglitibas_iestade_SDambis1
Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_izglitibas_iestade_sdambis1 |
+---------------------------------------+
| audzekni                              |
| grupas                                |
| komisijas                             |
| kvalifikacijas                        |
| maca                                  |
| macas                                 |
| pasniedz                              |
| prieksmeti                            |
| skolotaji                             |
+---------------------------------------+
9 rows in set (0.00 sec)

mysql> select * from (kvalifikacijas as kv inner join grupas as gr on kv.id=gr.kvalifikacija) inner join audzekni as a on gr.id=a.grupa where kv.nosaukums like "prog%";
+----+-------------------------+----+-----------+---------------+----+----------+-----------+------------+-------+
| id | nosaukums               | id | nosaukums | kvalifikacija | id | vards    | uzvards   | dzimdiena  | grupa |
+----+-------------------------+----+-----------+---------------+----+----------+-----------+------------+-------+
|  1 | Programmesanas tehnikis |  1 | D4-1      |             1 | 10 | Olegs    | Mongols   | 1974-07-12 |     1 |
|  1 | Programmesanas tehnikis |  1 | D4-1      |             1 | 11 | Ruslans  | Gitlemans | 1998-04-29 |     1 |
|  1 | Programmesanas tehnikis |  1 | D4-1      |             1 | 12 | Janis    | Berzins   | 2000-09-11 |     1 |
|  1 | Programmesanas tehnikis |  2 | D4-2      |             1 |  7 | Raimonds | Smelteris | 2000-09-11 |     2 |
|  1 | Programmesanas tehnikis |  2 | D4-2      |             1 |  8 | Aleksis  | Plats     | 2000-07-11 |     2 |
|  1 | Programmesanas tehnikis |  2 | D4-2      |             1 |  9 | Pavels   | Zuravlovs | 2000-01-01 |     2 |
+----+-------------------------+----+-----------+---------------+----+----------+-----------+------------+-------+
6 rows in set (0.01 sec)

mysql> select a.id, concat(a.vards, " ", Ucase(a.uzvards)) from (kvalifikacijas as kv inner join grupas as gr on kv.id=gr.kvalifikacija) inner join audzekni as a on gr.id=a.grupa where kv.nosaukums like "prog%";
+----+----------------------------------------+
| id | concat(a.vards, " ", Ucase(a.uzvards)) |
+----+----------------------------------------+
| 10 | Olegs MONGOLS                          |
| 11 | Ruslans GITLEMANS                      |
| 12 | Janis BERZINS                          |
|  7 | Raimonds SMELTERIS                     |
|  8 | Aleksis PLATS                          |
|  9 | Pavels ZURAVLOVS                       |
+----+----------------------------------------+
6 rows in set (0.00 sec)

mysql> select a.id, concat(a.vards, " ", Ucase(a.uzvards) as Vards Uzvards) from (kvalifikacijas as kv inner join grupas as gr on kv.id=gr.kvalifikacija) inner join audzekni as a on gr.id=a.grupa where kv.nosaukums like "prog%";
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 'Uzvards) from (kvalifikacijas as kv inner join grupas as gr on kv.id=gr.kvalifik' at line 1
mysql> select a.id, concat(a.vards, " ", Ucase(a.uzvards) as Vards_Uzvards) from (kvalifikacijas as kv inner join grupas as gr on kv.id=gr.kvalifikacija) inner join audzekni as a on gr.id=a.grupa where kv.nosaukums like "prog%";
ERROR 1583 (42000): Incorrect parameters in the call to native function 'concat'
mysql> select a.id, concat(a.vards, " ", Ucase(a.uzvards) as "Vards Uzvards") from (kvalifikacijas as kv inner join grupas as gr on kv.id=gr.kvalifikacija) inner join audzekni as a on gr.id=a.grupa where kv.nosaukums like "prog%";
ERROR 1583 (42000): Incorrect parameters in the call to native function 'concat'
mysql> select a.id, concat(a.vards, " ", Ucase(a.uzvards)) as "Vards Uzvards" from (kvalifikacijas as kv inner join grupas as gr on kv.id=gr.kvalifikacija) inner join audzekni as a on gr.id=a.grupa where kv.nosaukums like "prog%";
+----+--------------------+
| id | Vards Uzvards      |
+----+--------------------+
| 10 | Olegs MONGOLS      |
| 11 | Ruslans GITLEMANS  |
| 12 | Janis BERZINS      |
|  7 | Raimonds SMELTERIS |
|  8 | Aleksis PLATS      |
|  9 | Pavels ZURAVLOVS   |
+----+--------------------+
6 rows in set (0.00 sec)

mysql> select a.uzvards, a.dzimdiena, YEAR(a.dzimdiena), month(a.dzimdiena), day(a.dzimdiena), YEAR(curdate()-YEAR(a.dzimdiena) from audzekni as 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 'from audzekni as a' at line 1
mysql> select a.uzvards, a.dzimdiena, YEAR(a.dzimdiena), month(a.dzimdiena), day(a.dzimdiena), YEAR(curdate()-YEAR(a.dzimdiena) from audzekni;
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 'from audzekni' at line 1
mysql> select a.uzvards, a.dzimdiena, YEAR(a.dzimdiena), month(a.dzimdiena), day(a.dzimdiena), YEAR(curdate()-YEAR(a.dzimdiena) from audzekni as 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 'from audzekni as a' at line 1
mysql> select a.uzvards, a.dzimdiena, YEAR(a.dzimdiena), month(a.dzimdiena), day(a.dzimdiena), YEAR(curdate())-YEAR(a.dzimdiena) from audzekni as a;
+------------+------------+-------------------+--------------------+------------------+-----------------------------------+
| uzvards    | dzimdiena  | YEAR(a.dzimdiena) | month(a.dzimdiena) | day(a.dzimdiena) | YEAR(curdate())-YEAR(a.dzimdiena) |
+------------+------------+-------------------+--------------------+------------------+-----------------------------------+
| Brikmanis  | 2000-04-26 |              2000 |                  4 |               26 |                                19 |
| Sergejevs  | 2000-06-05 |              2000 |                  6 |                5 |                                19 |
| Petrasenko | 1999-10-17 |              1999 |                 10 |               17 |                                20 |
| Skuja      | 2000-12-21 |              2000 |                 12 |               21 |                                19 |
| Mitrikis   | 2000-10-12 |              2000 |                 10 |               12 |                                19 |
| Rutkovskis | 2000-05-18 |              2000 |                  5 |               18 |                                19 |
| Smelteris  | 2000-09-11 |              2000 |                  9 |               11 |                                19 |
| Plats      | 2000-07-11 |              2000 |                  7 |               11 |                                19 |
| Zuravlovs  | 2000-01-01 |              2000 |                  1 |                1 |                                19 |
| Mongols    | 1974-07-12 |              1974 |                  7 |               12 |                                45 |
| Gitlemans  | 1998-04-29 |              1998 |                  4 |               29 |                                21 |
| Berzins    | 2000-09-11 |              2000 |                  9 |               11 |                                19 |
+------------+------------+-------------------+--------------------+------------------+-----------------------------------+
12 rows in set (0.00 sec)

mysql> select s.talrunis, s.vards, s.uzvards, s.stazs from (skolotaji as s inner join  pasniedz as pas on s.talrunis=pas.skolotajs) inner join prieksmeti as p on p.id=pas.prieksmets where p.nosaukums="Datubazes";
Empty set (0.00 sec)

mysql> select s.talrunis, s.vards, s.uzvards, s.stazs from (skolotaji as s inner join  pasniedz as pas on s.talrunis=pas.skolotajs) inner join prieksmeti as p on p.id=pas.prieksmets where p.nosaukums="Datubaze";
Empty set (0.00 sec)

mysql> select s.talrunis, s.vards, s.uzvards, s.stazs from (skolotaji as s inner join  pasniedz as pas on s.talrunis=pas.skolotajs) inner join prieksmeti as p on p.id=pas.prieksmets where p.nosaukums="Operetajsistemas";
+----------+--------+---------+-------+
| talrunis | vards  | uzvards | stazs |
+----------+--------+---------+-------+
| 22222222 | Jurijs | Kudrins |    25 |
+----------+--------+---------+-------+
1 row in set (0.00 sec)

mysql>