JsonSQL Demo

🛠️ MySQL Export

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

Tabelle: classes

-- CREATE TABLE für `classes`
DROP TABLE IF EXISTS `classes`;
CREATE TABLE `classes` (
  `id` INT AUTO_INCREMENT,
  `name` VARCHAR(255),
  `room` VARCHAR(10),
  `teacher_id` INT,
  `created_at` DATETIME,
  `updated_at` DATETIME,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB CHARACTER SET=utf8mb4;

-- 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)