Создание запросов к базе данных в среде Mysql

| Field | Type | Null | Key | Default | Extra |

жүктеу/скачать 0.83 Mb. Pdf көрінісі бет 4/7 Дата 12.09.2022 өлшемі 0.83 Mb. #460572 түрі Занятие

Бұл бет үшін навигация:

• | year | int(11) | YES | | NULL | | | srball | float | YES | | NULL | | | mestoid | int(11) | YES | MUL | NULL | |
• | Field | Type | Null | Key | Default | Extra | +----------+----------+------+-----+---------+-------+ | specID | int(11) | NO | PRI | 0 | |
• +--------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+----------+------+-----+---------+-------+
• +--------+----------+------+-----+---------+-------+ DESCRIBE mesto; +---------+----------+------+-----+---------+-------+
• | mesto | char(20) | YES | | NULL | | +---------+----------+------+-----+---------+-------+

| 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;  +----------+----------+------+-----+---------+-------+  | Field | Type | Null | Key | Default | Extra |  +----------+----------+------+-----+---------+-------+  | 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. Проверить наличие информации в таблицах. Результат должен иметь вид, показанный ниже.  жүктеу/скачать 0.83 Mb. Достарыңызбен бөлісу: