converters/json-to-mysql.title

[
  {
    "id": 1,
    "name": "Alice",
    "age": 30,
    "email": "alice@example.com",
    "is_active": true
  },
  {
    "id": 2,
    "name": "Bob",
    "age": 25,
    "email": "bob@example.com",
    "is_active": false
  }
]

CREATE TABLE `users` (
  `age` INT NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `id` INT NOT NULL,
  `is_active` TINYINT(1) NOT NULL,
  `name` VARCHAR(255) NOT NULL
);

INSERT INTO `users` (`age`, `email`, `id`, `is_active`, `name`) VALUES
(30, 'alice@example.com', 1, 1, 'Alice'),
(25, 'bob@example.com', 2, 0, 'Bob');

[
  {
    "order_id": 1001,
    "user": {
      "id": 1,
      "name": "Alice"
    },
    "items": [
      { "sku": "A001", "qty": 2 },
      { "sku": "B002", "qty": 1 }
    ],
    "total": 199.9,
    "created_at": "2025-01-01T12:00:00Z"
  }
]

CREATE TABLE `orders` (
  `created_at` DATETIME NOT NULL,
  `items` JSON NOT NULL,
  `order_id` INT NOT NULL,
  `total` DOUBLE NOT NULL,
  `user` JSON NOT NULL
);

INSERT INTO `orders` (`created_at`, `items`, `order_id`, `total`, `user`) VALUES
('2025-01-01T12:00:00Z', '[{"sku":"A001","qty":2},{"sku":"B002","qty":1}]', 1001, 199.9, '{"id":1,"name":"Alice"}');