| Field | Type | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| studID | int(11) | NO | PRI | 0 | |
| fio | char(20) | YES | | NULL | |
| gr | int(11) | YES | | NULL | |
| specid | int(11) | YES | MUL | NULL | |
| stcode | int(11) | YES | MUL | NULL | |
| year | int(11) | YES | | NULL | |
| srball | float | YES | | NULL | |
| mestoid | int(11) | YES | MUL | NULL | |
+---------+----------+------+-----+---------+-------+
DESCRIBE spec;
+----------+----------+------+-----+---------+-------+
+----------+----------+------+-----+---------+-------+
| specID | int(11) | NO | PRI | 0 | |
| spec | char(8) | YES | | NULL | |
| specname | char(20) | YES | | NULL | |
+----------+----------+------+-----+---------+-------+
DESCRIBE stipend;
| Field | Type | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| stcode | int(11) | NO | PRI | 0 | |
| stname | char(20) | YES | | NULL | |
| stsize | int(11) | YES | | NULL | |
+--------+----------+------+-----+---------+-------+
DESCRIBE mesto;
+---------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+----------+------+-----+---------+-------+
| mestoID | int(11) | NO | PRI | 0 | |
| mesto | char(20) | YES | | NULL | |
+---------+----------+------+-----+---------+-------+
3. Проверить наличие информации в таблицах. Результат должен иметь вид, показанный ниже.
Достарыңызбен бөлісу: |