Baza yaratildi va jadvallar yaratildi Codlari

-> telefon VARCHAR(14) NOT NULL,
-> oq_soni INT(5) NOT NULL,
-> FOREIGN KEY (fakultet) REFERENCES fakultetlar(NOMI)
-> );
Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE oq_guruxlari ( -> NOMI VARCHAR(20) PRIMARY KEY,
-> T_soni INT(5) NOT NULL,
-> Q_yili INT(3) NOT NULL,
-> O_kursi INT(3) NOT NULL
-> );
Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE talaba ( -> T_Id INT(11) PRIMARY KEY,
-> name TEXT NOT NULL,
-> Fam TEXT NOT NULL,
-> Guruh TEXT NOT NULL
-> );
Query OK, 0 rows affected (0.02 sec)

2. show tables; mysql> show tables;
+-----------------------+
| Tables_in_universitet |
+-----------------------+
| fakultetlar |
| kafedra |
| oq_guruxlari |
| talaba |
+-----------------------+
4 rows in set (0.00 sec)

Yaratgan jadvallarimiz

Malumotlar qushildi

Kiritgan malumotlarimiz mysql> select*from kafedra; +----------+-----------+-------------+-------------+-------------+-------------+---------+
| K_nomi | fakultet | MUDIR_F_I_O | bino_raqami | xona_raqami | telefon | oq_soni |
+----------+-----------+-------------+-------------+-------------+-------------+---------+
| Kafedra1 | Fakultet1 | Director1 | 201 | 301 | [phone] | 15 |
| Kafedra2 | Fakultet2 | Director2 | 202 | 302 | [phone] | 20 |
| Kafedra3 | Fakultet3 | Director3 | 203 | 303 | [phone] | 25 |
+----------+-----------+-------------+-------------+-------------+-------------+---------+
3 rows in set (0.00 sec)
mysql> select*from fakultetlar;
+-----------+-------------+-------------+-------------+------------+
| NOMI | DEKAN_F_I_O | sekretar | TEL | BINO_RAQAM |
+-----------+-------------+-------------+-------------+------------+
| Fakultet1 | Dean Name 1 | Secretary 1 | [phone] | 101 |
| Fakultet2 | Dean Name 2 | Secretary 2 | [phone] | 102 |
| Fakultet3 | Dean Name 3 | Secretary 3 | [phone] | 103 |
+-----------+-------------+-------------+-------------+------------+
3 rows in set (0.00 sec)
mysql> select*from talaba;
+------+--------+----------+-------+
| T_Id | name | Fam | Guruh |
+------+--------+----------+-------+
| 1 | Ismail | Abdulov | A-101 |
| 2 | Nigora | Qodirova | B-202 |
| 3 | Sardor | Ahmedov | C-303 |
+------+--------+----------+-------+
3 rows in set (0.00 sec)

And or not where ga misol
mysql> SELECT * FROM kafedra
-> WHERE bino_raqami = 202 AND xona_raqami > 301;
+----------+-----------+-------------+-------------+-------------+------------+---------+
| K_nomi | fakultet | MUDIR_F_I_O | bino_raqami | xona_raqami | telefon | oq_soni |
+----------+-----------+-------------+-------------+-------------+------------+---------+
| Kafedra2 | Fakultet2 | Director2 | 202 | 302 | [phone] | 20 |
+----------+-----------+-------------+-------------+-------------+------------+---------+ 1 row in set (0.00 sec)
mysql> SELECT * FROM talaba
-> WHERE Guruh = 'A-101' OR name = 'Nigora';
+------+--------+----------+-------+
| T_Id | name | Fam | Guruh |
+------+--------+----------+-------+
| 1 | Ismail | Abdulov | A-101 |
| 2 | Nigora | Qodirova | B-202 |
+------+--------+----------+-------+
2 rows in set (0.00 sec)
mysql> SELECT * FROM fakultetlar
-> WHERE NOT DEKAN_F_I_O = 'Dean Name 2';
+-----------+-------------+-------------+-------------+------------+
| NOMI | DEKAN_F_I_O | sekretar | TEL | BINO_RAQAM |
+-----------+-------------+-------------+-------------+------------+
| Fakultet1 | Dean Name 1 | Secretary 1 | [phone] | 101 |
| Fakultet3 | Dean Name 3 | Secretary 3 | [phone] | 103 |
+-----------+-------------+-------------+-------------+------------+
2 rows in set (0.00 sec)