JsonSQL Demo

• 🏠 Übersicht
• 📖 Kurse
• 👩‍🏫 Dozenten
• 🏫 Klassen
• 🧑‍🎓 Studenten
• 📌 Belegungen
• 🛠️ MySQL Export

🛠️ MySQL Export

Exportiere die aktuelle Datenstruktur als CREATE TABLE-Statements im MySQL-Format.

Tabelle: classes

-- Datenexport für Tabelle: `classes`

-- Block 1
START TRANSACTION;
INSERT INTO `classes` (`id`, `name`, `room`, `teacher_id`, `created_at`, `updated_at`) VALUES (11, '11B', 'E505', 56, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `classes` (`id`, `name`, `room`, `teacher_id`, `created_at`, `updated_at`) VALUES (12, 'Q2', 'E505', 51, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `classes` (`id`, `name`, `room`, `teacher_id`, `created_at`, `updated_at`) VALUES (13, '10B', 'E505', 56, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `classes` (`id`, `name`, `room`, `teacher_id`, `created_at`, `updated_at`) VALUES (14, '11A', 'C303', 52, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
INSERT INTO `classes` (`id`, `name`, `room`, `teacher_id`, `created_at`, `updated_at`) VALUES (15, 'Q1', 'D404', 58, '2025-04-20 23:10:52', '2025-04-20 23:10:52');
COMMIT;

Tabelle	Aktion
🗂️ classes	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🗂️ courses	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🗂️ enrollments	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🗂️ students	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🗂️ teachers	📄 CREATE 🧾 INSERTs 📦 Komplett (CREATE + INSERT)
🛢️ Alle Tabellen	📄 CREATE (alle) 🧾 INSERTs (alle) 📦 Komplett (alle)