mysql拆分json数据

{
  "id": 1,
  "name": "Alice",
  "email": "alice@example.com",
  "address": {
    "street": "123 Main St",
    "city": "Anytown",
    "state": "CA",
    "zip": "12345"
  }
}

CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(255),
  email VARCHAR(255),
  street VARCHAR(255),
  city VARCHAR(255),
  state VARCHAR(255),
  zip VARCHAR(255)
);

INSERT INTO users (id, name, email, street, city, state, zip)
SELECT
  JSON_EXTRACT(json_data, '$.id') AS id,
  JSON_EXTRACT(json_data, '$.name') AS name,
  JSON_EXTRACT(json_data, '$.email') AS email,
  JSON_EXTRACT(json_data, '$.address.street') AS street,
  JSON_EXTRACT(json_data, '$.address.city') AS city,
  JSON_EXTRACT(json_data, '$.address.state') AS state,
  JSON_EXTRACT(json_data, '$.address.zip') AS zip
FROM (
  SELECT '{"id": 1, "name": "Alice", "email": "alice@example.com", "address": {"street": "123 Main St", "city": "Anytown", "state": "CA", "zip": "12345"}}' AS json_data
) AS temp;