Baza yaratildi va jadvallar yaratildi Codlari

Universitet mavzusi

Baza yaratildi va jadvallar yaratildi Codlari

mysql> create table universitet; ERROR 1046 (3D000): No database selected mysql> create database universitet;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+-----------------------+
| Database |
+-----------------------+
| information_schema |
| aereport |
| ehtiyot_qismlari |
| idora |
| kutubxona |
| lombard |
| mashinalar |
| masulyatni_taqsimlash |
| mehmonxona |
| mysql |
| notarial_idora |
| oquv_yuklamasi |
| sayohat_kompaniyasi |
| sugurta |
| tayyor_mahsulotlar |
| test |
| universitet |
+-----------------------+
17 rows in set (0.01 sec)
mysql> use universitet; Database changed mysql> CREATE TABLE fakultetlar ( -> NOMI VARCHAR(20) PRIMARY KEY,
-> DEKAN_F_I_O VARCHAR(20) NOT NULL,
-> sekretar CHAR(30),
-> TEL VARCHAR(14) NOT NULL,
-> BINO_RAQAM INT(3) NOT NULL
-> );
Query OK, 0 rows affected (0.04 sec)
mysql> CREATE TABLE fanlar ( -> T_Id INT(11) PRIMARY KEY,
-> nomi TEXT NOT NULL,
-> Baho INT(11),
-> FOREIGN KEY (Baho) REFERENCES fakultetlar(BINO_RAQAM)
-> );
ERROR 1005 (HY000): Can't create table
'universitet.fanlar' (errno: 150)
mysql> CREATE TABLE kafedra ( -> K_nomi CHAR(30) PRIMARY KEY,
-> fakultet CHAR(20) NOT NULL,
-> MUDIR_F_I_O CHAR(30) NOT NULL,
-> bino_raqami INT(3) NOT NULL,
-> xona_raqami INT(3) NOT NULL,