O'zbеkiston respublikasi axborot texnologiyalari va kommunikatsiyalarini rivojlantirish vazirligi muhammad al-xorazmiy nomidagi toshkеnt axborot tеxnologiyalari univеrsitеti

Download 1.86 Mb.
bet	4/4
Sana	31.07.2023
Hajmi	1.86 Mb.
	#77747

Bog'liq
amaliy ish 7-15
2-mustaqil ish, doniyor malumotlar bazasi 1-6

. View yaratilishi . Yaratilgan Viewdagi ma’lumotlarni ko’rish Mavzu: SQLda protseduralar yaratish dorixona_ishchilari jadvalidagi malumotlarni korish . Chiqarish() prosedurasini ishga tushirish natijasi max() funksiyasi qatnashgan procedure yaratish , chaqirish va katta yoshdagi prosedureni chiqarish amallari orqali olingan amallar Mavzu: SQLda triggerlar yaratish . AptekachiO jadvalini yaratish . Aptekachi jadvalidagi ma’lumotlarni ko'rish so'rovi . Aptekachi _yangilash triggerini yaratish Aptekachi0 jadvalidagi ma’lumotlarni ko'rish so'rovi . Aptekachi jadvalida update operatorini ishlatilishi . Update operatorini ishlatgandan keyin Aptekachi jadvalidagi ma’lumotlar . Update opertaorini ishlatgandan keying AptekachiO jadvali Aptekachi _yangilash triggerini yaratish . Update operatorini ishlatilganidan keyin AptekachiO jadvalidagi ma’lumotlarning o’zgarishi . Aptekachi jadvalidagi Update operatorini qo'llagandan keying o'zgarishlar . Aptekachi _kiritish_oldin triggerini yaratish so'rovi . Aptekachi _kiritish_oldin triggerni ishlashi natijasi . Aptekachi_kiritish_keyin triggerini yaratish so'rovi . Aptekachi_kiritish_keyin triggerining ishlash natijasi . Aptekachi_ochirish_oldin triggerini yaratish AptekachiO jadvalidan satr o'chirish natijasi . Aptekachi_ochirish_keyin triggerini yaratish . AptekachiO jadvalidan satr o'chirish natijasi . Ma’lumotlar bazasidagi triggerni o’chirish #include #include int main() { MYSQL* connection; connection = mysql_init(nullptr); if (connection == nullptr) { std::cerr << "MySQL initialization failed!" << std::endl; return 1; } // Ma'lumotlar bazasiga bog'lanish if (mysql_real_connect(connection, "host", "user", "password", "database", 0, nullptr, 0) == nullptr) { std::cerr << "Connection to MySQL failed!" << std::endl; return 1; } // Jadval yaratish so'rovi std::string createTableQuery = "CREATE TABLE IF NOT EXISTS students (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT, group_number INT);"; // Jadval yaratish if (mysql_query(connection, createTableQuery.c_str())) { std::cerr << "Error creating table: " << mysql_error(connection) << std::endl; return 1; } // Ma'lumotlarni saqlash std::string insertDataQuery = "INSERT INTO students (name, age, group_number) VALUES ('John', 22, 101), ('Jane', 20, 102);"; // Ma'lumotlarni saqlash if (mysql_query(connection, insertDataQuery.c_str())) { std::cerr << "Error inserting data: " << mysql_error(connection) << std::endl; return 1; } // Ma'lumotlarni o'qish std::string selectDataQuery = "SELECT * FROM students;"; // Ma'lumotlarni o'qish if (mysql_query(connection, selectDataQuery.c_str())) { std::cerr << "Error reading data: " << mysql_error(connection) << std::endl; return 1; } MYSQL_RES* result = mysql_store_result(connection); if (result != nullptr) { MYSQL_ROW row; while ((row = mysql_fetch_row(result))) { std::cout << "ID: " << row[0] << ", Name: " << row[1] << ", Age: " << row[2] << ", Group Number: " << row[3] << std::endl; } mysql_free_result(result); } mysql_close(connection); return 0; } Download 1.86 Mb.

Download 1.86 Mb.