mysql数据库字段 数组

-- 示例：插入JSON数据
INSERT INTO users (id, hobbies) VALUES (1, '["reading", "swimming"]');

-- 示例：查询JSON数据
SELECT JSON_EXTRACT(hobbies, '$[0]') AS first_hobby FROM users WHERE id = 1;

-- 示例：主表
CREATE TABLE users (
  id INT PRIMARY KEY,
  name VARCHAR(255)
);

-- 示例：关联表
CREATE TABLE user_hobbies (
  id INT PRIMARY KEY,
  user_id INT,
  hobby VARCHAR(255),
  FOREIGN KEY (user_id) REFERENCES users(id)
);

-- 示例：插入数据
INSERT INTO users (id, name) VALUES (1, 'Alice');
INSERT INTO user_hobbies (id, user_id, hobby) VALUES (1, 1, 'reading');
INSERT INTO user_hobbies (id, user_id, hobby) VALUES (2, 1, 'swimming');

-- 示例：查询数据
SELECT users.name, user_hobbies.hobby
FROM users
JOIN user_hobbies ON users.id = user_hobbies.user_id;